Pivot Table Basics Videos

These Excel training videos show how to get started with pivot tables - a powerful tool for analyzing data in Excel. Summarize thousands of rows of data with a few clicks, and no formulas required!

Create an Excel Pivot Table

Watch this video, to see the steps for creating a pivot table in Excel 2013 and later, using a dynamic pivot table data source.

There are written steps, and a sample file to download, on the Pivot Table Dynamic Source page.

Quickly Count Duplicates with Pivot Table

This video shows a quick way to count the number of times each month name appears in the list - by making a simple pivot table

There are written steps, and a sample Excel workbook, on the Count Duplicates with a Pivot Table page.