Pivot Table Tutorial - Learn PivotTables in 1 Hour - Excel Crash Course
Вставка
- Опубліковано 16 жов 2024
- Get Four FREE Courses from Simon Sez IT ►
www.simonsezit...
To follow along with this how to use pivot tables class, you can download the Excel file here ► www.simonsezit...
In this pivot table tutorial in Excel, Microsoft aficionado Deb Ashby shows you:
How to prepare and clean your Excel data for a pivot table
How to use recommended PivotTables and create a pivot table from scratch
How to format, edit and display different results in a pivot table
How to create a chart from a pivot table using Pivot Charts
How to add a slicer to a pivot table and filter your data on the fly
This was an Excel crash course delivered by Simon Sez IT. To attend future classes live, sign up to the Simon Sez IT newsletter (scroll to the bottom of the page!) - www.simonsezit...
For more Excel tutorials and Excel lessons, take a look at our Advanced Excel 2019 course ► bit.ly/2WgDp9a
Or, some of our other training on UA-cam:
Excel 2016 beginner training: • Microsoft Excel 2016 C...
Access for beginner tutorials: • Microsoft Access 2016 ...
Project 2016 beginner training: • Microsoft Project 2016...
Visio 2016 for beginners: • Microsoft Visio 2016 T...
Word 2016 training: • Microsoft Word 2016 Tr...
Stay in touch!
SimonSezIT.com: www.SimonSezIT...
StreamSkill.com: StreamSkill.com/
UA-cam Channel: / simonsezittraining
Subscribe to our channel:
www.youtube.co...
If you enjoyed the video, please give a "thumbs up" and subscribe
to the channel ;-) #simonsezit
Dang!! I can see why he introduced her as the best Excel trainer ever!! Excellent tutorial worth every minute..
Thank you Sameer! I'm really pleased to hear your enthusiasm and that you enjoyed the training!
Indeed. Ms. Deb is the best trainer I have seen in my career. Her flow of teaching plan without umm. Aaa. Etc etc makes listener glued to the session.
I can continue to listen to her for countless hours. Her way of teaching is so nice.
Thank you Muhammad!
Another fantastic tutorial. In order to improve my Excel skills Simon Sez IT is a one-stop-shop for me.
Wow, thanks Philip! So glad you enjoyed it 😊 Additional Excel tips here if you need them -> ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
I absolutely love the presenter, her soothing but assertive voice, her pace, not too slow that you lose the track and not too fast that you can't follow. I also like how the tutorial explains the material in a gradual manner, from very simple to more complex and at the same time it is very compact. I watched tutorials on the topic by other channels, I couldn't get through some of them. They were all over the place, there was no logic, jumping from very simple concepts to very difficult. I got discouraged for a minute. Thank God, there is your channel. Thank you very much for your work!
Thank you for the kind comments, Ksenya! 😀 If you are interested in 5-hours of Deborah's soothing voice teaching Excel, you can get it here ua-cam.com/video/oN82Umc9MCQ/v-deo.html
Just did a company excel pivot table tutorial. Could have watched this and learned basically the same thing.
The magic of pivot tables makes me want to learn more about data analysis. So beautiful!
Glad it was helpful! 👍
this woman is a hero and the company offering free tutorials, is awesome. I expect the paid ones will be even better. I'll get my basics in check first. thank you so much you make learning a joy.
We're glad you liked it!
Deb is an absolute professional. Just completed her Beginner Course for Excel 2019 for Mac, and must conclude that her efforts make learning super easy and enjoyable. Props to her!
Deb wish you and the organization good health, wealth and success.
Thanks so much, I’m delighted to hear you’ve enjoyed the beginner course😀
ABSOLUTELY please share more about PivotTables topics. This video is wonderfully INFORMATIVE!
You got it!
Excellent content by an amazing presenter. Thank you for sharing your knowledge with the many of us.
Glad you are finding them helpful, Ghezae Z Kidane :-)
She is an excellent tutor! Explains in a very simple way and breaks it down for any level user. Thank you so much.
Glad you enjoyed it!
I am from Pakistan and 1st time on your youtube channel find it very fruitful and helping
As an excel student for the last 11 years, I've been learning more and more about pivot tables and other features, but I'm having some trouble using them.
Welcome to our channel😊 We have lots of additional free Excel training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
I am from Toronto and found your session very impressive and interesting.
Awesome, thank you!
Deb is by the far the best. She is incredible.
Glad you think so!
Wow! Excellent tutorial. Beginner here with pivot tables and this was absolutely helpful.
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Excellent crash course! I learn so much in just one hour. I realize this is from over 3 years ago, but hey it's still very useful in 2023!
That's great! A few more Pivot Tables tips we can teach you here ⏩ ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html and additional free Excel training 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
and here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
@@SimonSezIT Thank you! I plan to watch them all!!!
Fantastic webinar. I did not know anything about PIVOT tables but now I am confident as I could work easily with Excel.
Glad it was helpful!
Omg the first 20 mins of this video has already made my life 99999999x easier. Thank you for this!!!
Glad it helped!
Please more webinars on advanced pivot tables and charts and dashboards especially in using them for analytics. Really clear teaching. Kudos!
Thanks for the positive feedback Kemmy.
I'm from Mexico City and I'm very interest ed in Pivot Tables. Thank you!
Hello Maria! Thank you for watching our videos. Here's additional training on Pivot Tables ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
You both are out of this world.
-specific+one by one+latest.
That's very kind of you to say
OMG - This is one of the best tutorial ever on Pivot tables. I am lucky to have stumbled on this one.
Glad it was helpful!
Very good! First Time Pivot Table Creator! I learned!! I learned!
Thank you so much for the tutorial on Pivot Tables, so good. I feel like I will be able to use these now. Great tutorial.
Glad you enjoyed it. Thanks for watching! 😃
Absolutely the best instructions on Excel pivot table - thank you!
Glad you like it!
lovely, makes me feel less depressed about a task I have to do
This was a great refresher to a 10 hour course I took several years ago. The Tutorial presented was easy to follow and had just the right amount of detail without being to lengthy.
Glad it was helpful!
Excellent demystifying of Pivot Tables - look forward to more.
thanks for the great comment !
Great intrormation about the channel in the intro! The tutorial starts at 6:40
Delighted to hear that you’ve enjoyed the tutorial!
Fantastic presentation. So easy to follow and understand. Such a gem and must watch. Thank you.
You're very welcome! Additional free Pivot Table training here 👉ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
This online course is very very useful and helpful tutorial for my daily activities . I learnt so much about pivot tables and start to exercise it. I didn't know anything about them before your tutorial so I am extremely grateful for the course. Thank you so much. keep it up! and adding other courses too.
Glad it was helpful! We have additional Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
It was worth every second!! Wish had landed on this Gold mine long time ago. THANKS.
Glad it was still helpful!
I learned a lot. Easy to understand. How about topics about the vlookup using multiple sheet and folders?
I have watched a lot of tutorials but this is the best ever Excel tutorial video! Loved it! Crystal clear, all doubts cleared even before asking, this is what perfect teaching is. Thanks and lots of love and best wishes, all the way from India.
Thanks for taking the time to review us. I'm delighted to hear that you've enjoyed the tutorial!
very good trainer ever I watch, thank you very much
Thank you, much appreciated!
Wina from NY. Looking forward for this lesson to learn more about Pivot functionality.😊
Hi Wina! I hope you are having some nice Fall colors in NY 😃
I watched It Today 😊😊❤❤❤❤.. Brilliant! it was Fantastic
Great webinar - clear and concise. Appreciate Deb's approach. Thanks again!
Glad you enjoyed it!
You are amazing mam, great way of communication too..
Thanks 😊 There is additional Excel training here if you need it -> ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
I'm in PA. Thank you for sharing all that knowledge.
Our pleasure! Thanks for watching!
To follow along, download the example file Debs uses here: www.simonsezit.com/article/learn-pivot-tables/
✅Get our free 3-hour Excel course on UA-cam ➡ ua-cam.com/video/ZNGqeCcTu0Q/v-deo.html
🔥Need training for Excel 2021/365? Check out our free 10-hour training course on UA-cam ➡ ua-cam.com/video/fODnNDNMXiI/v-deo.html
😊 We have a lot more courses on MS Office which you can find here ➡ ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
My name is Tamil from India and I love you channel and professional teachings.
Thanks for the kind comments 🙂
Thank you so much Deb, you helped me a lot. Hugs. Sincerely
Thanks Danilo! Hugs to you too!
Excellent Webinar !!! I am glad that I chose yours... looking forward for more to attend
Welcome aboard! Delighted to hear that Nanda!
This was a really useful and helpful tutorial. I learnt so much about pivot tables. I didn't know anything about them before your tutorial so am extremely grateful for this crash course. Thank you so much.
the to tutorial of pivot table helped me fill confident to find a job
tnks a lot!!!!!!!!
That's sounds awesome!
O My. wow wow. This is so educative even better than my tutor. Thank you all so much. I will follow you from now on.
Glad you enjoyed the tutorial. Thanks for watching :-)
This was so helpful OMG:) I was very afraid to learn pivot charts, but this make me feel so much better!!!
Thank you. I'm really glad it was helpful to you
Absolutely wonderful presentation!
Thank you kindly!
Very useful and clearly explained. Thanks for the presenter.
Our pleasure! Thanks for watching 🙂
Excellent experience... learn a lot... Thank u very much
It's my pleasure
Awesome video! I always wondered what Pivot Tables were all about. Now, I know and love their power. Thank you for a fantastic webinar.
You are welcome Taz
This was amazing! Thank you so much! I learned so much in addition to the tables. Going to strongly recommend it to my team!
Thank you so much. I'm delighted that you've enjoyed it!
I absolutely loved this! I have learned so much. This lady is made for teaching, she made it very interesting. Thank you!
Glad it was helpful Joeline!
i know im randomly asking but does any of you know a trick to log back into an Instagram account?
I was dumb forgot my password. I appreciate any help you can offer me!
Thank you for this information, you made it look super easy.
Glad it was helpful!
It really starts at 7:55. Great course btw!
So helpful, You are a wonderful Teacher.
Thank you! 😃
it was really an excellent presentation and i could learn a lot in regards to Pivot table. Still I have some queries. Pls advise where I can share them so that you can help me with your expert answer to them
Excellent tutorial! Have started learning excel skills watching your videos. Thank you.
Great to hear!
A day can't go without making reference to Debbie's You Tube channel. Her presentation skills are top notch
The video was amazing. Thanks for sharing your knowledge. Thank u so much..
You are welcome. Thanks for watching!
Excellent Mam, you are best till now my best online excel video..
Thanks @simon Sez IT
Most welcome!
Hi My name is Bhavna and I am from London this is my first attempt to learn pivot table. Thanks
I learned so much about pivot tables in a short period of time.
great explanation of pivotal table.
Amazing webinar and so great lesson I'm so grateful to you
I'm really pleased to hear you enjoyed it Abdullah!
Excellent presentation. I have learned a lot. thank you
Glad it was helpful!
thank you so much for a very useful webinar
Glad it was helpful, Mohammad H. Ibrahim. If you need additional training, we have it here -> ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Excellent work. Thank you for simplifying Pivot Table & Charts for me.
Glad it was helpful!
Very interesting, informative and useful
Thank you so much for the clear presentation, I will be looking through the various offerings.
You are welcome Celine, do join us!
It was great the way that you explained the content! I will check all your videos!
Awesome, thank you!
Watching this a bit late but it has been of great help. Clear to the point and covers alot. Thank you.
You're very welcome, Njambi. Thank you for watching :-)
I am an Excel trainer too and this was excellent. Your delivery skills are top notch
So nice of you!
Very nice and educative. Good for refreshing courses. Thanks a lot
You are most welcome
Very much informative and useful
Wow I love your video my daughter is having trouble on excel she really does need a tutor may you help?
Whilst we don't offer tutoring, your welcome to check out our website as we do provide further excel learning: www.simonsezit.com/course-category/excel/
Delighted you're loving the tutorials Idalia, Keep watching!
Thanks for doing this. Really needed this.
Thanks for the kind comments, Chris! Here's some advanced PT training if you need it -> ua-cam.com/video/-CyKEJXrYTI/v-deo.html
A pretty long video, but it's well done and well explained. Thank you a lot!
Glad you found it useful Hengel!
Very informative tutorial. Well done, Keep it up.
A big thanks for such brilliant presentation. Can I have the store data by which I can practice by my own with the help of this video. Thanks
Too good! Simply superb!
We want dashboarding too!
Thanks Avishek! That's great to hear.
I am very pleased with the Teacher and the way she teaches us. Thank you very much for your valuable video, This is the best ever MS Excel Advanced level video I've seen.
Accept my wishes and glads. From Bangladesh 🇧🇩
Thank you! 😃 That's very nice of you to say. I'm glad that you enjoyed the excel crash course.
Fantastic. An hour very well spent. Thank you.
That's really good to hear.
Awesome webinar........Very detailed , thank you so much
Glad you liked it!
Thanks for the training i enjoyed it so much hope to have good trainings from your team
Thanks for watching Alieu!
Incredibly helpful! Hats off to the instructor. Thank you very much!!!
Francisco, I really appreciate the superb feedback. I'm happy to hear that this tutorial was helpful to you!
WOW, Thank you for an awesome lesson. You are really good! I can't wait to excel.
Glad it was helpful!
thank you so much,your reputation precedes you
Why thank you, you’re so kind!
Well great message but one question from my end . How should I get Analyse Tab and Design Tab?, when I am inside Pivot Table in Excel 2013.
It is such a brilliant tutorial! You really can learn from this young lady. Clear and logical. Well done!!!
Thanks JG, we're holding more of these sessions this year. Make sure you subscribe to the channel to find out more.
YOU'RE A GENIUS MA'AM
Great teaching! Not as complicated as I expected pivot tables to be. Thank you!
Top Notch. Very understandable
Thanks for watching, Modupe Ogundimu!
This video helped me a lot 👌🏼
Glad to hear it, Tony! 👍
This is a great crash course. Very easy to understand and follow. Explanation and demo are awesome👍👍
Thanks for the kind comments, Red X 😊
thanx a lot, i’ve learned a lot from you. that’s so brilliant
Thanks for taking the time to let us know that you've enjoyed the tutorial. Have a great week!
Excellent job guys. That was a masterpiece.
Thanks for the kind comments, Stanley.
Out of this world.
Thank you, your comment is much appreciated.
This is great. Well explained.
Glad you think so!
Love it! Im so excited to do my report.
Great to hear! All the best!