Advance MS Excel for Business


Course Details

Advanced Microsoft Excel for Business is a 24-hour course that teaches participants how to use the Microsoft Excel at advanced level. This course aims to enhance participants to gain the necessary practical experience by using hands-on exercises simulating real life business analysis scenarios.

Course Content

  • Using Advance functions
  • Working with data series
  • Using scenario and goal seeking
  • Using worksheet protection
  • Using conditional and custom formats
  • Consolidating worksheets
  • Creating, Revising pivot tables
  • Sharing Workbooks
  • Using Data Tables
  • Using auditing tools
  • Using Macros
  • Recording Macros


Entry Qualification

Basic Knowledge of Excel spreadsheet management, Calculations.


Certificate will be awarded to Trainees with 80% attendance

Certification Awarding Body

Focus Education Centre


Certificate IV




Middle Managers

Senior Management