Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Excel Magic Trick #90: Consolidation

Loading...

Sign in or sign up now!
46,314
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jun 30, 2008

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

  • likes, 5 dislikes

All Comments

Adding comments has been disabled for this video.

0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more