Microsoft® Excel® 2010 Inside Out

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 ...