Excel Magic Trick #90: Consolidation

Tags:
3-D Avearge Cell Colleges Community Consolidation Excel Gel Girvin Highline Mike Names Reference Sum
ExcelIsFun
  • Affiliate Submitter:
    ExcelIsFun
  • International International
  • Comments: 0
  • Views: 515
  • Added: 30-Jun-08

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

  1. Categories: Science & Tech
Comments on

Excel Magic Trick #90: Consolidation

5 Comments | Add Comment
  • I believe if you ...

    I believe if you upload the videos to Google Video people you will have an option to allow people be able to download them.

    You could always get a podcast going too.

    By eurokc98 [Affiliate User] 1219200343 Reply Spam Moderate Up Moderate Down
  • Dear dubaiabud2000, ...

    Dear dubaiabud2000,

    I do not have a server big enough to do that - this is why I use YouTube. 1 or 2 other Excel YouTubers have said that they have figured out how to download the videos from YouTube. I do not know how. Maybe you can do a search or ask a YouTube user group.

    --ExcelIsFun

    By ExcelIsFun [Affiliate User] 1217016837 Reply Spam Moderate Up Moderate Down
  • Hey ExcellsFun why ...

    Hey ExcellsFun why dont you upload all ur videos in website and let us download .. they r great thanks for your efforts,,i really enjoy them.

    By dubaiabud2000 [Affiliate User] 1217007484 Reply Spam Moderate Up Moderate Down
  • Dear kennis942, ...

    Dear kennis942,

    No, YouTube does not allow this.

    --ExcelIsFun

    By ExcelIsFun [Affiliate User] 1214888167 Reply Spam Moderate Up Moderate Down
  • good... is there ...

    good...
    is there any way i culd download all of your wideos?

    By kennis942 [Affiliate User] 1214868867 Reply Spam Moderate Up Moderate Down
5 Comments | Add Comment