Excel Pivot Table

This course focuses on developing skills and knowledge to manipulate large datasets. Using techniques including sort, filter, group and outline and subtotals, you will learn how to quickly summarise large data lists and find important information. You will also learn how to create Pivot Tables and Pivot Charts in Excel to effectively analyse and visualize data and make informed decisions.


Duration: 1 day

Version: 2010, 2013, 2016

Target Audience: Experienced users of Excel who work with large data lists and databases.

Prerequisites: Successful completion of a MCI Solutions Access Intermediate course or equivalent.

Learning outcomes

At the end of this program you will be able to:

  • Use tools for sorting and filtering data lists
  • Use subtotals
  • Group data lists and create outlines for quick summary views
  • Create and modify Pivot Tables from large data lists and databases
  • Create and modify Pivot Charts to visualize large data lists and databases

Upcoming Sessions

There are currently no openings available for this course.
Please enquire using the button below.