Building a spreadsheet forecasting model
A step-by-step approach to building, utilising, and maintaining models.
Partner products listed exclude VAT. You will be directed to an external site to complete purchase and VAT will be applied at checkout.
For your AAT exclusive discount apply AAT30 at partner checkout for an exclusive 30% off.
Course Type
E-learning
Length
3 - 5 hours
What you’ll achieve
- Establish the ground rules for building a spreadsheet model, including guiding principles and the core elements.
- Build a model including input data, intermediate calculation and output data.
- Put together an executive summary of your model along with any appendices necessary.
- Use scenario planning and sensitivity analysis to improve your spreadsheet models.
- Apply a range of different techniques to assess the impact of potential changes in inputs or variables.
- Maintain a business model and use it to make decisions.
About this course
This course explains how to build and operate spreadsheets for forecasting, planning and business models. It's a practical guide, which takes a step-by-step approach to building, utilising and maintaining models.
Overview
E-learning |
|
3 - 5 hours |
|
Business Performance Management |
Syllabus
The foundations of spreadsheet models
- The guiding principles of spreadsheet model building
- The importance of spreadsheet forecasting models
- The key elements in a spreadsheet model
- Structuring your spreadsheet
- Structuring your spreadsheet forecasting models
- The purpose and scope of the model
- Definitions, assumptions, and sources of data
- Achieving version control.
Building the model
- Inputting data into a model
- Understanding intermediate calculations
- Core models
- Executive summaries and model overview
- Appendices and user guides explained
- Using appendices.
Scenario planning and sensitivity analysis
- Model uses and what-if analysis
- Understanding sensitivity analysis
- Explaining scenario planning
- Presenting the outputs of the model
- The benefits of using sensitivity analysis.
Building a spreadsheet model of your business
- The key principles of building a business model
- Using a business model to inform decision-making
- Planning and decision-making
- Keeping your spreadsheet models up to date
- Maintaining the business model
- Four key purposes.
How to access
You will be directed to an external site to complete purchase and VAT will be applied at checkout.
