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