Booking Information
Once you have booked your course, the link to the recording will be available
in your "My Account" area.
Please be aware that you will have access to this course for 180 days from
the date of purchase
Online courses cannot be booked on behalf of someone else. Access will only
be granted to the person completing the online order.
Who Should Attend?
This course is suitable for advanced learners who are very familiar with writing formulas and performing analysis in Microsoft Excel. It is best suited to accountants, management consultants, analysts and other business professionals
Course Overview
This Kubicle course contains 18 lessons, 4 exercises and 1 Exam. It covers the following topics:
- Introduction to modelling
- Framing the problem
- Diagram the problem
- Lay out model in Excel
- Build simplified model
- Sensitivity analysis
- Prepare your dataset for modelling
- Estimating market demand
- Complex model formulas
- Perform checks on model
- Calculate model outputs
- Analyze risks in our model
- Goalseek & Solver
- Run scenarios using Pivot Tables
- Charts for sensitivity tables
- Limitations of the model
Key Outcomes
Once you have completed this course you will know how to frame a business problem, diagram the problem, build a model in Excel and analyse the results of the model so as to make an informed decision. This ability is hugely valuable to organisations who methods for making better decisions that lead ultimately, to better financial results.