5 advanced PivotTable techniques

5 advanced PivotTable techniques

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.