From the course: Excel 2010 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Using scenarios in formulas - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.