O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required