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:
- Forward-Looking Models
- Decision Trees
- Building an Influence Diagram
- Structuring Your Model in Excel
- Making Your Model Responsive
- Shortening Formulas with New Variables
- Risk-Weighted Cashflows
- Tornado Charts
- Updating Warnings for Charts
- Adding Taxes
- Building Multiple Scenarios
- Analyzing Our Scenarios
- Formula Auditing with Colorize
Key Outcomes
Once you have completed this course you will know how to
approach a very common business problem, should we make an investment in a new venture? You will know how diagram this type of problem, build a simplified financial 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.