🧙♂️ Pivot Table Excel Tips & Tricks
402,469
Published 2021-04-21
In this step-by-step tutorial, learn the top 14 best pivot table tips and tricks in Microsoft Excel. For example, use natural language to create pivot tables, get automatic insights on your data using ML, use multiple tables as sources, add calculated fields, quickly filter data with slicers & timelines, build dashboards, and many more. These are sure to take your analysis skills with pivottables to the next level. And most importantly, you'll be able to answer business questions even faster.
👋 Additional resources
- Sample data to follow along: 1drv.ms/x/s!AmxrofZZlZ-whLkz3v27FyEe1w4O_A?e=GiHJa…
- How to use Pivot Tables Tutorial for Beginners: • Pivot Table Excel Tutorial
- How to use Power Pivot in Excel: • How to use Power Pivot in Excel | Ful...
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com/
⌚ Timestamps
0:00 Introduction
0:34 Natural language pivot table
2:37 Click values for details
3:18 Pivot table with multiple sheets
5:39 Field layout & sorting options
6:28 Calculated fields
7:30 Sort values
7:57 Show value as
9:14 Summarize values
10:16 Slicer
11:37 Timeline
12:25 Pivot charts
13:08 Pivot table layouts
14:46 Grouping
15:16 Customize row labels
16:44 Wrap up
📃 Watch related playlists and videos
- Playlist with all my videos on Excel: • ❎ How to use Excel
🚩 Connect with me on social
- LinkedIn: www.linkedin.com/in/kevinstratvert/
- Discord: discord.gg/kHuujY2pZf
- Twitter: twitter.com/kevstrat
- Facebook: www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: www.tiktok.com/@kevinstratvert
- Instagram: www.instagram.com/kevinstratvert/
🔔 Subscribe to my YouTube channel
youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
www.kevinstratvert.com/
🛍 Support me with your Amazon purchases: amzn.to/3kCP2yz
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
#stratvert
All Comments (21)
-
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com/ ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzc…
-
You're ridiculously good at everything you do. I can't thank you enough for the value you add to the viewing community. Thanks a million Kevin!
-
Pivot tables have been such a game changer to analyze data with ease. Thanks for sharing these helpful tips :)
-
That is a great video Kevin! I've been using pivots for over a decade and learned a lot, thank you :)
-
I really enjoyed this tutorial. Love that section where you c overed how to customize a raw lable. The smile on your face brightens many peoples' days including me. Thanks for the tutorial.
-
this video is a game changer for me to upgrade myself from beginner to advanced on pivot tables. In just 16 minutes of video, you easily explained so many useful tools like slicer, timeline, pivot chart, sorting, grouping etc. Thanks dude. Gave thumbs up to the video
-
Setting up default pivot table layouts. Kevin you are my hero!
-
I have been using Pivot tables for years, and through this video, I have learned a few more things. Thank you!
-
Amazing! This is like Power Bi reports on budget! I know its an exaggeration but most needs are fulfilled by pivots. Thanks Kevin. I have learnt a lot about Microsoft products from you than anyone else. That too in short time.
-
Thank you for this! I often forget how to build a pivot table and now I can save this video for next time.
-
Kevin, your videos are the best out there! Thank you so much for your insights and expertise! One request is using pivot tables to analyze survey data. I know the general principles are the same, but I'd be interested in seeing how you organize and group survey data to get the most intuitive reports and visualizations. Again, thank you!
-
Awesome tips for Pivot Tables. Adding a calculated column is going to change my game! THANKS😊
-
I didn't know the existence of slicer till now. OMG, you are a lifesaver and a timesaver!
-
This video couldn’t have come at a better time. Thanks great instructional video 👍
-
Thanks Kevin. Another superbly informative video. I’ve always loved playing with pivot tables to analyse data but I didn’t know you could do half of this. Just sent the video to my work email to watch again tomorrow when I am at work. Have found loads of your videos useful over lockdown and this is another one I will add to my favourites.
-
Wasn't aware of the Analyse Data option first, and the dufferent data views it gives in addition to PT's. Thanks so much for this 👍
-
Thank you so much, Kevin. I consider myself a pivot table expert, but I still manage to learn something new from you! Your videos have been a great learning resource for me.
-
Hi Kevin, I am so glad I discovered your videos. I started watching yesterday and back today, already learnt so much. Thank you.
-
Kevin, Thanks again. I find these Excel Pivots & PowerBi videos so useful. I learn something new. Keep these coming!!
-
Wow, amazing video. I've used Pivot tables for years and I'm blown away. Thank you
