Pivot Table Tutorial - Learn PivotTables in 1 Hour - Excel Crash Course
Vložit
- čas přidán 23. 01. 2019
- Get Four FREE Courses from Simon Sez IT ►
www.simonsezit.com/four-free-...
To follow along with this how to use pivot tables class, you can download the Excel file here ► www.simonsezit.com/article/le...
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.com/
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 CZcams:
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.com/
StreamSkill.com: StreamSkill.com/
CZcams Channel: / simonsezittraining
Subscribe to our channel:
czcams.com/users/simonsezittra...
If you enjoyed the video, please give a "thumbs up" and subscribe
to the channel ;-) #simonsezit - Věda a technologie
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.
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.
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
I can continue to listen to her for countless hours. Her way of teaching is so nice.
Thank you Muhammad!
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 czcams.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.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 czcams.com/video/oN82Umc9MCQ/video.html
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!
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!
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!
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😀
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 -> czcams.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
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.
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.
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! 👍
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!
Great teaching! Not as complicated as I expected pivot tables to be. Thank you!
lovely, makes me feel less depressed about a task I have to do
Great webinar - clear and concise. Appreciate Deb's approach. Thanks again!
Glad you enjoyed it!
Thank you so much for the clear presentation, I will be looking through the various offerings.
You are welcome Celine, do join us!
ABSOLUTELY please share more about PivotTables topics. This video is wonderfully INFORMATIVE!
You got it!
Thanks for taking the time to post this, definitely going to help in my new job!
Great intrormation about the channel in the intro! The tutorial starts at 6:40
Delighted to hear that you’ve enjoyed the tutorial!
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!
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!
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
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 :-)
Very good! First Time Pivot Table Creator! I learned!! I learned!
Thank you very much for the great video! I've found it to be pretty informative even if knowing the very basics.
I'm glad you found it to be helpful!
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!
Omg the first 20 mins of this video has already made my life 99999999x easier. Thank you for this!!!
Glad it helped!
Excellent Webinar !!! I am glad that I chose yours... looking forward for more to attend
Welcome aboard! Delighted to hear that Nanda!
A pretty long video, but it's well done and well explained. Thank you a lot!
Glad you found it useful Hengel!
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!
It was worth every second!! Wish had landed on this Gold mine long time ago. THANKS.
Glad it was still helpful!
Thank you so much! You have such a good way of simplifying things to make sure that everything makes sense.
Glad you think so!
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 ⏩ czcams.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html and additional free Excel training 👉 czcams.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
and here 👉 czcams.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
@@SimonSezIT Thank you! I plan to watch them all!!!
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 👉czcams.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Really enjoyed this video. Very clear, interesting and useful. Thanks
This is very helpful, I have learned a lot of useful information that will enable analytics I just wasn't able to make before. Thank you so much!
Great to hear!
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!
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 :-)
Excellent demystifying of Pivot Tables - look forward to more.
thanks for the great comment !
WOW, Thank you for an awesome lesson. You are really good! I can't wait to excel.
Glad it was helpful!
Amazing webinar and so great lesson I'm so grateful to you
I'm really pleased to hear you enjoyed it Abdullah!
Absolutely the best instructions on Excel pivot table - thank you!
Glad you like it!
Nice and informative session. Looking forward for more. Thank you!
Thanks, Glad you think so!
Deb is by the far the best. She is incredible.
Glad you think so!
This was a great video tutorial. Will have to watch it again. Would love to see one on charts and graphs. Still using Excel 2013.
Great suggestion! Thanks for the positive feedback!
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 👉 czcams.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Thanks for sharing this. Super helpful!
Thanks for leading into this tutorial by reviewing data cleanup, great job!
It's the most important bit. Like building a house on good foundations :-)
It really starts at 7:55. Great course btw!
Really Enjoyed This Fantastic Tutorial Thank You Deb :):)
Glad you found it useful Darryl
Very well presented, please do a webinar on dashboards!
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!
Basics of Pivot stated in lucid manner ..learnt the slicer part from the tutorial,
Hey Adam, I am wondering if where can I get that practice data on the video you just shared. If you could please kindly share so I could practice it. I enjoyed watching your Excel Crash Course. Thank you so much.
A day can't go without making reference to Debbie's You Tube channel. Her presentation skills are top notch
thank you for sharing!
I'm in PA. Thank you for sharing all that knowledge.
Our pleasure! Thanks for watching!
This is a great crash course. Very easy to understand and follow. Explanation and demo are awesome👍👍
Thanks for the kind comments, Red X 😊
This course was amazing! Thank you!
Glad you liked it!
thank you so much,your reputation precedes you
Why thank you, you’re so kind!
Excellent tutorial! Have started learning excel skills watching your videos. Thank you.
Great to hear!
Fantastic. An hour very well spent. Thank you.
That's really good to hear.
Thank you for the information. Awesome teacher and very well spoken..👍
Our pleasure!
Thanks for the training i enjoyed it so much hope to have good trainings from your team
Thanks for watching Alieu!
Thank you for the informative tutorial.
Glad you found it useful. Do subscribe for more!
Excellent! The whole course
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
Very nice and educative. Good for refreshing courses. Thanks a lot
You are most welcome
Thank you so much Deb, you helped me a lot. Hugs. Sincerely
Thanks Danilo! Hugs to you too!
Excellent experience... learn a lot... Thank u very much
It's my pleasure
Excellent work. Thank you for simplifying Pivot Table & Charts for me.
Glad it was helpful!
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 ➡️
czcams.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
I really enjoyed this webinar. good job, thanks.
We enjoyed hosting it! We'll do more in the future so do subscribe to see others.
Love it! Im so excited to do my report.
Great to hear! All the best!
So much helpful. God Bless You.
Excellent presentation. I have learned a lot. thank you
Glad it was helpful!
It was great the way that you explained the content! I will check all your videos!
Awesome, thank you!
Very informative tutorial. Well done, Keep it up.
OMG,this was so helpful. Great webinar!
Glad it was helpful!
Well presented session. Easy to follow thru. Great work guys
Much appreciated!
Exceptional! Thank you!
Wonderful informational video. Thank you.
No problem Oku, glad you enjoyed it
Too good! Simply superb!
We want dashboarding too!
Thanks Avishek! That's great to hear.
Love this!!! Very thorough
Glad you found it useful!
Such an awesome tutor...thank you.
Thank you! Check out the rest of our videos.
I love the work you do. Keep up the good work!
That is great to hear 😊
Thank you, very useful video for the beginner like me
You are welcome
The video was amazing. Thanks for sharing your knowledge. Thank u so much..
You are welcome. Thanks for watching!
YOU'RE A GENIUS MA'AM
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 😃
Excellent job guys. That was a masterpiece.
Thanks for the kind comments, Stanley.
Thanks for doing this. Really needed this.
Thanks for the kind comments, Chris! Here's some advanced PT training if you need it -> czcams.com/video/-CyKEJXrYTI/video.html
I am an Excel trainer too and this was excellent. Your delivery skills are top notch
So nice of you!
That was very very good! Gratitude!
You're so welcome!
So helpful, You are a wonderful Teacher.
Thank you! 😃
I can't thank you enough for all your videos! You are really a great teacher, I learnt a lot and I'm so motivated to continue learning!
You're very welcome! If you need additional training, there are additional tutorials for Pivot Tables here -> czcams.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Thank you for this information, you made it look super easy.
Glad it was helpful!