From the course: Excel 2016 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Using Scenario Manager
- In this worksheet called Scenario in workbook 13 - DataAnalysis, we've got some budget projections. All the numbers, although it's not obvious at first, are really based on what's happening in January. Formulas in February, March, April, May, and all the other months ultimately are based on the January numbers. Now, if we'd like to show alternate budget projections, we could easily make a copy of this worksheet, make three or four copies, and on each worksheet labeled differently we'd have a different set of numbers. And nothing wrong with that. But Scenario Manager, a feature found on the Data tab in the ribbon it's under What-If Analysis allows us to essentially store all of these kinds of projections in the same worksheet. It begins with the idea that we might want to hold on to the projections we've already done. Maybe we'll call this our Standard projection. So What-If Analysis, Scenario Manager. No scenarios have been defined. Let's add a scenario that simply defines the…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.