Description
This course is presented in four parts.
First, the course introduces a business case of a financial model that allegedly “did it all wrong”. The model requires over 30 steps and over 1 hour just to report on a simple 1-measure report. This becomes a great candidate for this Model Makeover course.
Second, the course lists what makes a model great and how to achieve them:
- Accuracy
- Simplicity
- Robustness
Third, we illustrate the full skills of building the fully overhauled model that would only take 1 minute to generate the report with only 2 steps. The whole process includes:
- Data sourcing
- Data processing
- Report generating
- Automating, and
- Validating
Last, the course evaluating the newly built model to determine how well it meets the requirements of a great Excel model.
Course Key Concepts: Power Query, Excel modeling, DSO, Parameters, Data input, Data processing, Data output, VBA, Validation.
