Skip to site navigation

Pivot Tables in Excel 2010

Description:

Pivot Tables allow you to organise and summarise large amounts of data by filtering and rotating headings around your data. This course also shows you how to create Pivot Charts.

Note that this course can be attended by people using Excel 2007.  There are some differences between the two versions but most features are the same.

Pre-requisites:

Participants should have a good understanding of techniques used to manage large worksheets such as filtering and sorting.

Outline:

  • examples of Pivot Table
  • creating a Pivot Table
  • rearranging data in a Pivot Table
  • summarising data in different ways
  • formatting data
  • changing display options
  • grouping data
  • sorting and filtering data
  • creating Pivot Charts

Delivery:  trainer-led session

This is a trainer-led 2 hour session.

To see when the next session is running, please check our training calendars:

Resources: