In this tutorial, I’ll guide you step-by-step on how to create and use pivot tables, one of Excel’s most powerful features for summarizing, analyzing, and presenting data. Whether you want to find out who generated the most revenue at the Kevin Cookie Company 🍪 or see sales breakdowns by region, this video has you covered.
We'll explore:
- Preparing data for pivot tables
- Inserting a pivot table from scratch
- Adding fields to rows, columns, and values
- Filtering data and creating custom calculations
- Sorting, grouping, and summarizing values (sum, average, count, etc.)
- Using charts and slicers for better visualizations
By the end of this video, you’ll be able to quickly analyze complex data, create interactive reports, and make data-driven decisions—all with just a few clicks!
Host: Kevin Stratvert
📚 RESOURCES
- Follow along by downloading the sample workbook here: https://1drv.ms/x/s!AmxrofZZlZ-whe0kwONipzSXQ2jXnQ?e=8Jt663
⌚ TIMESTAMPS
0:00 - Introduction
0:11 - Prepare Data for a Pivot Table
0:26 - Insert a Table (Optional)
0:49 - Insert a Pivot Table
1:33 - Explore Pivot Table Fields
1:52 - Analyze Sales Data with Pivot Tables
2:16 - Summarize Values (Sum, Max, Count)
3:17 - Sort and Organize Data
3:40 - Add Region Data to Pivot Table
5:01 - Use Filters to Analyze Specific Products
5:49 - Show Values As
6:35 - Change Column Headers
6:50 - Adjust Look and Feel of Pivot Table
7:08 - Create a Pivot Chart and Use Slicers
8:05 - Refresh Pivot Table
8:25 - Wrap Up
📺 RELATED VIDEOS
- Playlist with all my videos on Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official website: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/
🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 📺 Descript AI Video Editor | https://get.descript.com/sf22jb63w2tx
✅ 💵 QuickBooks Online: https://bit.ly/intuitquickbooksonline
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL
✅ 📹 CapCut Video Editor | https://bit.ly/installcapcut
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz
⚖ 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 #Excel #PivotTables #DataAnalysis