MS Excel - Consolidation

MS Excel - Consolidation
Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
Check out the latest MS Excel Online Training courses on bit.ly/38Jyu3p
Use coupon "TH-cam" to get FLAT 10% OFF at Checkout.
Check out latest Ebooks : store.tutorialspoint.com/eboo...
Check out latest Courses : www.tutorialspoint.com/videot...
www.tutorix.com/
This video explains How to use the consolidate function in Excel?
Combine data from different sheetsCombine data from different files.
For more updates on courses and tips follow us on:
Facebook: / tutorialspointindia
Twitter: / tutorialspoint
LinkedIn: / tutorialspoint

[@TutorialsPoint_]

To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "TH-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.

[@maheshakkalkot]

I love your teaching because 1. Directly jump into topic 2. You keep it simple and easy 3. You have good command on subject. 4. You know how to explain. Thank you much for your wonderful work... Keep going on..

[@Gajendersolanki_01]

that true brother

[@jainmarkose2480]

This is what I have been searching for a long time.
Thank you

[@thangaraja820]

I am also bro...

[@mrinquisit9146]

Appeared here before my T1 practical exam which is tomorrow 😂

[@maximusplayzz225]

Which school

[@hardikdangi4490]

Mine also 🤣🤣

[@mayankkalra9722]

Same

[@tamannaaa25]

Me too 😂

[@awmnoob4699]

Me also

[@danishshafiq8477]

A very up-to-date and specific teaching in shortest time indeed.

[@santoshkumarvavilala3179]

Your teaching methodology is influencing me much to learn more... Superb..

[@caroleserpell8869]

Wow, you are amazing, I love your teaching method.

[@talligaming9522]

I am having my exams and best part is I can cover my whole syllabus only because your channel. Thanks a lot sir ✨❤️

[@alokeghosh8823]

This was brilliant.... so well explained. Thank you.

[@kevinfoster2350]

Such teachers like you deserves alot in your life
You are brilliant ❤

[@amnaali6886]

the only channel in the whole youtube regarding excel , which i liked, is this!

[@sahilk1111]

Hey, your videos are awesome But it would be great if you can provide the data as well so that we can practise in real time and learn!

[@nguntinpar977]

Amazing teaching. It is so easy to understand. Thanks a lot

[@basharatcma6898]

Sir enjoy your each and every lecture.. Thanks for uploading your videos.. Love from Pakistan 😅😊

[@senthilkumar-zl2wb]

Your teaching method is very easy to understand the subject.
Great teacher

[@harihar68]

Superb sir. It's of great help to us. Your teaching made us to understand very very easily. Great and Kudos to your service

[@VivekKumar-sh1ro]

Wow! What a great way to teach. I love the way you taught.
Thank you so much ❤❤
🌹🌹😃😃

[@chitturipapachari_garu1561]

Your teaching way was great, very experienced 👍

[@ranganathmadishetty3051]

Thanks Pawan ur videos are helping me so much in learning Excel....

[@sanusidanjuma402]

What a nice Tutorial, Thanks from Nigeria

[@abhinav1046]

This is what i have been looking for a long time.
Thankyou

[@shilpaprabhudesai9444]

Best explanation, proper example , straight to the point

[@govardhani1108]

Thank you. The exact information I'm searching for. This vedio helped me at the right time.

[@satishchaudhary7978]

Vedio kya hota hai

[@ItsMe-cs9fu]

@Ashish Kumar gavar to tum ho educate hoke yese comment karte ho negative

[@oparman69]

video

[@marcuspo5211]

I have watched many lesson from TH-cam. but, your teaching is the best I can learn easily.

[@venurapelli3521]

dear sir your lectures are awesome nice communication skills you have thanks for making very usefull videos

[@hemantthakur7564]

Great explanation with perfect understanding

[@BIBINMATHEWKERALA]

Thank u sir... the way u teach is awesome... it helped me a lot to prepare progress cards

[@balaraama]

