Excel Forum

Excel Magic Trick #90: Consolidation

See how to use the Consolidating feature in Excel. Summarize data from a number of different tables quickly using the Consolidation Feature.

See how to:
1) Name ranges, and how to edit named ranges
2) Consolidate tables from different sheets
3) Create consolidation with linked formulas
4) Create consolidated tables where the input tables are not the same size
5) See how to create a 3-D cell reference

Formula and functions such as Sum and AVEARGE

Got a Question? Ask it Here in the Forum.