8 Topics
5 Days
8 Sessions
Programme Overview
Training Description
Who Should Attend
- Chief Financial Officers (CFOs)
- Finance Directors and Finance Managers
- Financial Planning & Analysis (FP&A) Professionals
- Budget Managers, Budget Officers, and Budget Analysts
- Financial Controllers
- Accountants and Management Accountants
- Treasury Managers and Treasury Officers
- Investment Analysts and Financial Analysts
- Corporate Finance Professionals
Session Objectives
- Master advanced Excel functions relevant to budgeting and financial modeling (e.g., INDEX, MATCH, OFFSET, INDIRECT).
- Learn how to build dynamic and flexible financial models using advanced Excel formulas.
- Develop skills in performing scenario analysis and sensitivity testing using Excel tools like What-If Analysis.
- Master advanced data manipulation and cleaning techniques using Excel's Text to Columns, Flash Fill, and Remove Duplicates.
- Learn how to leverage Power Query (Get & Transform Data) to import, clean, and transform data from various sources.
- Develop skills in using Power Pivot to create and manage data models for complex financial analysis.
- Learn how to use Excel's data validation features to ensure data integrity in financial models.
About the Course
Professionals and organizations seeking to enhance financial modeling, budgeting accuracy, forecasting capability, and analytical decision-making using advanced Excel tools. Participants will gain practical skills in building dynamic financial models, creating budget templates, performing scenario analysis, automating calculations, analyzing financial data, developing forecasts, and producing professional reports that support effective financial planning and strategic decision-making.
Curriculum & Topics
8 Topics | 8 Sessions
-
Workshop 1.1:
N/A
-
Workshop 2.1:
N/A
-
Workshop 3.1:
N/A
-
Workshop 4.1:
N/A
-
Workshop 5.1:
N/A
-
Workshop 6.1:
N/A
-
Workshop 7.1:
N/A
-
Workshop 8.1:
N/A
