Advanced Excel Course

SkillsFuture Credit Eligible Training Center Advanced Excel Course

Excel Course Singapore

Course Start Date

Duration: 2 Days

Venue: 10 Anson Road, 26-08A International Plaza, Singapore 079903

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

This Advanced Excel Training will be focusing on Pivot Table, VLookup, Hlook up, Filtering Data using Functions, Exporting and importing data, Basic Macros and many more tricks in Microsoft Excel.

This is a hands-on Excel training where you will be working on live exercises of each topic.

Target Student: 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).

  1st Day Advanced Excel Training Course Outlines:

For people with basic knowledge of Excel want to learn more about advanced formulas (text, math, date and time, logical, etc) and advanced tools like chart, sorting, filtering, conditional format, pivot table.

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

Our Clients