• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 5: Creating Formulas and Performing... > Performing What-If Analysis

Chapter 18. Performing What-If Analysis

Using Data Tables 493

Using the Scenario Manager 498

Using the Goal Seek Command 507

Using the Solver 509

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint