Enhance financial analysis skills using Microsoft Excel by learning financial modelling, forecasting, scenario analysis, dashboard creation, and automation techniques. This course helps participants build effective financial reports, analyse complex data, and improve productivity using advanced Excel tools and functions.
Programme Module
1
Finance Simplified Basics
2
Excel Tools & Functions
3
Building Financial Report
4
Building Dashboards
5
Recording & Running Macros
Programme Objectives
Learn how you can:
Be an Excel power-user with the aim of reducing non-value adding tasks.
Create Scenario Analysis and Dashboards.
Create drop-down boxed and scroll-bars for flash analysis.
Understand and apply Forecasting concepts and being able to track forecasting errors.
Apply certain new function appearing in Excel 2013 onwards.