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

III. Organizing Worksheets > 14. Grouping and Outlining Data

Chapter 14. Grouping and Outlining Data

As you saw in the last chapter, Excel’s data lists are great tools for managing big tables made up of long, uniform columns (like lists of customers or products). But these data lists don’t work as well for tables that show different groups of information, each of which has its own collection of subtotals.

For example, imagine a company sales report that lists a year’s worth of quarterly results for each of its regions around the world. If you try to cram all this data into one long list—including subtotals for each region—you’re likely to end up with a spreadsheet that looks like a numerical version of Twister. You’d be better off breaking out each region separately, in its own table, and then tying everything together separately, in another table that sums everything up.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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