THE Scenario Manager in Excel 2007 is a wonderful tool which enables you to compare multiple scenarios so that you make better planned decisions. You can create and compare multiple scenarios: one with original values others with tweaked values.

To create scenarios in Excel 2007, carry out the following steps:

Create the values on the basis of which you wish to create the original scenario.

Select the cells in which the data is likely to change.

Go to the 'Data' tab.

Click 'What - If Analysis' tool appearing under the 'Data Tools' group.

Click the 'Scenario Manager .. .' option from the drop-down list.

Click the 'Add' button appearing on the 'Scenario Manager' dialog box.

Enter a scenario name and click 'OK' to close the dialog box.

Check the values that are assigned to the scenario.

NOTE:

It is advisable to assign cell names for better understanding.

Click 'OK' to save the scenario. You can now change the values in the worksheet to create subsequent scenarios.

To view a specific scenario,

Click the 'Scenario Manager .. .' option from the 'What-If Analysis' drop-down list.

Click the scenario you which want to view.

Click 'Show' appearing on the 'Scenario Manager' dialog box.