From the course: Excel 2010 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Using scenarios in formulas

Using scenarios in formulas - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

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, go over here for Changing cells…

Contents