Skip to content

For the latest Covid update, guidance and funding news, please click here.

Excel - Pivot Tables

  • Students

    This workshop covers data list essentials, sorting, filtering & custom filters. You will learn how to create Pivot Tables to quickly summarise and create smaller reports from large amounts of data. It will include creating, modifying & formatting a Pivot Table, interactive slicers, grouping, drilling down, summary/custom calculation, using the GETPIVOTDATA Function and creating and modifying Pivot Chart Reports.

Shortlist and Apply

Course Variant


Choose a Start Date

Shortlist and Apply

Please select the specific course you would like to apply for.

What You Will Pay

Please select a course to see pricing information.


Why Gloucestershire College?

We have a lot of experience offering Apprenticeships and work-related training. We have industry-standard facilities and experienced teaching staff which provide the ideal complement to work-based learning.

We are here to help

0345 155 2020

90% of students would recommend GC and 95% said that the teaching on their course was good.

Ofsted has rated us good.

  • We offer industry relevant facilities
  • Our lecturers are passionate subject specialists
  • Employers value our students' skills

We'll look after you. We have dedicated teams to help you and a great Learning Mentor scheme.