Microsoft Office Tutorials and References
In Depth Information
We created different sets of assumptions for the model shown in Figure 18-8 and saved
each one as a different scenario using the dialog boxes in Figure 18-9, resulting in the list of
Advertising.xlsx workbook scenarios shown later in this chapter in Figure 18-12. To define a
scenario, follow these steps:
On the Data tab, click the What-If Analysis button and then click Scenario Manager.
2. In the Scenario Manager dialog box, shown in Figure 18-9, click Add. (Note that
the sample file already contains defined scenarios, so this dialog box might look
Figure 18-9 Use the Scenario Manager to define and store different sets of assumptions
you can retrieve at any time.
In the Add Scenario dialog box, shown in Figure 18-9, type Starting Values as the
It’s a good idea to define the values you begin with as a scenario before
changing any of them. You can name this scenario something like Starting Values or
Last Year, as in our example. If you don’t name the starting scenario, you’ll lose
your original what-if assumptions when you display the new changing cell values
on your worksheet.
In the Changing Cells box, type or select the cells you plan to vary. For this example,
click cell D2, then hold down Ctrl and click cell D3, then click cell D5, and then drag
to select E8:E13. (Select nonadjacent cells and ranges by pressing the Ctrl key before
selecting the cells or by separating their references or names with commas, as shown
in Figure 18-10.)