Microsoft Excel is one of the most powerful software used for analyzing data to make a better decision. It helps in data organization, data analysis, and data interpretation.

Finance professionals are frequently required to prepare management reports, scorecards, and dashboards. Attending this course will help participants use advanced Excel levels tools and features to produce such important reports. The course starts with pivot tables, the most important tool ever created to perform data reporting, analysis and reconciliation. It then continues with high level modelling techniques, integration and report visualization, and it ends with automation that is guaranteed to add value to participants' daily and periodic tasks. This course is specifically designed for finance professionals and is the perfect course for those working with budgets regularly.

Note: Good knowledge of Advanced Excel level and introduction to finance is a prerequisite for this course.

For whom:

This course is designed for finance and accounting professionals, management accountants and anyone looking to learn or extend their knowledge of using Excel to assist with financial decision-making in a business context.

Learning objectives:

At the end of the program, participants will be able to:

• use Excel is an essential tool for financial modelling;
• learn some key models in financial modelling using Excel;
• practice rolling forecasts using Excel; and
• tie up their financial models with dashboard reporting.