• Business

    Microsoft Excel Pivot Tables

  • Attendance

    Face to face or online delivery

  • Duration

    Face to Face: 6 hours (1 day)

    Online: 4 hours total (2 x 2 hours live interactive tutorial sessions)

What's Involved

A PivotTable is a powerful tool to calculate, summarise, and analyse data that lets you see comparisons, patterns, and trends in your data.

This course is suitable for those with a basic knowledge of pivot tables who want to be able to summarise and display useful and relevant information to enhance decision making.

This course will cover the following:

  • Creating more advanced pivot tables
  • Using slicers and timelines
  • Grouping items in pivot tables
  • Changing measurement units
  • Copying pivot tables
  • Using calculated fields and items with pivot tables
  • Consolidating ranges using pivot tables
  • Creating pivot table relationships
  • Refreshing pivot tables

By the end of this course participants will learn how to summarise, group and display large amounts of data to communicate relevant information.

Book

Click here to see if this course is currently scheduled, or contact us to register interest.

Course Search

Or

Browse all courses Advanced search
arrow icon arrow icon