O'Reilly logo

Microsoft Office Excel® 2007 Data Analysis: Your Visual Blueprint™ for Creating and Analyzing Data, Charts, and PivotTables by Denise Etheridge

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 10. USEFUL DATA ANALYSIS TOOLS AND TECHNIQUES

Perform What-If Analysis

When you use a formula or function, your purpose is often to find out how one thing influences another. When you use the IRR function, for example, you can find out how a change in the loan amount, payment amount, or payment date — or some combination of these factors — affects the interest received. You can type in different amounts and different payment dates to see how different scenarios affect the interest rate.

What-if analysis is a systematic way of finding out how a change in one or more variables affects a result. The Scenario Manager lets you vary one or more inputs into any formula or function to see how the result changes.

You can use the Scenario Manager two ...

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