Microsoft Excel Analyse data using PivotTables

Analyse data using PivotTables

90 Mins

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.

Required knowledge or experience:

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.


Courses are delivered in 2007, 2010, 2013, 2016.

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
Related courses
Run this
course at
your offices
Request a quote
which course
Which level do you need?
Take our online skills assessment
Find out more
Speak to a friendly advisor


0333 344 6630

or visit our

Online Chat