From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 25,200 courses taught by industry experts.

Use Scenario Manager to store and rapidly recall different sets of values

Use Scenario Manager to store and rapidly recall different sets of values - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use Scenario Manager to store and rapidly recall different sets of values

“

- [Speaker] Excel has a number of capabilities under the category of What-If analysis. One of 'em is called a scenario manager. And on this very busy worksheet that we're seeing in the background here, there are three different scenarios. And the idea behind this is maybe these numbers are interrelated and what you'd like to be able to do is to show how these numbers are going to change based on just a few cells changing and maybe have those different projections quickly available. Now one approach could be, we could make a copy of this worksheet, make three or four copies and have each one be different. We could bounce back and forth that way. The scenario manager technique makes sense and it's easier to get to and easier for display purposes as well. And the image that you're seeing off to the right here that I'm moving around is what we will see on the data tab up in the ribbon menu system. Way up to the right…

Contents