Pivot tables
Introduction
Prepare source data
Create a pivot table
Configure a pivot table
Report filter
Column Labels
Row Labels
Values
Pivot table features
Summarize & analyze
Count
Max
Unique distinct list
Unique distinct records
Count unique distinct
Sort data
Group data
Multiple levels
See data behind
Grand totals
Insert pivot chart
Slicers
Refresh a pivot table
No link to source data
Customize the layout
Consolidate data
Articles in category
How to use Pivot Tables – Excel’s most powerful feature and also least known
Pivot Table calendar
Sum stock portfolio
Time sheet by project
Analyze trends
Split values
Disable auto col width
Normalize data [VBA]
Auto populate a worksheet
Drop-down - source
Follow hyperlinks
Auto refresh
Count uniq. dist. [2010]
Dynamic pivot
Based on condition (2)
Formula categories
Search website