• Business

    Microsoft Excel Pivot Tables

  • Attendance/Duration

    Delivery Method: Face to Face delivery

    Course Duration: 6 hours (1 day)

    Delivery Method: Online Delivery

    Course Duration: 4 hours total. 2 x 2 hours live interactive tutorial sessions

  • Cost

    For further information on course dates and prices please email businessgrowth@ayrshire.ac.uk

Whats 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.

Funding and Fees

For further information please email businessgrowth@ayrshire.ac.uk

Enquiries

For further information please email businessgrowth@ayrshire.ac.uk

Course Search

Or

Browse all courses Advanced search