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.