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
Kevin Stratvert 