Page 675 - Excel 2013 All-in-One For Dummies

Hide and Goal Seeking 657
Figure 1-9:
A Scenario Summary report
for the scenarios in the Sales Forecast table.
After generating a summary report, you can save it by clicking the Save com- mand button on the Quick Access toolbar (Ctrl+S) and/or print it by clicking the Quick Print command button (Ctrl+P).
Note that the Scenario Summary dialog box contains an option, Scenario Pivot/Table Report, which enables you to view the scenario results as a pivot table. See Book VII, Chapter 2, for details on the uses of pivot tables.
Hide and Goal Seeking
Sometimes, you know the outcome that you want to realize in a worksheet, and you need Excel to help you find the input values necessary to achieve those results. This procedure, which is just the opposite of the what-if analy- sis that I’ve been examining in this chapter, is referred to as goal seeking.
When you simply need to find the value for a single variable that will give the desired result in a particular formula, you can perform this simple type of goal seeking with the Goal Seek command. If you have charted the data and created a two-dimensional column, bar, or line chart, you can also perform the goal seeking by directly manipulating the appropriate marker on the chart. And when you need to perform more complex goal seeking, such as that which involves changing multiple input values to realize a result or con- straining the values to a specific range, you can use the Solver command.
Book VII Chapter 1
Performing What-If Scenarios