Excel Pivot Table Tutorial for Beginners

แชร์
ฝัง
  • เผยแพร่เมื่อ 4 พ.ย. 2024

ความคิดเห็น • 262

  • @googlereviewer4039
    @googlereviewer4039 4 ปีที่แล้ว +212

    You're an extremely gifted teacher. Your tutorials sky rocketed my Excel skills and secured my career. Thank you so much!

    • @tiamthembu19
      @tiamthembu19 4 ปีที่แล้ว +7

      I'm in awe... he's the best!

    • @romeonetili6658
      @romeonetili6658 2 ปีที่แล้ว +1

      I’ll be posting the same comment soon

    • @EONNOE0201
      @EONNOE0201 ปีที่แล้ว +1

      #bestfreepivottabletutorial
      me too bro. Im watching this for my job and it's really helpful thanks teacher's tech

  • @mohansahareti4678
    @mohansahareti4678 ปีที่แล้ว +2

    and here I was thinking Pivot Tables were so difficult!!!! wow you are so gifted! Thank you so much!

  • @margarete8054
    @margarete8054 4 ปีที่แล้ว +27

    Thank you so much! I'm 60 and back in college and they assumed everyone was familiar with Excel! You explain things so clearly, I'm catching on!

    • @wilfredbalasundaram471
      @wilfredbalasundaram471 3 ปีที่แล้ว +1

      EXCELLENT learnt a lot beautifully presented to learners really awesome thanks

  • @adelesuffield9984
    @adelesuffield9984 2 ปีที่แล้ว +27

    I've avoided Pivot Tables for decades (making life more difficult for myself) because I thought they were just too complex. Your video revealed them to be so simple, I thought I must have missed something! I went to work, easily sorted some important data for my job and can't wait to use PVs again! I'm now going to watch your videos on V Lookups etc and get those mastered too. Thanks so much! You're a great teacher! Wish I'd had the benefit of your tutorials years ago! 🙂

    • @michchen1001
      @michchen1001 ปีที่แล้ว +1

      I am having the same thinking.. always think that PV is such a difficult table and it is belong to very senior management to use.... This video really make me gain back my confident and I am now having an open minded to pick up whatever I have left behind or trying the escape and avoid of learning them. Thank you, Sir!

  • @peacefreedom1913
    @peacefreedom1913 2 ปีที่แล้ว +14

    What i like about your lessons is that you really go back to the basics and explain everything, there are some other good instructional videos on TH-cam but they often skip through steps and assume you know what they are doing, and that doesn't help the real beginners who are trying to master Excel. The sample data file was also very helpful.

  • @Askawest53
    @Askawest53 ปีที่แล้ว +4

    Doing my own professional development and mind blown. Set up spreadsheets to take my job from paper to computer 2 years ago and wanted to learn more as Excel is constantly changing and can be hard to keep on top of changes. Discovered pivot tables (a coworker mentioned they were great) and WOW. It quickly pulls info I have been manually assembling for management! WOW. Thank You!

  • @Preya31
    @Preya31 ปีที่แล้ว +10

    I cannot say enough about these tutorials. Before this, I used to think learning Pivot tables would be difficult. I am learning and understanding so much about Ms Excel, I didn't think it would be this easy to understand and comprehend everything. Thank you so much for making this so simple and easy to understand😌👏💚

  • @todwillman8982
    @todwillman8982 ปีที่แล้ว

    I've looked at three of these including one from a Microsoft Representative. This guy has a gift. An amazing facilitator. Thank you Teacher's Tech.

  • @sihamfarhan6438
    @sihamfarhan6438 ปีที่แล้ว

    i've been watching 27 videos of your excel for 2 weeks, now am better skilled at excel, thank you so much.

  • @maxhistoryandecon8408
    @maxhistoryandecon8408 ปีที่แล้ว

    Making your sample information available so that your viewers could practice it added a great deal to this video. Thanks.

  • @frostyboi312
    @frostyboi312 2 ปีที่แล้ว

    Vlookups and pivots have been the only thing holding my career back, much love

  • @maxinechantel2393
    @maxinechantel2393 ปีที่แล้ว

    Thank you so much. I appreciate you taking the time to explain Pivot Tables Step by Step mentioning to click inside the table for the values to appear within the Pivot table. Very helpful. Thanks

  • @susandyer8860
    @susandyer8860 3 ปีที่แล้ว +14

    What a great use of 12 minutes! Excellent, concise tutorial. Thank you!

  • @tausifrahman7189
    @tausifrahman7189 3 ปีที่แล้ว

    Thank you boss. Been bored outta of my minds after my grade 12. So I have been spending my time watching your vids and learning EXCEL as much as possible.

  • @jackiechambers1666
    @jackiechambers1666 4 ปีที่แล้ว +3

    Thanks, I now feel so ignorant. I have been using Excel for over 20 years (I think) and never knew the tip of what it can do. You're doing an awesome job and teaching this 65+ yr old new tricks and you explain so well. Keep up the good work.

  • @michaelstacey9143
    @michaelstacey9143 2 ปีที่แล้ว +11

    Fantastic content, your whole Excel course is making Something I found very intimidating/daunting a lot more understandable, Thank you so much

  • @harmoniaSINGS05
    @harmoniaSINGS05 2 ปีที่แล้ว +1

    So grateful YTube algorithms presented me your channel! Currently preparing for my new role that's Excel heavy.

    • @TeachersTech
      @TeachersTech  2 ปีที่แล้ว +1

      Happy these videos could help you out! Good luck on your new role!

    • @harmoniaSINGS05
      @harmoniaSINGS05 2 ปีที่แล้ว

      @@TeachersTech many thanks! Tbh my new role said to look at pivot tables, vlookup, and sort/filter. should i just go over the entire beginner's playlist to arrive prepared?

  • @garyfreeman6277
    @garyfreeman6277 2 ปีที่แล้ว +1

    THIS...IS....EXCELLENT!!!!! I have a new role at work, that requires a monthly report and usage of Pivot Tables, and I am an absolute neophyte when it comes to Excel (except for basic row and column data) and this is helping me tremendously. I think I'm going to take your basic course also! THANK YOU!!!

  • @fernandabrunhara6535
    @fernandabrunhara6535 2 ปีที่แล้ว +2

    I will have a case study at work and found your channel! Thank you so much for your time! one of the bests that i watched so far!!!

  • @ortiziriser
    @ortiziriser 7 หลายเดือนก่อน

    New to pivot tables and i am so lucky that I found you.

  • @ppirotongtongie
    @ppirotongtongie 3 ปีที่แล้ว +6

    I've only been a few days, but my abilities have improved considerably because of the help and knowledge that I get from you. Thank you sir! God bless you! Stay safe, stay healthy^^

    • @mikeorcutt1879
      @mikeorcutt1879 3 ปีที่แล้ว

      Will wemakuy johjkbnm aaoybh9

  • @mikeorcutt1879
    @mikeorcutt1879 3 ปีที่แล้ว +2

    Jamie, Great Instruction. I'm learning so much through you're tutorials and it's Broadening my IS Background.

  • @danielyeuhie5896
    @danielyeuhie5896 ปีที่แล้ว

    Thanks online tutor, I have watched from Papua New Guinea🇵🇬 and prepare for my mid semester exam

  • @Alex-jb4ke
    @Alex-jb4ke ปีที่แล้ว

    The greatest teacher EVER. Thank you!

  • @nataliepeachey1958
    @nataliepeachey1958 ปีที่แล้ว

    Thank you for this, I had to learn pivot tables from scratch for a pre-interview task.

  • @janinamcintyre4945
    @janinamcintyre4945 2 ปีที่แล้ว +1

    These excel videos have been the most informative. Thankyou for taking the time to show others what you know, and in a way that's so kind

  • @TheHajilen
    @TheHajilen 2 ปีที่แล้ว

    You are the most clearest and most understandable teacher i ever watch, I learned a lot from you, Thank you i needed this for my Job Application..

  • @ashishkevadiya9364
    @ashishkevadiya9364 3 ปีที่แล้ว

    I could leran an Excel from scratch because of your amazing vedios. Thank you so much for making such useful vedios.

  • @andikaneduok1674
    @andikaneduok1674 11 หลายเดือนก่อน

    This was a great tutorial, thank you for taking your time, I really appreciate how you elucidated every detail.

  • @williacrew926
    @williacrew926 2 ปีที่แล้ว +2

    This was an amazing tutorial for the beginner. I was able to follow along and easily understand. Thank you!!

  • @daomai9915
    @daomai9915 ปีที่แล้ว +1

    Thanks so much for this lesson. This is awesome and helpful video and your training is very clear, easy to understand, and fun, too. Again, thank you so much Jamie.

  • @kariellis5475
    @kariellis5475 ปีที่แล้ว

    Wow, thank you so very much! I never thought I figure out how to use Excel or pivot tables but you are making it happen. Thank you for the download so I have data to practice. I appreciate your teaching style and knowledge!!

  • @Theoneonlygirlabby
    @Theoneonlygirlabby ปีที่แล้ว +1

    I love the training. God bless you

  • @axa5005
    @axa5005 4 ปีที่แล้ว +3

    The best tutorial I’ve seen and I’ve been searching.Thanks a million!

  • @belloabiola9190
    @belloabiola9190 3 ปีที่แล้ว +1

    I"m just starting on excel and your videos has really been helpful.Gracias

  • @djswiggy3578
    @djswiggy3578 5 หลายเดือนก่อน

    Just took a 90 minute workshop on Pivot Tables, and this was better!!

  • @sgit1
    @sgit1 4 ปีที่แล้ว +3

    Pivot tables concept always a grey area for me . . . until now. Thank you and stay safe!

  • @tasoma5759
    @tasoma5759 3 ปีที่แล้ว +2

    This is great information. I am brand new to pivot table creation and you make it very easy to understand.

  • @Cellia836
    @Cellia836 11 หลายเดือนก่อน

    Thank so much for this video. I found it very helpful. I'm a new Analyst in my career and I need to learn more about it Pivot tables and you make it easy to understand. :)

  • @Vicky-ke5bi
    @Vicky-ke5bi 2 ปีที่แล้ว

    Extremely useful short tutorial to refresh my Excel skills. Thank you so much!

  • @MortgagewithMe
    @MortgagewithMe 3 ปีที่แล้ว

    You explain this so clearly. I took a class on Excel and I did not learn as much as I learned from watching your videos.

  • @babisantangelo
    @babisantangelo 4 ปีที่แล้ว +2

    Watching while on lockdown and I just wanted to say thank you. The way you explain is so easy to understand. Thanks a lot!!!

  • @tabassumghufran3129
    @tabassumghufran3129 2 ปีที่แล้ว

    Thanks,a lot, Way of teaching is extra ordinary, Way of delivering is super, God bless you always.

  • @isatazarafornah6295
    @isatazarafornah6295 2 ปีที่แล้ว +1

    You're so wonderful in excel, am greatful,I understand your teaching very well, thank you so much.

  • @michelecryan7009
    @michelecryan7009 3 ปีที่แล้ว +1

    Wow, this is great! Nice idea to add the link and explain how to download. I'm learning a lot.

  • @Diana-vo6rf
    @Diana-vo6rf 3 ปีที่แล้ว +1

    oh my, thank you sir! you explain much better than the online course I am taking ! maybe I'm a rather visual learner and that's why I'm getting more out of your tutorials. Anyway, thank you so much ! I will keep watching your videos!

  • @ess.hicham396
    @ess.hicham396 3 ปีที่แล้ว +1

    thank you teacher your way of explaining lessons is really great.

  • @tosinanthony3099
    @tosinanthony3099 3 ปีที่แล้ว

    You really broke this down in bits. I am glad to have jumped on this video to learn the basics of pivot tables. Thank you so much sir

  • @jadex38
    @jadex38 ปีที่แล้ว

    You're AMAZING! Such great tutorials- easy to follow and udnerstand= LOVE IT!❤❤❤❤❤❤

  • @nwpv7170
    @nwpv7170 2 ปีที่แล้ว +1

    Great Tutorials. They all are very easy to understand! Thank you

  • @moniquelewinski3261
    @moniquelewinski3261 3 ปีที่แล้ว +1

    Pivot Tables is very new to me and I had no idea what to do. This tutorial was very easy to follow. You explained everything so well. thank you so much. I will save this video and watch other ones. It was also helpful you provided the sample excel sheet to follow along. :)

  • @OdambsTech2020
    @OdambsTech2020 2 ปีที่แล้ว

    Thank you so much, you are really a gift to our generation and generation to come, thank you so much again.

  • @jillbern1587
    @jillbern1587 3 ปีที่แล้ว

    I've been working on GST and took me almost two weeks. Pivot is really a help and relief, too. I would like to watch more on pivot, Please. Thanks

  • @BigGuyZee
    @BigGuyZee ปีที่แล้ว

    I've got my old Excel 2003 so the look was different to me and I had a few extra/different steps, but great tutorial on Pivot Tables. I also watched the one on V-Lookups which was super helpful, thank you.

  • @user-lr9tt2ln1c
    @user-lr9tt2ln1c ปีที่แล้ว

    Excellent Tutorial. Best teacher I've seen to date. 5 Stars

  • @AnyTechyt
    @AnyTechyt 3 ปีที่แล้ว +2

    Thanks so much for your video, just thought I'd mention, that for some reason it's categorized as autos, unlike all your other video, but thanks so much for all your videos!

  • @geetkaur2343
    @geetkaur2343 4 ปีที่แล้ว +3

    Hi, I just want to say thank you a lot to help me for those tricky tips .

  • @cdawgRJ
    @cdawgRJ ปีที่แล้ว

    I'm learning so much with you!!! Can't thank you enough

  • @thegarozas
    @thegarozas ปีที่แล้ว

    Thank you for a simple and detail explanation! I feel more confident now because of your sample data and immaculate tutorial 👏

  • @tmarc1127
    @tmarc1127 ปีที่แล้ว +1

    Jaime your the man.
    Merry Christmas to you and your family 👪

  • @nzlucy9096
    @nzlucy9096 2 ปีที่แล้ว

    Love this channel so much! The best teacher on TH-cam!

  • @ashishsahu7795
    @ashishsahu7795 2 ปีที่แล้ว +1

    Hello. Good morning. I just saw your video on pivot and will be using it today at my work, will surely post another comment. It was easy to understand

  • @reginahnkoko5801
    @reginahnkoko5801 3 หลายเดือนก่อน

    This is amazing!!! Thank you for such a clear explanation.

  • @aishahbalogun6549
    @aishahbalogun6549 2 ปีที่แล้ว

    want to appreciate your teaching. great job

  • @michellerothwell5126
    @michellerothwell5126 3 ปีที่แล้ว +2

    Great videos! These are helping me refresh my skills. Definitely clear and concise.

  • @manyipascaline6452
    @manyipascaline6452 2 ปีที่แล้ว

    The tutorial was super helpful and very easy to grab. Thank You

  • @radsan3006
    @radsan3006 7 หลายเดือนก่อน

    Explained very well. Thank you Jamie!

  • @emmanuelkashimu3425
    @emmanuelkashimu3425 3 ปีที่แล้ว +1

    Thank you so much you are indeed a good tutor. I have benefited a lot.

  • @greensea66
    @greensea66 3 ปีที่แล้ว +1

    I love your videos! You explain things so well.

  • @sherlmurphy8713
    @sherlmurphy8713 4 ปีที่แล้ว +1

    Your awesome shortcuts are just fabulous and have learned a great deal; appreciate ya! Please keep them coming!

  • @lisasbautista9490
    @lisasbautista9490 2 ปีที่แล้ว

    Very helpful. You explained it thoroughly. Thank you.

  • @hanamov9921
    @hanamov9921 2 ปีที่แล้ว +2

    thanks for your useful teachings. you are wonderful

  • @sohamjadhav581
    @sohamjadhav581 3 ปีที่แล้ว +1

    Hey professor thank you so much sending you lots of love from india you are god gifted angel for us 🙏😇

  • @Yqwiuyy
    @Yqwiuyy ปีที่แล้ว

    Thank you from lebanon🇱🇧

  • @peggystreetinfluencer
    @peggystreetinfluencer 8 หลายเดือนก่อน

    This is so cool! Thank you! My sister and i will look at your tutorial tomorrow!

  • @mikaylapodesta4052
    @mikaylapodesta4052 2 ปีที่แล้ว

    SO THANKFUL for these videos!!!!

  • @deeyanatee2266
    @deeyanatee2266 4 ปีที่แล้ว +2

    Thank you so much! For explaining in an easy way..

  • @letstalkaboutoccupationalh8764
    @letstalkaboutoccupationalh8764 ปีที่แล้ว

    Amazing. Thanks for the step by step instructions.

  • @AleliAgda
    @AleliAgda ปีที่แล้ว

    Thank you. Additional knowledge on my Excel skills. Well explained.😍

  • @VIATEXAS
    @VIATEXAS 2 ปีที่แล้ว

    Jamie, I feel like I owe you tuition money. You are awesome sir!

  • @judithwatson2994
    @judithwatson2994 3 ปีที่แล้ว +4

    You are simply the best!

    • @kiawilliams5541
      @kiawilliams5541 3 ปีที่แล้ว

      Better than all the rest! ~Tina Turner🤣
      Seriously!! This is the most informative Pivot Table tutorial I've seen. He has a steady pace - NOT navigating too fast for beginners. I can get my course work done now with understanding!

  • @waleskaalvarez8520
    @waleskaalvarez8520 4 ปีที่แล้ว +4

    This was great! I’m going to watch it a few times and try it with the file. But it isn’t as scary as it looks or sounds.

  • @victoriagarcia113
    @victoriagarcia113 2 ปีที่แล้ว

    Thank you so much! I have a new job, your video is excellent!

  • @elviwolsiffer9367
    @elviwolsiffer9367 4 ปีที่แล้ว +1

    Very useful and informative. Thank you for your online coaching

  • @nokwandashazi2324
    @nokwandashazi2324 ปีที่แล้ว

    Enjoyed it im actually preparing for a test for tomorrow

  • @EXCELWORLD-ez8xy
    @EXCELWORLD-ez8xy 9 หลายเดือนก่อน

    superb!! extream level of teaching sir🥰🥰

  • @simonwinter4746
    @simonwinter4746 ปีที่แล้ว

    Great tutorial! I want to create a pivot table with data on multiple sheets, on in the same excel workbook. All the sheets have the same column headings. How do I do that? I tried putting () in the range and separating sheets by a , - but that didn't work for me. Many tks!!!

  • @Bustycummy
    @Bustycummy 2 ปีที่แล้ว

    great video, helping prepare me for an interview

  • @memydream9172
    @memydream9172 3 ปีที่แล้ว

    i really enjoy watching ur vid's. So easy to understand and follow. Thank you so much for sharing :)

  • @fauziyazubairu
    @fauziyazubairu ปีที่แล้ว

    straight forward and simple to understand..👌

  • @kingdaniel4684
    @kingdaniel4684 ปีที่แล้ว

    You're good. I barely comment. This is very helpful. Thank you

  • @raminasrallah6598
    @raminasrallah6598 2 ปีที่แล้ว

    Hi Jamie,
    Thank you so much, I really appreciate your time. very useful videos.

  • @realvirtualdemand4222
    @realvirtualdemand4222 ปีที่แล้ว +1

    good way to manipulate data

    • @realvirtualdemand4222
      @realvirtualdemand4222 ปีที่แล้ว +1

      you have to watch these videos several times in order to really graps the concept. Please highlight the fields that we need to go to.

  • @michaeltodd3067
    @michaeltodd3067 ปีที่แล้ว

    thank you. your videos are great - you explain things so well. just learnt =xlookup from another of your videos. thank you again. :)

  • @bernadetteweaver455
    @bernadetteweaver455 2 ปีที่แล้ว

    Very much enjoying these tutorials as new to all of this. What EXACTLY do I need to click to get example sheet to follow please?

  • @kinyanjuima
    @kinyanjuima 4 ปีที่แล้ว +1

    Thank you alot ...very helpful and professional will continue learning more ..

  • @husnainhyder6713
    @husnainhyder6713 2 ปีที่แล้ว

    Thanks A lot
    Sir
    you've done a marvolous excel job.

  • @janewambui6705
    @janewambui6705 3 ปีที่แล้ว

    Thankyou finally i have learnt something which seemed to be hard well explanation keep up

  • @clarinete09
    @clarinete09 3 ปีที่แล้ว +1

    You made it easy!!! thank you!

  • @jamfam3lthactch538
    @jamfam3lthactch538 8 หลายเดือนก่อน

    This was great, was there any way you can make a more in-depth or more challenging video regarding Piviot-Tables? Thanks for the great work man!