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 "CZcams" 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 "CZcams12" 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

[@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

[@jainmarkose2480]

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

[@thangaraja820]

I am also bro...

[@danishshafiq8477]

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

[@TutorialsPoint_]

Check out latest MS Excel Online Training
courses on : bit.ly/38Jyu3p
Use coupon "CZcams" to get FLAT 10% OFF

[@pranshu8988]

Thank u sir for the video, really helped for my Information technology exam

[@rdjgamer7254]

Angrezi hi aati hai kya

[@santoshkumarvavilala3179]

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

[@caroleserpell8869]

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

[@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!

[@talligaming9522]

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

[@VivekKumar-sh1ro]

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

[@alokeghosh8823]

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

[@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

[@nguntinpar977]

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

[@senthilkumar-zl2wb]

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

[@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%.

[@ranganathmadishetty3051]

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

[@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!

[@basharatcma6898]

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

[@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 💐

[@DilwaleChawlaJi]

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

[@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

[@soumiknaiya1024]

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

[@venurapelli3521]

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

[@rameshwarshukla3413]

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

[@chitturipapachari_garu1561]

Your teaching way was great, very experienced 👍

[@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..

[@GurdeepSingh-wm6xt]

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

[@sanusidanjuma402]

What a nice Tutorial, Thanks from Nigeria

[@marcuspo5211]

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

[@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.

[@BIBINMATHEWKERALA]

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

[@vannelapraveenvannelaprave2556]

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

[@anshsharma5939]

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

[@hemantthakur7564]

Great explanation with perfect understanding

[@tanveerullah3106]

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

[@prachiprasad1909]

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

[@mansoorkapdawala954]

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

[@aashirashraf1178]

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

[@mohannb5102]

Your teaching is good. Can be easily understood
Thank you

[@jagsaransingh1653]

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

[@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

[@utkarshanishad2413]

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

[@najiafatima679]

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

[@vidyakamble3215]

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

[@94884dinesh]

Great knowledge sharing sir. Thank you

[@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

[@ilyas3816]

Thanks
You have helped a lot

[@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

[@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.

[@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.

[@raja6600]

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

[@falgunipalsanawala6984]

Thanks it helped me alot in examination

[@nrsh447]

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

[@lalitabhandari6565]

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

[@pavankumarr8735]

You're just Awesome !!! ❤️

[@aqf2000]

Very useful and simple steps for consolidations thanks and Regards

[@amitbais5163]

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

[@Munsur83]

Very simple and effective teaching method.

[@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

[@alarazboyz9361]

thanks a lot..finally i found this

[@mukeshjha3964]

Consolidation was really helpful ✌️✌️✌️

[@maheshtamhane2230]

Very professional... Thanks for your contribution.

[@badalsahoo5216]

Thanks sir. Helped me a lot👍👍

[@sohanfc7]

Your teaching is amazing love the video😍

[@AshokKumar-tw5jt]

Thank you Sir, It's very useful msg

[@ilia2000]

I love your explanation. Thank you so much.

[@kishore7363]

Superb presentation well explained Tq

[@inbapandian8818]

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

[@sumitsutradhar2085]

Excellent Sir and thanks for detailed explanation.

[@sgopi]

Great explanation sir thank you.

[@noor_jahan1891]

Thank you thank you thank you so much 😍😍😍

[@sreenivasnair3926]

You are my first excel tutor thank u

[@milind131]

Thank you very much it is very much useful

[@sufyanmayo7611]

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

[@ashachauhan1892]

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

[@saratsrinivas4857]

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

[@sulaimansait8569]

thanks for you are explain sir

[@alinurmohamed5304]

A very HUGE and BIG THANK YOU.👍

[@shanthim1655]

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

[@anjig4240]

Excellent teaching skills sir. Tq for information.

[@jatinbasumatary4644]

Sir really you made crazy for my data analysis

[@vidwIQ]

Excellent voice and explained

[@rangiroa100]

Yeah!!!! Another wonderful presentation.

[@mercypouline6034]

your presentation is very useful sir
thank you for your efforts........😇😇

[@vuyilemagwaza3236]

Great tutorial, 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

[@belamaheshwari3300]

Thank you very much Sir... So well explained

[@bjpwin24]

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

[@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

[@vitrovogan9635]

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

[@madhavkaushik1420]

THANKS FOR YOUR GOOD VIDEOS. SIR, YOU ARE THE BEST. I HAVE TO SAY THIS MUCH ONLY

[@kurakulasandeep9679]

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

[@naveennvn4425]

pawan lalwani. ....its an emotion

[@pranaykumar2462]

Sir thank you so much.... It is very helpful

[@piyushchauhan1986]

Thank you so much for wonderful explanation

[@madhav1765]

Most useful youtube channel❤