Pivot Table Excel | Step-by-Step Tutorial

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-whe0kw...

⌚ 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:    • ❎ How to use Excel  

📩 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:   / kevinstratvert  
Discord: https://bit.ly/KevinStratvertDiscord
Twitter:   / kevstrat  
Facebook:   / kevin-stratvert-101912218227818  
TikTok:   / kevinstratvert  
Instagram:   / 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?...

🙌 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