Building a Spreadsheet Forecasting Model

This course will enable you to

• 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 the course

Modern spreadsheets are very powerful tools, and it is easy to build a forecasting or business model. The problem is that the formulae can quickly become complex, and the structure of the model can get very unwieldy. When building a spreadsheet model, you may be able to navigate it well enough, but if other people have to use it they may find it impenetrable.

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.