The course is designed to help course participants gain the knowledge and skills required to build professional spreadsheets, perform What-If analyses, apply functions, manipulate PivotTables, and use the advanced features of Excel to make and present better business decisions.

The objective of this course is to:

• Provide participants with the knowledge and skills required to use spreadsheets analyse data and present it for effective decision making.

At the end of this training programme, course participants shall be able to:

• Leverage features of Microsoft Excel to facilitate business decisions
• Develop intelligent worksheets to identify KPIs quickly
• Perform “What-if” analyses for developing business documents such as budgets and project plans.
• Summarize and analyze large amounts of data using Pivot tables and Excel features.
• Automate Excel processes.

1. Using Key Microsoft Excel Features
2. Developing Intelligent Worksheets
3. What-if Analysis
4. Using Pivot Tables and Other Key Features
5. Summarising and Presenting Business Information using Excel.

Participant’s profile or target groups are Managers, Engineers, and other suitably qualified personnel who use Microsoft Excel to analyse business data.