Advanced Excel Course

Malvern International Academy Pte Ltd


Course introduction

Microsoft Advanced Excel Course is a 2-day training course in Singapore covering Advanced Features, Functions and Formulas of Microsoft Excel.



Target Audience


Student should have basic knowledge of Microsoft Office Excel, including but not limited to how to create, edit, format, and print worksheets as well as insert and use basic formulas (like sum, autosum).



Course Outline


  • Working With Functions
  • Work with Ranges name
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date & Time Functions
  • Work with Text Functions
  • Working With Lists
  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data
  • Analyzing Data
  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting
  • Visualizing Data With Charts
  • Create a PivotTable
  • Modify and Format Charts
  • Use Advanced Chart Features
  • Using PivotTables And Pivot Charts
  • Create and Modify Tables
  • Analyze PivotTable Data
  • Present Data with Pivot Charts
  • Filter Data by Using Timelines and Slicers
  • 2nd Day Advanced Excel Training Course Outlines:
  • For people who have a need to consolidate, collaborate with others when working with Excel and want to automate their simple repetitive tasks in Excel with Macro.
  • Working With Multiple Worksheets And Workbooks
  • Use Links and External References
  • Use 3-D References
  • Consolidate Data
  • Using Lookup Functions And Formula Auditing
  • Use Lookup Functions
  • Trace Cells
  • Watch and Evaluate Formulas
  • Sharing And Protecting Workbooks
  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks
  • Automating Workbook Functionality
  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Work with Macros
  • Creating Sparklines And Mapping Data
  • Create Sparklines
  • Map Data
  • Forecasting Data
  • Determine Potential Outcomes using Data Tables
  • Determine Potential Outcomes using Scenarios
  • Use the Goal Seek Feature
  • Forecasting Data Trends



Available Course Sessions


Course Date, Time Reg. Closes On
1 30 Nov' 19 to 01 Dec' 19, 9.00am to 5.00pm 27 Nov' 19 Register Now
2 07 Dec' 19 to 08 Dec' 19, 9.00am to 5.00pm 04 Dec' 19 Register Now
3 21 Dec' 19 to 22 Dec' 19, 9.00am to 5.00pm 18 Dec' 19 Register Now



Trainer Profile


Ilampirai Nagarajan

IT graduate with over 4+ years of experience in the education industry. Attained MTech in computer science and engineering. Good programming, scripting, design and training skills. Flexible and versatile to adapt to any new environment and work on any project.



 

Top