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

Part V: Analyzing Your Data > Building Scenarios and Outlines with Excel

Chapter 18. Building Scenarios and Outlines with Excel

by Bruce Hallberg With Joyce Nielsen

  • Working with scenarios

    Many business people need to create and manage different scenarios of data, particularly those that need to perform complex budgeting, business analysis, and other such tasks. Excel's Scenario Manager makes analyzing different cases easy.

  • Summarizing and printing scenarios

    Excel provides a command that enables you to summarize all your scenarios in one worksheet. You can then print the worksheet to make simple comparisons between the different case scenarios.

  • Outlining worksheets

    Many worksheets are very large, and contain both detailed data and different levels of summarization data. You can make working with such worksheets easier by using Excel's outlining feature.

  • Moving and copying outlines

    You can use the Cut and Copy commands to move or copy an entire outline to another location. If you have collapsed an outline, you also can choose to move or copy only the visible cells.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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