Pivot Table Tutorial - Learn PivotTables in 1 Hour - Excel Crash Course

Get Four FREE Courses from Simon Sez IT ►

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

Or, some of our other training on YouTube:

Stay in touch!

Subscribe to our channel:

If you enjoyed the video, please give a "thumbs up" and subscribe
to the channel ;-) #simonsezit

[revivejive]

Dang!! I can see why he introduced her as the best Excel trainer ever!! Excellent tutorial worth every minute..

[MyBilal]

I can continue to listen to her for countless hours. Her way of teaching is so nice.

[TamunoOpuboCooksCookeyGam]

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!

[ksenyat]

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!

[philiplbrown]

Another fantastic tutorial. In order to improve my Excel skills Simon Sez IT is a one-stop-shop for me.

[shainavirjee]

She is an excellent tutor! Explains in a very simple way and breaks it down for any level user. Thank you so much.

[amalia]

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.

[joysoriano]

ABSOLUTELY please share more about PivotTables topics. This video is wonderfully INFORMATIVE!

[mariai.ruiz-galindo]

I'm from Mexico City and I'm very interest ed in Pivot Tables. Thank you!

[ktcarter]

Omg the first 20 mins of this video has already made my life easier. Thank you for this!!! <3

[HAAG]

Excellent content by an amazing presenter. Thank you for sharing your knowledge with the many of us.

[summerbliss]

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!

[Les-ryhi]

OMG - This is one of the best tutorial ever on Pivot tables. I am lucky to have stumbled on this one.

[millennialmindset]

Great intrormation about the channel in the intro! The tutorial starts at 6:40

[debbiefrosco]

Very good! First Time Pivot Table Creator! I learned!! I learned!

[Musicsoundsbetterwithyou]

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.

[azzurikayvo]

It was worth every second!! Wish had landed on this Gold mine long time ago. THANKS.

[jamesdep]

Deb is by the far the best. She is incredible.

[ibejimi]

Please more webinars on advanced pivot tables and charts and dashboards especially in using them for analytics. Really clear teaching. Kudos!

[missisfreddiemercury]

lovely, makes me feel less depressed about a task I have to do