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

Consolidating Worksheets

When you consolidate worksheets, Excel performs calculations on similar data across multiple worksheets and workbooks and places the results of calculations in a consolidation worksheet. You can use this capability to consolidate department budgets into one division budget; you then can consolidate the division budgets into the corporate budget.

Consolidations can be more than just simple totals, however. Excel also can create consolidations that calculate statistical worksheet information such as averages, standard deviations, and counts.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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