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

Chapter 32.  Testing Multiple Solutions ... > Summarizing Scenarios in Tables

Summarizing Scenarios in Tables

Switching among different scenarios is useful, but many times you also will need to see a single summary table with the results for all the scenarios. Excel produces two types of scenario reports. The scenario summary is suitable for models with a single scenario set. For models containing multiple scenario sets, Excel creates a pivot table report that computes results for all possible outcomes. See Chapter 27, "Using the Power of Pivot Tables," to learn how to work with pivot tables.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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