Macro to Repeat Item Labels in Excel Pivot and Flatten
I often use pivot tables to summarise one data source so that I can use that pivot table output as the basis for further analysis.
Filter Pivot Table Based on Results of Another Pivot
This post demonstrates how to use VBA to alter the filters on a pivot table based on the values in another pivot table or list.
How to Create a Pivot Table with Expanding Data Ranges
This Excel tutorial shows you how to create pivot tables based on a dynamic named range that will expand as you add additional rows of data. This can be a huge time saver and helps to protect against inadvertent errors...
The Best Way to Prepare Excel Pivot Table Source Data
This tutorial recommends some best practice for the preparation of source data that you intend to summarise by using Microsoft Excel Pivot Tables.
How to change multiple pivot table fields to Sum Function
The Pivot table is an incredibly powerful tool for summarising data. Excel will either default to summing or counting the field data but you can choose from 11 different functions that include min, max and StdDev as well as the...