Excel > Excel 2007 Advanced > What-If Analysis

Using Scenarios

A Scenario is a "What-If" projection using multiple variables. Scenarios are saved making them accessible for later comparison and review.

The Scenario Manager

The Scenario Manager stores all scenarios created within the workbook. From here, scenarios can be created, viewed, edited and deleted.

Click the Data tab on the Ribbon, and then click the What-If Analysis button in the Data Tools group and select Scenario Manager from the list.

The Scenario Manager is blank as no scenarios have been created yet.

Create a Scenario

1. Click the Add button

The Add Scenario dialogue box is displayed



2. Enter a name to identify the scenario in the Scenario name field
3. In the Changing cells field, select the cells containing the data to be changed
4. Enter a description of the purpose of the scenario in the Comment box
5. Click Ok

The Scenario Values dialogue box is displayed



6. Enter the values to be used in each field

Click Add to create more scenarios, or click Ok to return to the Scenario Manager

The scenarios can be viewed in the Scenario Manager

View a Scenario

From the Scenario Manager:

1. Double click the scenario you wish to view

The scenarios values are inputted on the worksheet and result calculated

2. Repeat the step to view all necessary scenarios

The values of last scenario viewed remain on screen

Edit a Scenario

From the Scenario Manager:

1. Select the scenario you want to edit
2. Click the Edit button

The Edit Scenario dialogue box is displayed



3. Change the Scenario name and/or Comment
4. Click Ok

The Scenario Values dialogue box is displayed

5. Change any required values
6. Click Ok

The Scenario Manager dialogue box is displayed

Delete a Scenario

From the Scenario Manager:

1. Select the scenario to delete
2. Click the Delete button

Create a Scenario Report

From the Scenario Manager:

1. Click the Summary button

The Scenario Summary dialogue box is displayed



2. Select the desired report type
3. Click Ok

The example below is of tabular view

Data Tables Solver

Guides