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 very complex,and the structure of the model can get very unwieldy. The person who originally built the model may be able to navigate it well enough, but the people who have to use it,or want to study the outputs, may find it impenetrable.
What is needed is structure. A good spreadsheet model tells a story–it has a beginning, a middle, and an end.The model needs to be easy to understand, so that non-experts can see how changes in variables affect the model and can take ownership of it. Equally importantly, if the person who built the model is unavailable, someone else can take over and “drive” it without too much difficulty.
Building a Spreadsheet Forecasting Model will provide delegates with the skills they need to structure and develop a practical and effective spreadsheet forecasting or planning mode
The course will focus on building models for:
Key learning points
I am a Fellow of the Chartered Institute of Management Accountants specialising in process improvement. I have nearly 30 years experience in consultancy, facilitation and …