O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

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

Storing Multiple Scenarios in a Single Workbook

One of Excel's most valuable hidden features is its capability to store multiple scenarios within a single workbook. Creating scenarios helps you plan for a future in which you can't be certain that your worksheet model is accurate, especially when a change in one assumption will have a ripple effect on other values that affect the bottom line. Scenarios are useful in these two circumstances:

  • When the underlying assumptions depend on external factors out of your control, such as the weather or the economy. For example, if you sell heating oil or umbrellas, you might create a P&L forecast using multiple scenarios to compare the results of strong sales in cold, wet weather and weak sales if the winter ...

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