We have launched a new website and applicants will need to reset their password before accessing their account.  Reset your password.

Skip to content
0

Excel - Pivot Tables

Level X
Cheltenham

Course Overview

Part Time
Certificate

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.

You will need a basic understanding of Excel in order to benefit from this workshop.

  • This workshop will be free of charge for learners aged 19 and over (as at 31st August of the academic year) in receipt of certain benefits or employed learners earning less than £20,319.00 annual gross salary.

    For further information and to secure a place please contact our Jobsmart team on 01452 563278 or email jobsmart@gloscol.ac.uk

  • Your trainer will be able to advise of further training opportunities.

Shortlist and Apply

To register your interest, please call Student Services on 0345 1 55 2020

What You Will Pay

Our departments are the training ground for generations of artists, writers, police officers, athletes and other amazing people!

British and European Union students

Age: 16-18

You will pay

£0

for your course

Your course could be free of charge as you may be eligible for financial support to help pay your tuition fees, travel, exams, materials or childcare.

When you enrol you’ll need to pay any course fees for the first year, which you can do by direct debit, cash, debit card or credit card.

Please contact us for more information.

0345 155 2020

British and European Union students

Age: 19+

You will pay

£65

for your course

Your course could be free of charge as you may be eligible for financial support to help pay your tuition fees, travel, exams, materials or childcare.

When you enrol you’ll need to pay any course fees for the first year, which you can do by direct debit, cash, debit card or credit card.

Please contact us for more information.

0345 155 2020

To register your interest, please call Student Services on 0345 1 55 2020

Overseas students

Please contact us to discuss your fees for this course

0345 155 2020