PivotTables are one of the most useful tools in Excel. They allow you to easily summarise, examine and present a complex list of data.
This blog post explores 5 advanced PivotTable techniques.
- Grouping fields by month and year
- Calculating data as a percentage of the total
- Using Slicers
- Applying Conditional Formatting to PivotTable data
- Creating calculated fields