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.
Learning Objectives
- Explore how to make master the full skills of designing, implementing and evaluating a financial model.
- Recognize 3 elements to make a great financial model.
- Discover how to build a dynamic connection to data files through Power Query.
- Identify and control the financial model with pre-defined parameters in Power Query.
- Discover the distinguish methods to append a new table to the bottom (as rows) or to the right (as columns).
3 Reviews (24 ratings)
Reviews
Prerequisites
Basic Excel and Power Query knowledge; Example: be able to open one Excel file and connect to external data files, etc;
Recommended prerequisite: Power Query (Part 1): Ultimate Data Transformation
Other Excel Model Makeover courses by Lenny Wu.
Excel Model Makeover 2: Reducing Data Entry from 2 Hours to 2 Minutes
Excel Model Makeover 3: Reducing Update Time from 3 Hours to 3 Minutes