Building a spreadsheet forecasting model

Overview

Updated and improved with new content and enhanced social features.

Modern spreadsheet tools, like Microsoft Excel, make it easy to build a forecasting or business model. The problem is that the formulae can quickly become very 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 other people will have to use it and 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 models using Microsoft Excel.

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 a range of different techniques to assess the impact of potential changes in inputs or variables.

Learning outcomes

• foundations of spreadsheet models
• building the model
• scenario planning and sensitivity analysis
• building a spreadsheet model of your business.

Helping accountants grow

Disclaimer: This course is available for ACCA members, you may need your ACCA membership number to complete your booking. This course and outline is provided by a third-party course provider. All course bookings are subject to the terms and conditions set by the course provider. Please see individual supplier pages for full terms and conditions. ACCA takes no liability for bookings made with third-party supplier.