Microsoft Office Tutorials and References
In Depth Information
Using the Scenario Manager
Track changes made to scenarios with the version-control features of the Scenario
Manager. You can use this feature to record the date and the user name each time a
scenario is added or modified.
Print reports detailing all the changing cells and result cells.
● Password-protect scenarios from modification, and even hide them from view.
Examine relationships between scenarios created by multiple users by using Scenario
Summary and PivotTable reports. For more about PivotTables, see Chapter 23.
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 worksheet.
Imagine that you manage a grocery store whose profit picture is modeled by the worksheet
in Figure 18-8. The numbers in D2:D5 and E8:E13 are historic averages; column C contains
the range names applied to the relevant cells in columns D and E. You’re interested in
testing the impact of changes in these cells on the bottom line in cell E16.
Cell references are OK, but before you begin using the Scenario Manager, you should
name the cells you plan to use for your variables, as well as any cells containing
formulas whose values depend on your variable cells. This step isn’t required, but it makes the
scenario reports, as well as some of the dialog boxes, more intelligible. For more
information, see “Naming cells and cell ranges” in Chapter 12, “Building formulas.”