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

Consolidating Data

The Consolidation feature is used to take data from multiple sheets and consolidate it into one sheet. For example, you may want to take your sales figures from a number of years and consolidate them into one spreadsheet where an average value (computed from the data in each yearly summary sheet) appears as the sales value for each product or region. Figure 9.3 shows the first quarter sales figures for two years (1999 and 2000) that have been consolidated as an average into a consolidation table.

Figure 9.3. Data can be consolidated from multiple tables into a consolidation table.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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