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, this programme will not be suitable. Please explore the baseline topics offered here.
- 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, this programme will not be suitable. Please explore the baseline topics offered here.
L E A R N I N G O U T C O M E S
Designing to build robust budgeting & forecasting models in Excel
Applying advanced Excel functions within disciplined model layouts
Applying statistical methods (moving averages, regression) to real budget data
Consolidating cost centre data into live models
Applying version control and structured model design
Streamlining budgeting workflows and reduce manual effort
Reconciling statistical outputs with business judgement
Light automation using VBA
HRDC claimable.
Click here for course outline >
Click here for course outline >
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
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
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