Using scenarios in formulas


show more Using scenarios in formulas provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

Using scenarios in formulas

Excel's Goal Seek and Data Tables features are really great, but there are times when you might want to change more than just one or two variables at a time or maybe you want a nicely formatted report of all your possibilities. That's what the Scenario Manager is and it's also under the What-If button that we've been looking at in this chapter. So, go to the Data Tab and over here click What-If Analysis and choose the Scenario Manager. Now, we haven't created any scenarios yet so that's why this is blank. And the way it works is you create sets of data.

Each set of data has a name that you give it. It's a friendly name. It's not a file name. You can call it just about anything you want. You typically give it names like low, medium, high, very high, whatever it is that suits your particular need. So let's start by clicking Add and let's say the scenario name we'll call this as Low amount. This will be perhaps the lowest amount that we would borrow. So...

Using scenarios in formulas
Video duration: 5m 28s 6h 21m Beginner

Viewers:

Using scenarios in formulas provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...