Using the Scenario Manager
To model more complicated problems than data tables can handle—those involving as many as 32 variables—you can call on the services of the Scenario Manager by clicking the What-If Analysis button in the Data Tools group on the Data tab and then clicking Scenario Manager. A scenario is a named combination of values assigned to one or more variable cells in a what-if model. The worksheet in Figure 18-8 is a what-if model set up so you can type variable figures and watch the effect on dependent computed values. The Scenario Manager records, tracks, and applies combinations of variable values.
Note
You can find the Revenue Scenarios.xlsm file with the other examples on the companion Web site.
Here are some of the tasks you ...
Get Microsoft® Excel® 2010 Inside Out 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.