Microsoft Office Tutorials and References
In Depth Information
Using the Goal Seek command
Use Scenario Summary reports
PivotTables are powerful analysis tools best suited to complex what-if models that
include scenarios with different sets of changing cells created by different people. The
more one-dimensional your what-if model is, the less useful a PivotTable becomes.
PivotTables take longer to create and consume more memory than summary reports. If
you create all the scenarios yourself and use the same set of changing cells in each, you
might find using the Scenario Summary reports easier given that you don’t need the
advantages offered by the PivotTable.
Figure 18-18 The Scenario PivotTable report manipulates the actual data in the report.
Using the Goal Seek command
By clicking the What-If Analysis button on the Data tab and then clicking Goal Seek, you
can compute an unknown value that produces the result you want. For example, suppose
you want to know the maximum 30-year mortgage you can afford if the interest rate is
3.5 percent and if you must limit your monthly payments to $2,000. To use the Goal Seek
command to answer this question, first set up the problem using trial values. For example,
Search JabSto ::




Custom Search