O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using the Scenario Manager

To model more complicated problems than data tables can handle, involving as many as 32 variables, you can call on the services of the Scenario Manager by choosing Tools, Scenarios. 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 that you can enter variable figures and watch the effect on dependent computed values. The Scenario Manager records, tracks, and applies combinations of variable values.

We'll use the Scenario Manager to model the effects of changing values in D2:D3, D5, and E8:E13 of this worksheet.

Figure 18-8. We'll use the Scenario Manager to model the effects of changing values in D2:D3, D5, and E8:E13 of this ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required