This is the eighth and final video in a series intended to teach you how to build “perfect” excel models.

The video series will show you how to build a beautiful and elegant model using a case-study approach.

“8. Slide-ready output” will cover:

1. Link all sets of important data on a separate “graph output” tab
2. Create a reconcilable record of inputs and outputs for each presentation

Read more…

This is the seventh in a series of videos intended to teach you how to build “perfect” excel models.

The video series will show you how to build a beautiful and elegant model using a case-study approach.

“7. Simple Scenarios” will cover:

1. Build your model logic flow only once
2. Use multi-column sets of assumptions
3. Use data tables to generate model outputs for all scenarios simultaneously
4. Use data tables to generate a “sensitivity star chart” for instant sensitivity analyses

Read more…

This is the sixth in a series of videos intended to teach you how to build “perfect” excel models.

The video series will show you how to build a beautiful and elegant model using a case-study approach.

“6. Operating model” will cover:

1. Duplicate your Back-of-the-envelope tab and add time and complexity
2. Create scenario-based adoption curves
3. Apply adoption curves to multi-country ramp-up scenarios
4. A few things you should never do. EVER
5. Make something your manager can easily audit
6. Build in error-checking
7. Diagnosing errors when all else fails

Read more…

This is the third in a series of videos intended to teach you how to build “perfect” excel models.

The video series will show you how to build a beautiful and elegant model using a case-study approach.

“5. Back-of-the-Envelope” will cover:

1. The importance of showing progress
2. Converting your issue tree into your basic model
3. Sense-checking the results

Read more…

This is the fourth in a series of videos intended to teach you how to build “perfect” excel models.

The video series will show you how to build a beautiful and elegant model using a case-study approach.

“4. Data Second” will cover:

1. Research and understanding available data
2. Keep data once, raw, clean, separate and labeled
3. Idiot-proofing your data inputs

Read more…

This is the third in a series of videos intended to teach you how to build “perfect” excel models.

The video series will show you how to build a beautiful and elegant model using a case-study approach.

“3. Paper First” will cover:

1. Defining a problem statement
2. Understanding what you need to model in detail
3. Drawing the issue tree
4. Gathering evidence for and recording your assumptions
5. “Ghost” out your intended output before your start

Read more…

This is the second in a series of videos intended to teach you how to build “perfect” excel models.

The video series will show you how to build a beautiful and elegant model using a case-study approach.

“2. Think Modular” will cover:

1. Understanding the different components of a good model
2. How to build scalable models which can grow with the project needs
3. Setting up a structure for your model worksheets
4. Build it so your mom can use it — How to build client-ready models

Read more…

This is the first in a series of videos intended to teach you how to build “perfect” excel models.

The video series will show you how to build a beautiful and elegant model using a case-study approach.

The Introduction will cover:

Components and materials for the 8-part series

• Accompanying slides
• An excel model for each stage of the series (see the links in the first 10 seconds of each video)
• Completed excel model with all the bells and whistles

Read more…