Excel Magic Trick #90: Consolidation
ฝัง
- เผยแพร่เมื่อ 15 ต.ค. 2024
- Start File: people.highlin...
Finished File: people.highlin...
Full Page With All File Links: people.highline...
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
Der Mike I am your regular student I started learning excel form you through youtube many years back but due to some reasons I was unable to watch your channel (you tube banned in my country and some other life matters). But now since two years I am learning excel regularly from you. When I returned back to home from office I regularly watch your videos on difference excel functions.
Nice video 📹 Mike. Always great to watch your old videos. 👌
Dear Mike
Good day to you. Hope you will be good. I am able to complete salary task assign to me just because of you and this great video. I use your data consolidation tips that I have learnt from you to merge large amount of salary data into one sheet the result was amazing. It's saved my whole day.
Thanks MIKE you make me Zero to Hero.
Dear dubaiabud2000,
I do not have a server big enough to do that - this is why I use TH-cam. 1 or 2 other Excel TH-camrs have said that they have figured out how to download the videos from TH-cam. I do not know how. Maybe you can do a search or ask a TH-cam user group.
--ExcelIsFun
Mike you are great.
Thanks for your support, Haris, on these videos that you learn from with your comments, thumbs up, and of course your Sub. It means a lot to me and helps grow the channel so that more people can find this free education : )
There are 3 sheets with sales data for 3 months in same format in 3 different currencies. Is there a way to consolidated this using consolidate feature while converting all the currencies in to USD.
Exchange rates are also available.
Thank you in Advance.
Mike, you are the best!
You are welcome, Rodrigo : ) This is a 11 year old video...
good...
is there any way i culd download all of your wideos?
Dear kennis942,
No, TH-cam does not allow this.
--ExcelIsFun
2:00 Consolidation
This video is 11 years old... And it is still fun!!! : )
@@excelisfun :)
What if the employee names are not in the same sequence? (Sort feature doesn't work because some employees change among the years)