D I F F I C U L T Y L E V E LBASIC | INTERMEDIATE | ADVANCED | PROFESSIONAL
Basic: Start from zero, learn the essentials and use the tools correctly with confidence.Intermediate: Designed for users who know the basics who want to sharpen their skills for work scenarios.Advanced: Built for power users who want to handle complex data, scenarios, and evolving requirements. Professional: Multiple-skilled training. Designed for users who want to use multiple methods to build business-ready solutions.
Embedded Files
T A R G E T P A R T I C I P A N T SThis programme is suitable for professionals who:
If you are new to Excel or budgeting, it is recomended you attend the following learning sessions:
- Are advanced Excel users
- Have hands-on exposure to budgeting and forecasting
- Work in finance, FP&A, or shared services
- Are involved in budget preparation, consolidation, review, or forecasting
- Want to build robust, maintainable models, not just “working spreadsheets”
If you are new to Excel or budgeting, it is recomended you attend the following learning sessions:
L E A R N I N G O U T C O M E S
The course learning outcomes are:
Working knowledge in important Excel functions and Microsoft 365 Copilot-assisted modelling techniques.
Ability to relate to time series models, regression, confidence intervals and interpret regression outputs.
Ability to reconcile important statistics topics to finance cost & revenue structure.
Ability to build forecasting & budgeting templates independently using both traditional Excel techniques & Microsoft 365 Copilot where appropriate.
Knowing statistical & judgmental forecasting techniques.
Ability to use Power Query, Power Pivot and OLAP Pivot Tables in a basic way.
Ability to version-control multiple budget versions.
Ability to build dynamic scenarios with form controls.
Working knowledge in basic macro recording.
HRDC claimable.
Click here for course outline >
Click here for course outline >
FINANCIAL MODELLING FOR FORECASTING, BUDGETING & FINANCIAL STATEMENTS IN EXCEL
FINANCIAL MODELLING FOR FORECASTING, BUDGETING & FINANCIAL STATEMENTS IN EXCEL
Build Financial Models that Drive Business Performance.
A 2-day intensive training in Financial Modelling
DURATION: 2-DAYS (16 HOURS)
DIFFICULTY LEVEL: PROFESSIONAL
TARGET PARTICIPANTS
TARGET PARTICIPANTS
This is learning session is suitable for participants who perform roles related to forecasting & budgeting. This program is 65% Excel-focused; the balance of the 35% of content consisting of finance & statistical topics. The training aims to assist participants facing huge volumes of data by imparting tool ideas and skills which automate tasks & reduce the forecasting and budgeting cycle time.
The trainer recommends participants to acquire at least intermediate-level working knowledge of MS-Excel, as well as attending 2 other programs listed below to gain maximum benefit from this financial modelling program.
COURSE OBJECTIVES
COURSE OBJECTIVES
The course learning outcomes are:
Working knowledge in important Excel functions and Microsoft 365 Copilot-assisted modelling techniques.
Ability to relate to time series models, regression, confidence intervals and interpret regression outputs.
Ability to reconcile important statistics topics to finance cost & revenue structure.
Ability to build forecasting & budgeting templates independently using both traditional Excel techniques & Microsoft 365 Copilot where appropriate.
Knowing statistical & judgmental forecasting techniques.
Ability to use Power Query, Power Pivot and OLAP Pivot Tables in a basic way.
Ability to version-control multiple budget versions.
Ability to build dynamic scenarios with form controls.
Working knowledge in basic macro recording.
To ensure you gain the maximum benefit from this program, it is recommended that participants first complete two essential programs below. Because this training is an advanced level course that is 65% Excel-focused, you will need a solid technical foundation to successfully navigate the complex datasets and modeling techniques applied here.
1. Excel Formulas + Functions for Accountants
1. Excel Formulas + Functions for Accountants
This program ensures you are proficient in the core logic and syntax- such as logical functions (IFS, AND), nested formulas, and lookup-related functions- which are vital for building revenue and expense drivers. You will also master INDIRECT for dynamic referencing, the new dynamic arrays formula platform for spilled behavior, and conditional summing (SUMIFS) to handle the automated data tasks required in financial models.
2. Pivot Tables & Data Modelling for Accountants
2. Pivot Tables & Data Modelling for Accountants
This program provides you with the skills to manage massive volumes of data using Power Query and Data Modelling. These skills are necessary for the automated consolidation and rolling up of historical accounting data performed in the financial modelling session.
METHODOLOGY
METHODOLOGY
Instructor-led follow-along workshop. Excel-oriented and data-centric class incorporating Microsoft 365 Copilot demonstrations and guided exercises. Datasets provided.
SETUP REQUIREMENTS
SETUP REQUIREMENTS
Required software (Windows versions): Excel 365. Excel 2021 and Excel 2024 is acceptable. Participants of earlier Excel versions will have limited participation where new functions are taught and will need to self-edit certain formulas in their datasets.
For online training participants are encouraged to use two computer monitors (if available) and be webcam ready.
DURATION
DURATION
2 days
DIFFICULTY LEVEL
DIFFICULTY LEVEL
Advanced
OUTLINE
OUTLINE
1. Financial Models
1. Financial Models
Introduction & types of financial models
Program scope
Financial model structure
Budgeting & forecasting
The budgeting & forecasting process
Essential tools for a successful financial model
2. Forecasting methods
2. Forecasting methods
Qualitative and Quantitative forecasting methods
Naïve method, Simple Moving Average, Simple Weighted Moving Average, Exponential Smoothing, Correlation, Regression Analysis
Forecast Sheet function (applies to Excel 2016 & above), Multiple Regression Analysis
Coefficient Correlation, Coefficient of Determination
FORECAST, CORREL,RSQ, LINEST
Using Microsoft 365 Copilot- to interpret LINEST output & generating the regression equation (Y = a + b₁X₁ + b₂X₂ + …)
Central Limit Theorem, Normal Distribution
Using Excel’s Data Analysis tools for Exponential Smoothing, Moving Average and Regression Analysis
3. Building the budgeting & forecasting financial model
3. Building the budgeting & forecasting financial model
Building revenue & expense drivers
Revenue & cost projection
Modelling the Income Statement & supporting cost centre sheets
Incorporating headcount & payroll and fixed assets budgets
Projecting the balance sheet
4. Cashflow
4. Cashflow
Working capital components, ratios & cash conversion cycle
Cash flow projection using the direct method
Free Cash Flow (FCF)
5. Controls on form
5. Controls on form
Data validation lists and essential Form Controls
Incorporating Form Controls into financial models & sensitivity analysis
Advanced Conditional Formatting techniques
6. Consolidating & rolling up historical accounting data
6. Consolidating & rolling up historical accounting data
Techniques in rolling up massive number of cost centres worksheets into a single report
Techniques in extracting and consolidating historical data for revenue budgeting
Building sensitivity analysis mechanism into forecast templates
7. Important Excel functions
7. Important Excel functions
Essential Excel functions in financial modeling- VLOOKUP, SUMIF, SUMIFS, IFERROR, INDIRECT, IF, IFS, TEXTBEFORE, CELL
Multiple tools and techniques in automating mundane, repetitive tasks in financial modelling processes
8. Managing multiple budget versions
8. Managing multiple budget versions
Version controlling your budget forecast spreadsheets
Fitting in multiple budgets into your financial model
Course structure
Page updated
Report abuse