18 April 2015
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.
Full article: 5 advanced PivotTable techniques
