Excel Pivot Table Tutorial for Beginners

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

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

  • @googlereviewer4039
    @googlereviewer4039 3 года назад +205

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

    • @tiamthembu19
      @tiamthembu19 3 года назад +7

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

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

      I’ll be posting the same comment soon

    • @galadolevyp.1073
      @galadolevyp.1073 Год назад +1

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

  • @adelesuffield9984
    @adelesuffield9984 Год назад +26

    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!

  • @margarete8054
    @margarete8054 4 года назад +25

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

      EXCELLENT learnt a lot beautifully presented to learners really awesome thanks

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

  • @peacefreedom1913
    @peacefreedom1913 2 года назад +13

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

  • @Preya31
    @Preya31 Год назад +9

    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😌👏💚

  • @susandyer8860
    @susandyer8860 2 года назад +14

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

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

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

  • @todwillman8982
    @todwillman8982 9 месяцев назад

    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.

  • @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^^

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

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

    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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • @williacrew926
    @williacrew926 2 года назад +2

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

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

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

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

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

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

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

  • @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. :)

  • @andikaneduok1674
    @andikaneduok1674 8 месяцев назад

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

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

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

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

    You're so wonderful in excel, am greatful,I understand your teaching very well, 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.

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

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

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

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

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

  • @ortiziriser
    @ortiziriser 4 месяца назад

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

  • @Cellia836
    @Cellia836 8 месяцев назад

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

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

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

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

    I love the training. God bless you

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

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

  • @Alex-jb4ke
    @Alex-jb4ke 10 месяцев назад

    The greatest teacher EVER. Thank you!

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

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

  • @reginahnkoko5801
    @reginahnkoko5801 25 дней назад

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

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

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

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

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

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

  • @ess.hicham396
    @ess.hicham396 3 года назад +1

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

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

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

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

  • @Vicky-ke5bi
    @Vicky-ke5bi Год назад

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

  • @ashishsahu7795
    @ashishsahu7795 Год назад +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

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

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

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

  • @waleskaalvarez8520
    @waleskaalvarez8520 3 года назад +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.

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

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

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

  • @hanamov9921
    @hanamov9921 2 года назад +2

    thanks for your useful teachings. you are wonderful

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

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

  • @peggystreetinfluencer
    @peggystreetinfluencer 5 месяцев назад

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

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

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

  • @user-lr9tt2ln1c
    @user-lr9tt2ln1c Год назад

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

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

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

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

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

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

    Love this channel so much! The best teacher on RUclips!

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

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

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

  • @AderemiOrimoogunje
    @AderemiOrimoogunje 7 дней назад

    Thank you so much, Teacher's Tech.

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

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

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

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

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

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

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

    I love your videos! You explain things so well.

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

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

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

    Would like to see how to sort the pivot tables unless you have it in another tutorial??

  • @radsan3006
    @radsan3006 5 месяцев назад

    Explained very well. Thank you Jamie!

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

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

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

    Thank you from lebanon🇱🇧

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

    Very useful and informative. Thank you for your online coaching

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

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

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

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

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

    You made it easy!!! thank you!

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

    thank you for new users

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

    Enjoyed it im actually preparing for a test for tomorrow

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

    great video, helping prepare me for an interview

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

    Thank you so much, teacher!

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

    These are the type of people that go straight to heaven.

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

    Great video and thanks for the d/l data too! One thing: in your worked example you only have data for 9 people, in the download you get data for 10 people - so the numbers are slightly different !

  • @letstalkaboutoccupationalh8764

    Amazing. Thanks for the step by step instructions.

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

    SO FAR the best for me

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

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

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

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

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

    straight forward and simple to understand..👌

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

    Very helpful. You explained it thoroughly. Thank you.

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

    SO THANKFUL for these videos!!!!

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

    Excellent teacher!

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

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