Create a Scenario Summary or PivotTable Report : What If Scenario « Data Analysis « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Data Analysis
3. What If Scenario

Click the Data tab. 
           Click the What-If Analysis button, and then click Scenario Manager.

Select the scenario.
           Click Summary.

Click the Scenario summary or Scenario PivotTable report option.Click OK.

A scenario summary worksheet tab appears with the report.

10.6.What If Scenario
	10.6.1.	Create a 'What-If' Scenario with Goal Seek
	10.6.2.	Create and Show a Scenario
	10.6.3.	Show a Scenario
	10.6.4.	Create a Scenario Summary or PivotTable Report