Excel Pivot Table Tutorial for Beginners
Вставка
- Опубліковано 24 лип 2024
- Want more Excel videos? Here’s my Excel playlist: • Excel for Beginners: E... In this 2020 video, I will show you to use pivot tables in excel. This excel pivot table tutorial for beginners will show you how to create a pivot table, analyze the data in a pivot table and how to graph in your pivot table data. Learning pivot tables can save you a lot of time and are easy to use.
Download sample data used in the video. Make sure to click the download arrow in the top right corner: drive.google.com/file/d/1O0Qy...
Other Microsoft Excel Tutorial:
Microsoft Excel Tutorial - Level 1: • Microsoft Excel Tutori...
Microsoft Excel Tutorial - Level 2: • Microsoft Excel Tutori...
Microsoft Excel Tutorial - Level 3: • Microsoft Excel Tutori...
VLOOKUP Function Tutorial: • Vlookup Function in Ex...
How to Make a Line Graph: • How to Make a Line Gra...
10 Best Excel Tips for Beginners: • 10 Best Excel Tips for... - Авто та транспорт
You're an extremely gifted teacher. Your tutorials sky rocketed my Excel skills and secured my career. Thank you so much!
I'm in awe... he's the best!
I’ll be posting the same comment soon
#bestfreepivottabletutorial
me too bro. Im watching this for my job and it's really helpful thanks teacher's tech
What a great use of 12 minutes! Excellent, concise tutorial. Thank you!
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!
EXCELLENT learnt a lot beautifully presented to learners really awesome thanks
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 UA-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.
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! 🙂
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!
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!
Fantastic content, your whole Excel course is making Something I found very intimidating/daunting a lot more understandable, Thank you so much
Watching while on lockdown and I just wanted to say thank you. The way you explain is so easy to understand. Thanks a lot!!!
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😌👏💚
Jamie, Great Instruction. I'm learning so much through you're tutorials and it's Broadening my IS Background.
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.
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!!!
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.
Making your sample information available so that your viewers could practice it added a great deal to this video. Thanks.
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
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!
The best tutorial I’ve seen and I’ve been searching.Thanks a million!
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
Your awesome shortcuts are just fabulous and have learned a great deal; appreciate ya! Please keep them coming!
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!!!
and here I was thinking Pivot Tables were so difficult!!!! wow you are so gifted! Thank you so much!
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^^
Will wemakuy johjkbnm aaoybh9
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.
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
This was an amazing tutorial for the beginner. I was able to follow along and easily understand. Thank you!!
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.
i've been watching 27 videos of your excel for 2 weeks, now am better skilled at excel, thank you so much.
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!!
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..
This is great information. I am brand new to pivot table creation and you make it very easy to understand.
Vlookups and pivots have been the only thing holding my career back, much love
Thank you for a simple and detail explanation! I feel more confident now because of your sample data and immaculate tutorial 👏
This was a great tutorial, thank you for taking your time, I really appreciate how you elucidated every detail.
Extremely useful short tutorial to refresh my Excel skills. Thank you so much!
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.
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.
Wow, this is great! Nice idea to add the link and explain how to download. I'm learning a lot.
Great Tutorials. They all are very easy to understand! Thank you
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
thank you teacher your way of explaining lessons is really great.
You're AMAZING! Such great tutorials- easy to follow and udnerstand= LOVE IT!❤❤❤❤❤❤
I could leran an Excel from scratch because of your amazing vedios. Thank you so much for making such useful vedios.
Hi, I just want to say thank you a lot to help me for those tricky tips .
Thank you so much! For explaining in an easy way..
Great videos! These are helping me refresh my skills. Definitely clear and concise.
Glad to help!
Thank you so much, you are really a gift to our generation and generation to come, thank you so much again.
Thank you so much you are indeed a good tutor. I have benefited a lot.
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. :)
Thanks online tutor, I have watched from Papua New Guinea🇵🇬 and prepare for my mid semester exam
The greatest teacher EVER. Thank you!
The tutorial was super helpful and very easy to grab. Thank You
Thank you alot ...very helpful and professional will continue learning more ..
I"m just starting on excel and your videos has really been helpful.Gracias
You're very welcome!
i really enjoy watching ur vid's. So easy to understand and follow. Thank you so much for sharing :)
I love the training. God bless you
Love this channel so much! The best teacher on UA-cam!
Thank you for this, I had to learn pivot tables from scratch for a pre-interview task.
I'm learning so much with you!!! Can't thank you enough
Hi Jamie,
Thank you so much, I really appreciate your time. very useful videos.
Very useful and informative. Thank you for your online coaching
Very helpful. You explained it thoroughly. Thank you.
Good video and well explained. Could you also explain how you would duplicate certain data to show in alternative forms i.e. if you had the total can you also show the average/mean/median information below or above the total?
Sort and informative! Loved it! Thank you very much👌
thanks for your useful teachings. you are wonderful
Thanks,a lot, Way of teaching is extra ordinary, Way of delivering is super, God bless you always.
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!
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. :)
You're very welcome!
SO THANKFUL for these videos!!!!
Thanks, sir, appreciate your work.
Excellent Tutorial. Best teacher I've seen to date. 5 Stars
Explained very well. Thank you Jamie!
I love your videos! You explain things so well.
Thank you!
Just took a 90 minute workshop on Pivot Tables, and this was better!!
Thank you. Additional knowledge on my Excel skills. Well explained.😍
Greatly appreciate all the vids - very helpful!
Amazing. Thanks for the step by step instructions.
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 !
want to appreciate your teaching. great job
New to pivot tables and i am so lucky that I found you.
Thanks A lot
Sir
you've done a marvolous excel job.
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.
You made it easy!!! thank you!
This is so cool! Thank you! My sister and i will look at your tutorial tomorrow!
THANKS SO MUCH EXTREMELY POWERFUL TUTORIALS
thank you so much for this information really helpful
Jaime your the man.
Merry Christmas to you and your family 👪
You are simply the best!
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!
Thank you so much! I have a new job, your video is excellent!
thank you. your videos are great - you explain things so well. just learnt =xlookup from another of your videos. thank you again. :)
Thankyou finally i have learnt something which seemed to be hard well explanation keep up
You're so wonderful in excel, am greatful,I understand your teaching very well, thank you so much.
You're very welcome!
Thank you So much. You are an amazing excellent coach
great video, helping prepare me for an interview
Excellent teacher!
Fantastic tutorial! Thanks so much
Thank you so much, teacher!
straight forward and simple to understand..👌
AWESOME tutorial
Super useful thanks guy!
SO FAR the best for me