Chapter 18. Performing What-If Analysis
One of the most important benefits of spreadsheet software is that it performs a what-if analysis quickly and easily. Change key variables, and instantly see the effect. For example, if you're using Microsoft Excel to decide whether to lease or purchase a car, you can test your financial model with different assumptions about interest rates and down payments, and you can see the effects of varying rates on bottom-line costs you will pay, such as the total interest. Excel offers a number of advanced what-if features, which are discussed in this chapter.
Using Data Tables
A data table, or sensitivity table, summarizes the impact ...
Get Microsoft® Office Excel 2003 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
