Creating Scenarios
Because some worksheet data is constantly evolving, the ability to create multiple scenarios lets you speculate on a variety of outcomes. For example, the marketing department might want to see how its budget would be affected if sales decreased by 25 percent. Although it’s easy enough to plug in different numbers in formulas, Excel allows you to save these values and then recall them at a later time.
Create and Show a Scenario
Click the Data tab.
Click the What-If Analysis button, and then click Scenario Manager.
Click
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
