Excel Model Makeover - Reducing Prep Time from 1 hr to 1 min

Excel Model Makeover - Reducing Prep Time from 1 hr to 1 min

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:

o Accuracy

o Simplicity

o 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:

o Data sourcing

o Data processing

o Report generating

o Automating, and

o Validating

Last, the course evaluating the newly built model to determine how well it meets the requirements of a great Excel model.

Learn how to turn around a model to reduce preparation time from 1 hour to 1 minute

Url: View Details

What you will learn

• Intermediate to Advanced Excel skills that will help you
• - to ace your Excel skills,
• - to find state-of-the art Excel functions,

Rating: 0

Level: Intermediate Level

Duration: 1 hour

Instructor: Lenny Wu, MBA, CPA, CGA