Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours

Using the Scenario Manager

Excel's Scenario Manager feature enables you to analyze your data to see how changing one or more values in the worksheet affects the other cells in the worksheet. This feature comes in handy for figuring out what would happen if certain factors in your business changed.

After you create a simple scenario in this hour, you'll learn about hiding and protecting scenarios to prevent others from making changes to them. Then you will view different scenarios on the worksheet. Finally, you will create a scenario summary to view all scenarios from your worksheets in one report.

Creating Scenarios

In many cases, you use worksheets to perform what-if analysis. After you set up a series of calculations, you can change the values ...