Hi.. U have good knowledge.. I’m totally impressed.. If I want consider two cells, find out which has increased / decreased.. how do I show in conditional formatting
Eg.. A1 10, B1 20.. need to show an upward arrow in B1... .. pl help

[@pradeeprawat7418]

There are 2 benefits of your videos sir people who are week in english... also learning English by watching.... Excel video... keep on uploading sir

[@shilpineo]

Hello Pavan, I found your videos very informative and easy to understand. In this video there is a jump ( 6:16th minute - 6:52nd minute ). Kindly edit it.

[@rameshwarshukla3413]

Thank u sir... educating in jst 8 min. Other wise in institute it take 1 hour

[@DilwaleChawlaJi]

Your tutorials are to the point and I got great help from your excel tutorial. Thank you for helping your subscribers.

[@nidhichaplot6]

Sir ur understanding talk is very benefitial for us... thanku so much... n meri Sari classes m apk video ek br dekh kr Usk baad hi padati hu..

[@gideonkoroka1920]

You are precise in your teaching method contains detail knowledge and experience with indepth articulation it satisfies me very much infact i give you 110%.

[@tanveerullah3106]

Sir your teaching method is very nice. Thank you so much Sir.

[@soumiknaiya1024]

Sir I like all the videos of yours. How smooth your teaching process is! Just awesome❤

[@payalyadav1012]

Thankyou so much sir i view your video for the very first time.. Really satisfactory session sir... m gonna love ur teaching apptitude... Lots of respect for u 💐

[@vannelapraveenvannelaprave2556]

Superb explaination sir. The big excel sheet screen helped a lot to understand.
Thank you

[@utkarshanishad2413]

Thank you so much for such nice video. It is very helpful..👌👌

[@rinkyroy6153]

There can be classes for spoken English too. As I have heard you speaking I think you can give all those tutorials ( based on topic ) to us.

[@vitrovogan9635]

Sir pls tell if there are any field methods to determine consolidation of soil

[@vidyakamble3215]

Sir ur teaching method is very nice . Thank u so much that .🙏🙏🙏🙏 Can u explain text function

[@anshsharma5939]

Your videos help a lot in IT exams, for which books do not suffice explanation. Thanks

[@mukeshjha3964]

Consolidation was really helpful ✌️✌️✌️

[@GurdeepSingh-wm6xt]

I really enjoy your video. You are a Very good speaker as well as a good teacher.

[@sandzstudio]

Hi thanks to all your tutorials.. Hope you can make also a data entry in macro that after entering the details no one can change or delete it. Thanks

[@jagsaransingh1653]

Really very good and nyc way of teaching....... Everything is clearly explained

[@mohannb5102]

Your teaching is good. Can be easily understood
Thank you

[@94884dinesh]

Great knowledge sharing sir. Thank you

[@samuelmeende2325]

Thanks for the detail explanation. Pls is there anyway to consolidate data without having to do any function. Just like copy pasting data from multiple sheets into one sheet

[@tuntunwin5761]

Thanks sir, very useful for our business.Here is the daily using in my work and than your presentation skill is good,forever thanks sir.Best Regard,Tun Tun Win

[@najiafatima679]

Great job👍. Its not only informative but fun to watch your videos. Keep it up..

[@mansoorkapdawala954]

a very simple no music no drama love itt.....subscribe more

[@prachiprasad1909]

It is amazing sir.sir with this video you are preparing us for our exam.thank you sir.

[@ilyas3816]

Thanks
You have helped a lot

[@aashirashraf1178]

Sir your videos help me very much in my field Thank you so much for your kind help. ❤️

[@falgunipalsanawala6984]

Thanks it helped me alot in examination

[@christinagaied2170]

Thank you for this amazing video, what if i want to add Mike 8, Mike 9, etc... after i consolidated? is there a way to automate it too? once i add Mike 8 data will be added in the consolidated sheet?

[@lordaarush955]

youll have to specify raaaaaange

[@raja6600]

Wowwww... its veryyy much helpfull.. thank u sir...

[@Fahimayaztz]

