• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. Analyzing Alternative Data Se... > Defining Multiple Alternative Data S...

Defining Multiple Alternative Data Sets

One great feature of Excel scenarios is that you’re not limited to creating one alternative data set—you can create as many as you like and switch among them at will with the Scenario Manager. To change from one scenario to another in the Scenario Manager, click the name of the scenario to which you want to change and then click the Show button. The values you defined as part of that scenario will appear in your worksheet, and Excel will update any calculations involving the changed cells.


Tip

If you apply a scenario to a worksheet and then apply another scenario to the same worksheet, both sets of changes will appear. If the second scenario changes a cell changed by the first scenario, the cell will reflect the value in the second scenario.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint