From the course: Excel: Analytics Tips

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Scenario Manager

Scenario Manager - Microsoft Excel Tutorial

From the course: Excel: Analytics Tips

Start my 1-month free trial Buy for my team

Scenario Manager

“

- [Instructor] Alright, let's take a few minutes and talk about Excel's Scenario Manager tool. Specifically, how this tool can be used to quickly compare different model outputs. The Scenario Manager, which you'll find in your data tab, under the what if analysis options, essentially allows you to save and quickly access specific combinations of preset cell values. Let me show you an example here. If we drill into that Scenario Manager option, we'll see a list of any predefined scenarios that we've created. In this case, I have four. And what happens when you add or create a new scenario from scratch, you're basically telling Excel I want to define a scenario based on this specific set of cells, in this case I have three of them. I've named one cell percent down. I've named a second cell interest rate. And a third cell term length. Now a quick tip here. You don't have to give your cells names. This could just say h7, h8, h9. I find that naming those cells helps make this process a bit…

Contents