Advance MS Excel for Business

excel-advance

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.

Certification

Certificate will be awarded to Trainees with 80% attendance

Certification Awarding Body

Focus Education Centre