Chapter 27. Performing What-If Analysis

Create Various Scenarios

Using the Scenario Manager, you can explore different possible outcomes for a given set of data. Creating different possible outcomes is often referred to as creating a what-if model. That is, by modifying certain data, you answer the question, "What would happen if I made this change?"

When you work with scenarios, you use a worksheet that contains some values that do not change and others than do change. You identify the cells that contain changing values and supply a scenario name. Then you supply variables for the changing cells.

Suppose, for example, that you want to evaluate a potential mortgage payment, given several different down payments and interest rates. You can create ...

Get Master Visually®: Excel® 2007 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.