Excel Forum
Similar Content
Guide to Combine and Consolidate Data in Excel
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...
Combine Data from Multiple Worksheets in Excel
Tutorial: The easiest way to combine and consolidate data in Excel. Simple method to combine data ...
Multiply by True and False in Excel
Tutorial: You can multiply numbers by TRUE and FALSE in Excel. This effectively allows you to elimi...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.