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

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

Excel - Pivot Tables

What You Will Pay

Please select a course to see pricing information.

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