Skip to content
0
Excel - Pivot Tables

Excel - Pivot Tables

Level X
Cheltenham

Course Overview

Part Time
Certificate
Shortlist and Apply

Learn how to manage and analyse data like a pro with this hands-on workshop focused on Excel’s powerful data tools.

You’ll start with data list essentials, including sorting, filtering, and custom filters, before moving on to creating PivotTables to quickly summarise and generate reports from large datasets. The session covers everything you need to master PivotTables, creating, modifying, and formatting tables, using interactive slicers, grouping data, drilling down, and applying summary or custom calculations.

You’ll also explore advanced features such as the GETPIVOTDATA function and learn how to create and modify PivotChart reports for clear, visual insights.

Please note: A basic understanding of Excel is required to benefit from this workshop.

By the end of the course, you’ll have the confidence to transform raw data into meaningful reports and visualisations with ease.

  • This course is aimed at those who are aged 19 and over (as at 31st August of the academic year you are applying for) who are looking to improve their skills to move into work or progress into more sustainable employment.

    In some circumstances you may be able to access this course for free.

    For further information on fee waivers available or 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

Excel - Pivot Tables

What You Will Pay

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

£85

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

Hear my Story
Julie

"I completed a Microsoft Computer Skills course, and the learning was fun. It boosted my confidence, helped me feel less alone, and gave me skills I now share with friends."

Julie

Microsoft Office Skills

Hear my Story
Hear my Story
Steven

"I completed courses in effective telephone communication and Microsoft Office skills for work. They were easy to understand, rewarding, and very useful for my goal of finding an admin job. I would recommend them both."

Steven

Telephone Communication and Microsoft Office Skills

Hear my Story
Hear my Story
Louise

"I completed courses in Microsoft Office Skills and Excel. The tutor was brilliant, very patient and kind, and I even made a good friend. I cannot speak highly enough of it."

Louise

Microsoft Office Skills

Hear my Story