Excel Model Makeover: Reducing Prep Time from 1 hour to 1 minute (Video) (Course Id 1784)

The 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.

Next, the course lists what make 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.

Please Note: This course’s author is working on the providing transcripts, PDFs, and slides where applicable. Unfortunately until then we will not be able to offer them with the course but felt the course was valuable enough as it is so have chosen to include it on our site. Our sincere apologies for any inconvenience and please let us know any question using the support bubble on the bottom right of all pages on our site. 

Video - NASBA QAS - NASBA Registry - 1784

Course Learning Objectives

• Master the full skills of designing, implementing and evaluating a financial model
• Recognize 3 elements to make a great financial model
• Build a dynamic connection to data files through Power Query
• Control the financial model with pre-defined parameters in Power Query
• Distinguish methods to append a new table to the bottom (as rows) or to the right (as columns)

Chapter 1 - Excel Model Makeover: Reducing Prep Time from 1 hour to 1 minute

Chapter 1 Review Questions

Glossary