Pivot Table Learning ResourcesSeven FREE video tutorials to help you learn about one of Excel's most popular features!
Getting Started with Pivot Tables in Excel 2016 for Windows
This short video gets you started with Pivot Tables. It uses Excel 2016 for Windows but users of earlier versions of Excel will find it beneficial too
Create a Pivot Table From Multiple Tables
Have you ever noticed the “Add this data to the Data Model” checkbox when creating a Pivot Table? This video shows you how, by ticking the box, you can create a Pivot Table from data that is stored in multiple Tables.
Excel 2013 - Pivot Charts
In previous versions of Excel if you wanted a Pivot Chart, you would need to create the Pivot Table first. Not in Excel 2013. Watch this short video to find out how.
Calculate Differences in a Pivot Table
In this video you’ll learn how to calculate the difference between values in a Pivot Table. For example, you have a list of sales figures and a Pivot Table that summarises by month. What was the difference between January and February, February and March, etc?
Excel 2016 for Windows - Pivot Tables - Group By Month
In the recently released Excel 2016 for Windows, there’s a new way to group data by month in a Pivot Table. This video shows you how to do it.
Grouping Dates in a Pivot Table By Week
In this short video I explain how to group a list of dates in a Pivot Table so that they display in blocks of 7 days.
Stop Pivot Table Grouping Affecting Another Pivot Table
If two or more of the Pivot Tables share the same source data, when it comes to grouping, chances are you’ll hit an issue. this video shows how to resolve it.