TIPS, TRICKS, REVIEWS, & INDUSTRY NEWS

Scenarios allow you to create and save several versions of your worksheet and enable you to see how changing one or more of your worksheet’s values affects the other values in your worksheet. Using an example of purchasing a home, we could create several different scenarios to see how changing the interest rate and downpayment would affect the value of our monthly payment.

Once you have chosen the cells whose data you want to change and saved your scenario for later review, you can easily display and/or print the scenario when needed. You also have the option of printing a Summary Report to view your current values and your scenarios side-by-side.

To Use Scenarios

1. Click the Data tab on the Ribbon.
2. Click the What-if Analysis button and click Scenario Manager from the menu.
3. Click the Add button.
4. Enter a name for your scenario in the Scenario Name box.
   
5. Click in the Changing Cells box.
6. Hold down the Ctrl key and select the cells in your worksheet that you wish to change.
7. In the Scenario Values dialog box, enter in the new values.
   
8. Click OK.
9. To Apply a Scenario to your worksheet, select the desired Scenario and then click Show.
10. Click Close.

{ Comments on this entry are closed }