Hi,
great tutorial, almost similar to what I was looking for,
Can I use it to consolidate data for one column only from different sheet based on code No# (column)?
I have a Opening Stock and Purchasing Stock sheet which includes multiple entries of same code No# purchased at different intervals - I want to consolidate the data on Current Stock sheet where it shows the Code No# only combined in 1 cell
I don't need rest of the data, as i've used different formulas for rest of the columns, currently Im entering the Code No manually for them to work.
I wish to automate the Code No# column on current stock sheet.
TIA
Fahim

[@AshokKumar-tw5jt]

Thank you Sir, It's very useful msg

[@vidwIQ]

Excellent voice and explained

[@alarazboyz9361]

thanks a lot..finally i found this

[@kishore7363]

Superb presentation well explained Tq

[@nrsh447]

Thanks for this video, it is very useful to me...

[@sohanfc7]

Your teaching is amazing love the video😍

[@badalsahoo5216]

Thanks sir. Helped me a lot👍👍

[@munsurali7666]

Very simple and effective teaching method.

[@sufyanmayo7611]

a hundred time i search from Google butt hopeless. Really you are genius

[@ilia2000]

I love your explanation. Thank you so much.

[@inbapandian8818]

Thank you so much.. explained in a better way.

[@vivianintes6857]

Wow...thank u so much sir.Its very nice the way u explain. I understand more...i got perfect to our exam i just only watch ur video.

[@shree9557]

If i have to get the same colour in other column as per the colum where i had used conditional formating..
i.e, colum A colour should atomatically change as per column B

[@sreenivasnair3926]

You are my first excel tutor thank u

[@aqf2000]

Very useful and simple steps for consolidations thanks and Regards

[@sgopi]

Great explanation sir thank you.

[@SanviPatil2019]

Bahot badhiya sirji..sir aap yeh sub excel ke videos Hindi me padhao n.. hum subko bahot aur acha sikhneko milenga

[@muditvig1734]

Thanks a lot for the video. But I have a version of WPS and it does not any option of Linkin data. What other option do we have for that?

[@amitbais5163]

Very Good and simple teaching Technics, easy to understand, Thanks !!

[@sulaimansait8569]

thanks for you are explain sir

[@lalitabhandari6565]

Best method urs is to teach......very knowledgeable and helpful to learn excel at home

[@sumitsutradhar2085]

Excellent Sir and thanks for detailed explanation.

[@rangiroa100]

Yeah!!!! Another wonderful presentation.

[@pavankumarr8735]

You're just Awesome !!! ❤️

[@maheshtamhane2230]

Very professional... Thanks for your contribution.

[@milind131]

Thank you very much it is very much useful

[@memeworld5389]

I am here 2 3 hours before my practical and viva and in this pendamic timee we havent practiced for practical now its last hope🙂

[@breakaleg6117]

Sameee🤣🤣

[@Doshib48]

Why don't you guys start teaching tally too? I would be great help for us and trust me you are amazing in teaching

[@WOS1962]

Very useful and helpful lesson.thanks for your efforts.What type of screen name are you working on? Can you activate CC in your videos please??

[@madhav1765]

Most useful youtube channel❤

[@alinurmohamed5304]

A very HUGE and BIG THANK YOU.👍

[@bjpwin24]

You're the best! I love it. Refreshing my old study...! :)

[@ashachauhan1892]

Thank you sir....... It really helped me🙏🙏

[@kurakulasandeep9679]

Fine at teaching bro..very nice.. so much learnt from you

[@belamaheshwari3300]

Thank you very much Sir... So well explained

[@saratsrinivas4857]

It was helpful for finance consolidation.. thanks a lot 👍 .. wonderful

[@shanthim1655]

Thank u sir...very interested to learn excel by seeing your videos

[@ramzein776]

Thanks, if edit the qty it works but if add a new date or repeat the same data ?

[@srdstedli5805]

Thanks. Please explain how to add if the sequence of data is not same in all the 03 source sheets

[@piyushchauhan1986]

Thank you so much for wonderful explanation