Excel Pivot Table (Intro, Formatting, Grouping, Slicers, Calculated Fields) | FREE Excel Course

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

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

  • @ShyamKumar-ze4nc
    @ShyamKumar-ze4nc 4 года назад +20

    I don not how to appreciate you. No words to me. "A good teacher is like a candle - it consumes itself to light the way for others"

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

      I know Im asking randomly but does anyone know of a method to get back into an Instagram account..?
      I was stupid lost the password. I would love any assistance you can give me

  • @RajeshGupta-si1te
    @RajeshGupta-si1te 3 года назад +13

    Just in mid of a tutorial and i feel really impressed with your content, it flow, your voice, clarity of what is being taught. Dear all, i never had to stop the video even once to go back that i haven't listened or understood. God bless your efforts. thanks, very educating

  • @profoundexpressioncollecti365
    @profoundexpressioncollecti365 3 года назад +6

    Honestly, I have watched many different excel videos. There are none out there who can explain, demonstrate and conduct these lessons as you do. You are genuinely brilliant!

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

    Brother....I am a self taught student of Excel and Word. This tutorial is extremely helpful for a person like me. Loved your teaching style as well. Thank you and God bless.

  • @yelenakovalyova5641
    @yelenakovalyova5641 4 года назад +6

    Wooow. It is amazing!
    You have taught that it can be easy to undersand and use it at work! I really appreciate your work. Thank you very much! I will rewatch this video several times to memorize all functions that you have given in the video. Thanks for your work and knowledge.

  • @deb-deb17
    @deb-deb17 4 года назад +6

    I share your tutorials and videos with my students, you are a huge hit. Thank you for all your hard work.

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

    Excelent Tutorial. Well Explained, and give all the important details. Thank you! This saves a lot of time searching and watching many different videos , it has it all.

  • @prernalal9887
    @prernalal9887 2 года назад +3

    Sumit, these videos are pure GOLD! Thanks for making it so simple to understand. Your channel is my Go-to for any Excel related query! :)

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

    except for the wrong spelling of your name in the subtitiles, find this video very encouraging with "even if you do not know anything else in Excel ..." makes me want to continue watching; keep up the good job, your coffee will come, but maybe not right away; thank you very much for keeping this video alive from May 2019 onwards; blessings to you

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

    This is an excel tutorial. You explain the subject matter extremely well, and easy to understand and follow.

  • @qurbaanshaikh9876
    @qurbaanshaikh9876 4 года назад +3

    Sir, you are having great skill to teach Excel. I am amazed.
    It is very helpful.

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

      Glad you found the video useful!

  • @bhuvanpandey8816
    @bhuvanpandey8816 4 года назад +4

    You are a rockstar 👍

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

    I Was always nervous using excel as i dont have much knowledge of excel but seein your videos is giving me confidence that excel can be mastered

  • @nilimafreelancer5726
    @nilimafreelancer5726 Год назад +1

    Excellent video. Explained in the understandable way. Thank you so much

  • @twinklekhanna2770
    @twinklekhanna2770 7 месяцев назад +1

    oh my god, I really loved your video.. This video is so good....really really helpful... Now i can say I know Pivot Table. Thank you so much :)

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

      Glad you found the video useful

  • @simplysagar2688
    @simplysagar2688 3 года назад +2

    Such a simple and unique way of explaining ...Other channels just market only big commitments bt not up to the mark ...Btw explanation of grouping and charts is awesome ....Thanks bro😇😇

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

    Very well presented and very unpretentious. Thanks so much!

  • @PARAGKADAM
    @PARAGKADAM 2 года назад +1

    Thank you so much, very effective video.
    Very helpful.
    Examples and way of explaining is on point.
    Thank you once again. ❣️

  • @vivianemattos6142
    @vivianemattos6142 2 года назад +1

    Very useful and well-explained pivot table! A must-subscribe channel to have it. I had saved all your videos. I had to change the playback speed because it seems like you were running on 100 watts!!! LOL Thank you sooo much for all the content!!!

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

    Thank you so much for this video.

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

    You are a great teacher!

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

    Thank you so much sir, the way you explain and the pace - it's amazing and easy to grasp

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

    Thank You for a simple and comprehensive video of this feature.

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

    Great video!! very helpful

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

    Bohot badhiya banaya dost.

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

    Too good sumit sir as always 👌
    Keep going. Real Trump 👏

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

    Superb Video. Excellent teaching. Thanks a lot. Keep it up.

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

    Its just AMAZING!!! I wish you can be my teacher.

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

    Great sir. Excellent teaching

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

    this is the tuition i wan bro love you

  • @radhikaagarwal4591
    @radhikaagarwal4591 7 месяцев назад +1

    Amazing work

  • @margad-erdeneboldbaatar4704
    @margad-erdeneboldbaatar4704 2 года назад

    Thanks for the this course.

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

    Excellent Video...

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

    Fantastic video👍

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

    great knowledgeable stuff......thanks

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

    Great teacher

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

    great video, thank you so much!

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

    Very good video Sir. nicely explained and made it very interesting for me to learn more.

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

    very useful lesson.

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

    You are wonderful, thanks

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

    Very helpful. Thanks

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

    Thanks for so helpful guide!

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

    You are excellent

  • @ShyamKumar-ze4nc
    @ShyamKumar-ze4nc 3 года назад +1

    your communication is nice. 30.09.2020

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

    Thank you for this video. It is so helpful.

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

    Amazing love your sir

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

    Superb sir

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

    Dear sir, did you upload more videos on pivot table in this channel? I like ur teaching style!!!
    Thanks for all these free tutorials

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

    Keep up bro.

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

    👍

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

    Nice video. @19:20 you could just removed the applied filter in cell A4.

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

    If you really want to help us to learn excel practically please do provide this data so that we can practice and get hands on experience.

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

    Video is awesome. could you kindly provide a link to download worksheet to follow along

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

    nice great job

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

    Hi Mr Bansal.. Hope you are doing good.. I really like your videos and learnt a lot..
    Could you pls let me know if there is any way where we can repeat our columns in pivot table after each item-
    for eg in this video after selecting “Report Layout” and changing it to Tabular form then the data is separated- so my question is it possible to have geography, hardware, software headers for all sales rep respectively.

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

    Hi Sumeet, can you please help me with my query? How to sort coloured cells in pivot table? Thanks....

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

    Ques is if we are changing year in master data why it not changing in pivot table

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

    Where from i can get the worksheet for practice?

  • @SarangManzoor
    @SarangManzoor 2 года назад +1

    I have a question. while using the Calculated field in the Pivot table, I need to count no of times a certain name is repeated, along with calculating the percentages of that repeated names, how can I do this if this data is arranged day wise and the spelling of names are always **not** the same for each day.

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

      I have a unique code assigned to each worker each day, but my supervisor needs data in names as my field of work is totally volunteering, so not always the same worker. and also sometimes the same worker who worked on day 1, appears on day 3, so it is quite difficult to analyze to see the progress of the workers.

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

    Hi i'm your regular watcher. i practiced all the skills you delivered but the pivot table i cannot practice because the practice file is not an easy job to make such like you because its a huge data. kindly provide the practice file in the description please

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

    Hello sir, please let me know how to calculate % of works completed against total no of works in pivot table and get a report in sub and grand total. Thanks in advance

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

    when pivot table is available what is the need for complex formulas

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

    so how different are pivot charts from the dynamic charts

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

    how to do dynamic pivot where the table size /data will keep changing month of month as i am working on creating a a template that will be used for each month to consolidate the task with their time and sub-category of work

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

    Excel file doesn't have contracts column.

  • @RohitJethwani-wb8wk
    @RohitJethwani-wb8wk 4 месяца назад

    the file which is available for downloads is not containing the contract field please add this field

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

    how to connect a slicer to pivot table filter

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

    the file you are using please share with us

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

    The excel file does not have contracts?

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

    Sumit sir, I like to learn coding in excel, is there any way to earn from u

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

    Dude you do not have thousand rows, you only have 1000 rows. Why do you lie ?