Pivot Table Excel Tutorial

In this tutorial, I use Excel that comes with Office 365; however, this should also work with all previous versions of Excel, like Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, and Excel 2003.

📚 RESOURCES

⌚ TIMESTAMPS
00:00 Introduction
02:19 Insert Pivot Table
03:22 Main Pivot Table view
05:24 Calculated fields
06:55 Sorting
07:12 Value field settings
08:10 Show values as
09:27 Insert Pivot Chart
10:23 Defer layout update
11:13 Pivot Table on the web
12:24 Wrap up

📺 RELATED VIDEOS

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!

🔽 CONNECT WITH ME

🎁 TOOLS AND DISCOUNTS

🎒 MY COURSES

🙏 REQUEST VIDEOS

🔔 SUBSCRIBE ON YOUTUBE

⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert

[happyworldland]

when you tell the job that you know how to do pivot tables and actually make it to the third round of interviews and there is an excel assessment and you dont know jack sh*t about pivot tables so you run over to youtube. thanks kevin, you helped a lot! lol

[donjoe]

You’re probably quite aware...but you’ve helped kickstart A LOT of careers 😭

[WillDixonMusic]

I literally just got a job this week because of this video. Keep saving lives Kevin.

[Arbitraritorian]

Best pivot table intro I've seen. Covers more in 10 minutes, more clearly, than some courses do in 4 hours.

[dioniesueiti-toka]

I cried a little, thank you for helping me to understand it's not magic. People are often impatient during work. They show once, and quickly, and expect us to get it. You are a gift to many.

[curtisholsinger]

You are a born video instructor. Your voice is engaging, your speed with the mouse is not too fast and not too slow, and your progression made sure I did not get lost. I am absolutely coming back to watch this again when I need another refresher. Subscribed!

[daniel.s]

thank you. just landed a job that requires a lot excel analysis, luckily my boss gave me 1 week to get it on hand. this tutorial helped a lot.

[jordansmithson]

Prepping for a job interview, and this made me feel a lot more confident about my changes of getting the job. Thanks!

[axion]

Extremely helpful. I've watched so many Excel videos and what they almost always lack is a cogent, real-world framework for why you would want to do this. Your context-driven approach adds a great deal of value. Many thanks and subbed.

[jasmineleeann]

Have an interview Wednesday that requires knowing about pivot tables! You actually made learning this exciting! Thank you ☺️🙌🏽

[dhivyadiwakar]

For years i have thought pivot tables are a complex functionality. My perception has been quickly turned around with this video. That was a nice ice breaking session for me!

[erindeblois]

By far the simplest and easiest to follow of all Excel tutorials I have looked at (and there have been a LOT!). Thanks so much! I have now subscribed, and you're now my first go-to when I need a refresher, or a crash course on Excel!

[larrymagruder]

Well done, Kevin! You covered a lot in 13 minutes. Quick, concise, and eye-opening for countless uses and options for analyzing data. Yes, you moved fast, but that easily should be the preference for all of us since we can pause, replay, and replay again to gradually gain understanding on a topic we didn’t quite grasp the first time - or not repeat something at all if we were already comfortable with our understanding, It’s the power of a video. Again, well done, Kevin!

[thepineappleburster]

Thanks for making this. Missed all my classes this year and you explaining how it works is ten times better than any other person.

[diandracoleman]

Thanks, Kevin! Great refresher and thanks for giving us access to the data--I'm a hands-on learner so that helps tremendously

[antriggs]

So concise and easy to follow. I didn’t even know what these were until an hour ago when my engineering lead asked me to organize my data into a pivot table. Thanks!

[tammihayward]

Thank you Kevin!! I am starting a new job and have never used pivot, macros, vlookup etc.. Having watched your video's over the past few days I feel so much more confident. You explain it simply and easily. THANK YOU x

[rudygutierrez]

I believe that everyone should learn this. You are amazing! Thanks you

[qfrvvct]

I created a fake data set after watching this video and then rewatched and did everything like you did. This was incredibly helpful. Definitely going to help me in the job I just landed!

[alexyershov]

I really like his style - fast paced and to the point, no lengthy preamble. Expertly explained.