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

For example, suppose you want to evaluate a potential mortgage payment after being given several different down payments and interest rates. You can ...

Get Master VISUALLY® Excel® 2010 now with O’Reilly online learning.

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