Excel – Pivot Table Specialist

Duration: 1 days

Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information.

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.

By the end of the course you will be able to:

  • Build and customise Pivot Tables
  • Group and sort information
  • Filter information
  • Use slicers and the timeline filter
  • Add different summary calculations
  • Create Pivot Charts
  • Add calculated fields and items
  • 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
  • Drilling down to underlying data
  • Format options
  • Totals and filters options
  • Display and printing options
  • Data options
  • Modifying field names
  • Data formatting
  • Changing field layout options
  • Changing summary calculations
  • Working with subtotals
  • Filtering items
  • Sorting data
  • Value and label filters
  • Creating top 10 reports
  • Using the Search filter
  • Using the Slicer tool
  • Use the Timeline filter
  • Grouping date fields
  • Grouping numeric fields
  • Adding your own groups
  • Running totals
  • Differences year on year, month on month
  • % Differences year on year, month on month
  • % of Row, Column, Total and other fields
  • Pivot Chart rules
  • Creating a Pivot Chart
  • Working with your Pivot Chart
  • Adding calculated fields
  • Adding calculated items

Excellent course and trainer. Yes I would recommend to others, course was very useful. Susan was very friendly and made sure we had regularl breaks. Course was interesting and useful.

Willis Towers Watson logoCoyee, Willis Towers Watson

Back to all courses
we can tailor our standard courses to your needs