1-866-245-5224 sales@keystonelearning.com

Excel 2003: Summarizing Scenarios

Excel 2003: Summarizing Scenarios

Along with Scenarios and the ability to create several for one range of cells, you can combine your scenarios into one, nicely-wrapped summary report. This report actually lists your scenarios side-by-side.

Creating a Scenario Summary Report

     
  1. Choose Tools: Scenarios… from the Menu bar
     
  2.  
  3. Click Summary…
     

Figure 29. Scenario Summary Dialog Box

   3.      Choose Scenario Summary

   4.      Delete the text in the Result cells box (This should be left blank when creating a Scenario Summary although it is a required field when creating a PivotTable report)

   5.      Click OK

 

Figure 30. Sample Scenario Summary Report