Skip to Content

Bookings and Enquiries: 0800 077 36 46

Microsoft Excel – Pivot Table Specialist Course

Microsoft Excel – Pivot Table Specialist Course

1 Day Crawley £220.00+VAT
Available Date(s):
Print

Is this course right for me?

Our Excel Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who are keen to learn more about the use of Pivot Tables to analyse and present data.

This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas.

Training course objectives:

  • Build and customise Pivot Tables
  • Group and sort information within Pivot Tables
  • Add different types of summary calculations to Pivot Tables
  • Create Pivot Charts
  • Add calculated fields and items

Versions Available

2003, 2007, 2010, 2013

Related Training Courses in Our Range

The anatomy of a Pivot Table

  • Using a Pivot Cache
  • Building a Pivot Table
  • The Pivot Table interface
  • Refreshing the Pivot Table
  • Adding column, row, page and data fields
  • Changing data orientation
  • Showing data fields in columns or rows
  • Using the Slicer tool (2010)

Setting Pivot Table options

  • Format options
  • Totals and filters options (2007 and 2010)
  • Display and printing options (2007 and 2010)
  • Data options

Customising Pivot Tables

  • Modifying field names
  • Data formatting
  • Changing field layout options
  • Changing summary calculations
  • Working with subtotals

Filtering and sorting

  • Filtering items
  • Sorting data
  • Value and label filters (2007 and 2010)
  • Creating top 10 reports
  • Using Search within a Pivot Table (2010)

Grouping

  • Grouping date fields
  • Grouping numeric fields
  • Adding your own groups

Summary calculations

  • Running totals
  • Differences year on year, month on month
  • % Differences year on year, month on month
  • % of Row, Column, Total and other fields

Pivot Charts

  • Pivot Chart rules
  • Creating a Pivot Chart
  • Working with your Pivot Chart

Creating calculations

  • Adding calculated fields
  • Adding calculated items
Contact

Call our expert Learning and Development team today on
0800 077 36 46 for more details about the training options available to
you or to book your course.