Booking with a Training Ticket
Once you have booked your course, you will receive an email with your booking confirmation. The steps you will need to follow to access your online course will arrive in a separate email within 48 hours of your order being processed
Please be aware that participants will have access to this course for 120 days from the date of receiving access via email notification
Course Overview
This course explains how to build and operate spreadsheets for forecasting planning and business models. Its a practical guide, which takes a step-by-step approach to building models using Microsoft Excel.
Foundations of spreadsheet models
- What are the guiding principles of spreadsheet model
building?
- What are the key elements in a spreadsheet model?
- How do we structure the spreadsheet?
- What is the purpose and scope of the model?
- What are the definitions, assumptions and sources of
data?
- How do we achieve version control?
Building the model
- How do we input data?
- What are the intermediate calculations?
- What is the core model?
- What is the output data sheet?
- What about the executive summary?
- What goes into the appendices and user guide?
Scenario planning and sensitivity analysis
- How do we look at what-ifs and sensitivity analysis?
- What does the sensitivity analysis for our example
cashflow forecast look like?
- What about scenario planning?
- How can we use the model for decision making?
- How do we present the outputs of the model?
Building a spreadsheet model of your business
- What are the key principles of building the business?
- What is the structure of the business model?
- What about revenue streams?
- How do we plan and make decisions using the business
model?
- How do we maintain the business model?