O'Reilly logo

Master Visually®: Excel® 2007 by Elaine Marmel

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

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

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