Excel Model Makeover: Reducing Report Prep Time from 1 Hour to 1 Minute

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.