MS Excel - Consolidation

Поделиться
HTML-код
  • Опубликовано: 24 ноя 2024

Комментарии • 478

  • @TutorialsPoint_
    @TutorialsPoint_  Год назад +3

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

  • @maheshakkalkot
    @maheshakkalkot 5 лет назад +62

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

  • @mrinquisit9146
    @mrinquisit9146 3 года назад +196

    Appeared here before my T1 practical exam which is tomorrow 😂

  • @TutorialsPoint_
    @TutorialsPoint_  3 года назад +12

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

    • @pranshu8988
      @pranshu8988 3 года назад +1

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

    • @rdjgamer7254
      @rdjgamer7254 3 года назад +1

      Angrezi hi aati hai kya

  • @danishshafiq8477
    @danishshafiq8477 3 года назад +5

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

  • @jainmarkose2480
    @jainmarkose2480 5 лет назад +26

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

  • @kevinfoster2350
    @kevinfoster2350 Год назад +2

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

  • @talligaming9522
    @talligaming9522 2 года назад +5

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

  • @tamaminvestment5909
    @tamaminvestment5909 2 месяца назад +2

    Oh man! I understood the concept first time as magic 🎉❤

  • @amnaali6886
    @amnaali6886 4 года назад

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

  • @shilpineo
    @shilpineo 5 лет назад +3

    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.

  • @sahilk1111
    @sahilk1111 5 лет назад +10

    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!

  • @santoshkumarvavilala3179
    @santoshkumarvavilala3179 5 лет назад +6

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

  • @anshsharma5939
    @anshsharma5939 4 года назад

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

  • @gideonkoroka1920
    @gideonkoroka1920 3 года назад

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

  • @pradeeprawat7418
    @pradeeprawat7418 5 лет назад

    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

  • @nidhichaplot6
    @nidhichaplot6 2 года назад

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

  • @rinkyroy6153
    @rinkyroy6153 3 года назад +3

    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.

  • @DilwaleChawlaJi
    @DilwaleChawlaJi Год назад

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

  • @soumiknaiya1024
    @soumiknaiya1024 11 месяцев назад

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

  • @mansoorkapdawala954
    @mansoorkapdawala954 4 года назад +7

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

  • @sreenivasnair3926
    @sreenivasnair3926 4 года назад

    You are my first excel tutor thank u

  • @caroleserpell8869
    @caroleserpell8869 5 лет назад +9

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

  • @payalyadav1012
    @payalyadav1012 2 года назад

    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 💐

  • @shilpaprabhudesai9444
    @shilpaprabhudesai9444 2 года назад

    Best explanation, proper example , straight to the point

  • @lalitabhandari6565
    @lalitabhandari6565 3 года назад

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

  • @WOS1962
    @WOS1962 7 месяцев назад

    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??

  • @sakhabhadrabhoi8908
    @sakhabhadrabhoi8908 Месяц назад

    Your teaching is Superb Sir,Love you from brain and heart😅😅😅

  • @VivekKumar-sh1ro
    @VivekKumar-sh1ro 3 года назад +2

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

  • @vivianintes6857
    @vivianintes6857 2 года назад

    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.

  • @chitturipapachari_garu1561
    @chitturipapachari_garu1561 4 года назад +1

    Your teaching way was great, very experienced 👍

  • @Munsur83
    @Munsur83 4 года назад

    Very simple and effective teaching method.

  • @badalsahoo5216
    @badalsahoo5216 4 года назад +1

    Thanks sir. Helped me a lot👍👍

  • @TheBhattacharya
    @TheBhattacharya 3 месяца назад

    UR BEST IN THE BUSINESS ❤

  • @vannelapraveenvannelaprave2556
    @vannelapraveenvannelaprave2556 4 года назад +1

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

  • @khushwinderkaur7586
    @khushwinderkaur7586 3 года назад

    Your teaching is mind blowing 😯😯😯

  • @rameshwarshukla3413
    @rameshwarshukla3413 5 лет назад +1

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

  • @ranganathmadishetty3051
    @ranganathmadishetty3051 5 лет назад +1

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

  • @govardhani1108
    @govardhani1108 4 года назад +7

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

    • @satishchaudhary7978
      @satishchaudhary7978 3 года назад

      Vedio kya hota hai

    • @ItsMe-cs9fu
      @ItsMe-cs9fu 3 года назад

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

    • @oparman69
      @oparman69 3 года назад

      video

  • @amitbais5163
    @amitbais5163 2 года назад

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

  • @sohanfc7
    @sohanfc7 4 года назад +1

    Your teaching is amazing love the video😍

  • @GurdeepSingh-wm6xt
    @GurdeepSingh-wm6xt 3 года назад

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

  • @creativityneverends-aaryak8186
    @creativityneverends-aaryak8186 2 года назад +1

    I understood all, it will help me in my exam STUDIES

  • @christinagaied2170
    @christinagaied2170 5 лет назад +5

    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
      @lordaarush955 4 года назад +1

      youll have to specify raaaaaange

  • @madhav1765
    @madhav1765 11 месяцев назад

    Most useful youtube channel❤

  • @abhinav1046
    @abhinav1046 4 года назад

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

  • @naveennvn4425
    @naveennvn4425 Год назад

    pawan lalwani. ....its an emotion

  • @sufyanmayo7611
    @sufyanmayo7611 5 лет назад

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

  • @senthilkumar-zl2wb
    @senthilkumar-zl2wb 4 года назад

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

  • @marcuspow
    @marcuspow 5 лет назад +1

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

  • @mukeshjha3964
    @mukeshjha3964 4 года назад +2

    Consolidation was really helpful ✌️✌️✌️

  • @mercypouline6034
    @mercypouline6034 2 года назад

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

  • @RajeevKumar-ue7qe
    @RajeevKumar-ue7qe 2 года назад

    very nice pronunciation with excellent technique of explaining.

  • @hemantthakur7564
    @hemantthakur7564 4 года назад +1

    Great explanation with perfect understanding

  • @rohitsinghrajput2592
    @rohitsinghrajput2592 3 года назад +1

    Great sir you teach soo well 👍👌👌👍👍

  • @memeworld5389
    @memeworld5389 3 года назад +1

    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🙂

  • @aqf2000
    @aqf2000 4 года назад

    Very useful and simple steps for consolidations thanks and Regards

  • @pranayprasad07
    @pranayprasad07 4 года назад

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

  • @shreyaacharya3024
    @shreyaacharya3024 9 месяцев назад +1

    Going through for my tomorrow's exam 😅

  • @mohannb5102
    @mohannb5102 3 года назад

    Your teaching is good. Can be easily understood
    Thank you

  • @najiafatima679
    @najiafatima679 3 года назад

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

  • @bjpwin24
    @bjpwin24 Год назад

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

  • @alinurmohamed5304
    @alinurmohamed5304 Год назад

    A very HUGE and BIG THANK YOU.👍

  • @haniyamadeeha145
    @haniyamadeeha145 2 года назад

    I have my exam in 20 mins ... and i am watching it now!

  • @shanthim1655
    @shanthim1655 3 года назад

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

  • @ilia2000
    @ilia2000 10 месяцев назад

    I love your explanation. Thank you so much.

  • @maheshtamhane2230
    @maheshtamhane2230 3 года назад

    Very professional... Thanks for your contribution.

  • @jagsaransingh1653
    @jagsaransingh1653 5 лет назад

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

  • @Doshib48
    @Doshib48 5 лет назад +2

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

  • @rangiroa100
    @rangiroa100 Год назад

    Yeah!!!! Another wonderful presentation.

  • @inbapandian8818
    @inbapandian8818 4 года назад

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

  • @mah_nizzle161
    @mah_nizzle161 3 года назад

    Any changes can also be updated without adding link to the consolidation...
    you just have to go to the consolidate option once again after you've made any changes..nd just press okay..excel will automatically update the data..you can update your consolidation this way as many times as you want

  • @faadumodirir223
    @faadumodirir223 4 года назад

    my Names Fadumo iam from somalia you are the best teacher ,thank you

  • @LtSCS
    @LtSCS 5 лет назад

    Please make a video on fundamental analysis of stocks using market data, I have seen in getmoneyrich youtube channel and data should change on daily basis and on every quarterly results of company, since 90% people don't have this idea and are in need of it.
    Hope it will helpfull to millions of people.
    Your efforts and way of teaching is simply superb and thanks to you and your company.
    Hope you will do the needful
    Regards

  • @sandzstudio
    @sandzstudio 4 года назад

    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

  • @samuelmeende2325
    @samuelmeende2325 5 лет назад

    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

  • @mathumkp9371
    @mathumkp9371 4 года назад +1

    The Teacher's teaching is very simple and understandable. Greetings to him.

  • @basharatcma6898
    @basharatcma6898 6 лет назад +2

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

  • @kurakulasandeep9679
    @kurakulasandeep9679 4 года назад

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

  • @anjig4240
    @anjig4240 2 года назад

    Excellent teaching skills sir. Tq for information.

  • @navaskader6243
    @navaskader6243 3 года назад +1

    Thanks a Million Sir...... it helped a lot

  • @murigeshshekha6543
    @murigeshshekha6543 4 года назад

    Excellent tutorial

  • @balaraama
    @balaraama 4 года назад +1

    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

  • @aashirashraf1178
    @aashirashraf1178 4 года назад

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

  • @pibidenalanka987
    @pibidenalanka987 2 года назад

    Thank you very much for explaining well.

  • @ashachauhan1892
    @ashachauhan1892 4 года назад +1

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

  • @saochhysophal3895
    @saochhysophal3895 4 года назад

    Teacher!!! Thank u so much from cambodia.😍😊😊😊

  • @PSKansahari
    @PSKansahari Месяц назад

    Very helpful for my practical exam 😊😅😢🎉

  • @nguntinpar977
    @nguntinpar977 5 лет назад +1

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

  • @shubhamsaini-4271
    @shubhamsaini-4271 Год назад

    Best explanation sir thankyou so much ❤

  • @srdstedli5805
    @srdstedli5805 4 года назад

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

  • @kameshsubramanian2553
    @kameshsubramanian2553 3 года назад

    Awesome way of explaining

  • @saratsrinivas4857
    @saratsrinivas4857 2 года назад

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

  • @harihar68
    @harihar68 4 года назад

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

  • @NaveenKumar-zr7mo
    @NaveenKumar-zr7mo 5 лет назад

    Thanks a Lot Sir., Mind blowing Explanation...
    But I've one query in Ms Excel Consolidation sir.
    Tht is in order to get the correct answer the Column names & row headings too must be in same identical order or it can be in Jumbled Order...
    Pls clear this Doubt sir...

  • @pavankumarr8735
    @pavankumarr8735 3 года назад +1

    You're just Awesome !!! ❤️

  • @ramzein776
    @ramzein776 4 года назад

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

  • @piyushchauhan1986
    @piyushchauhan1986 Год назад

    Thank you so much for wonderful explanation

  • @jatinbasumatary4644
    @jatinbasumatary4644 4 года назад

    Sir really you made crazy for my data analysis

  • @renukapadarthi7744
    @renukapadarthi7744 2 года назад

    Ur teaching is very nice