The PivotTable feature is one of the most sophisticated components in Excel and can be described as a dynamic summary report generated from a database. The reason for using the PivotTable feature is to manipulate data, large or small in size and transform it into a meaningful presentation of data.


This session is designed for users who are very confident creating range of data or Table data, Sorting and Filtering data, and using Functions such as, SUM, AVERAGE, MIN, MAX, and COUNT.

What will I learn?

Learn how to:

  • Setup a database table
  • Create a PivotTable
  • Layout data
  • Add and remove data fields
  • Generate a Table based on PivotTable data
  • Format PivotTable
  • Summarise values
  • Refresh data/change data source
  • Filter with Slicers
  • Create & modify PivotCharts

Stay up to date

Subscribe to our mailing lists:

I would like to receive the following emails:
Mailing lists

We are collecting your email address to send you the emails you select above and we require your consent. By clicking the Subscribe button, we are treating this as your consent. To withdraw your consent, please use the unsubscribe option at the bottom of the received email(s)