New: Gemini July — Free Gemini training for your whole team in July →
Skip to content
Live LearningCo
For IT Teams
Drive adoption & reduce tickets
For Learning Teams
Scale training without headcount
Policy to Practice
Turn AI policies into capabilities
Technology Migration
Dedicated rollout support
Gemini July
Free Gemini training — July 2026
Microsoft Month
Free Microsoft training — May 2026
LMS Integration
Courses
Live Learning
ScheduleTrainers
Learning for Good
Free training for VCSE organisations
BlogCase Studies
PricingAbout
Free TrialBook a Demo
Live LearningCo

Live expert training for enterprise teams. Close the gap between software investment and real adoption.

Solutions
  • For IT Teams
  • For L&D Teams
  • Policy to Practice
  • Technology Migration
  • LMS Integrations
  • For Enterprise
  • Pricing
Courses
  • Microsoft 365
  • Google Workspace
  • AI & Copilot
  • View All
Company
  • About
  • Careers
  • Case Studies
  • Blog
  • Contact
  • Learning for Good
© 2026 Live LearningCo. All rights reserved.
Privacy PolicyTermsCookies
HomeCoursesMicrosoft ExcelUsing Pivot Tables in Excel
Microsoft Excel

Using Pivot Tables in Excel

1 hour
Live
All levels
Next: TBA
Book a SessionRequest Team Booking

About this course

Using Pivot Tables in Excel

Spot patterns, answer questions, and explore your data using Pivot Tables

Duration 60 minutes
Level Intermediate
Completion Certificate + Badge

Course Overview

This session introduces Pivot Tables as one of Excel’s most powerful tools for analysing and summarising data. It is designed for users who want to move beyond raw spreadsheets and start answering real questions with their data.

You will learn how to build Pivot Tables from clean data, understand how rows, columns, values, and filters work together, and explore tools such as sorting, grouping, slicers, and calculated fields.

By the end of the session, you’ll be able to use Pivot Tables confidently to identify trends, compare results, and explore datasets far more efficiently than with formulas alone.

Skills Gained

Creating Pivot Tables Interpreting Data Sorting & Filtering Results Grouping & Summarising Data Pivot Table Formatting Calculated Fields

What You'll Learn

• What Pivot Tables Are – Understand when and why Pivot Tables are the right tool.
• Creating Pivot Tables – Build Pivot Tables from structured Excel tables.
• Customising Layouts – Rearrange rows, columns, and values to answer questions.
• Grouping & Filtering – Use grouping, slicers, and filters to explore trends.
• Calculated Fields – Create new values directly inside a Pivot Table.

Who Is This For?

This course is perfect for:

✓ Users with basic Excel knowledge
✓ Anyone analysing structured datasets
✓ Learners progressing through the Excel series

Prerequisites

Microsoft 365 account. Completion of a beginner and intermediate Excel session is recommended.

Upon Completion

Digital Badge

Shareable credential for LinkedIn and professional profiles

Certificate of Completion

Official certificate to showcase your achievement

You might also like

Browse all courses
Making the most of Functions and Formulas in Excel

Making the most of Functions and Formulas in Excel

1 hourLive
Gaining Steam in Excel: An Intermediate Guide

Gaining Steam in Excel: An Intermediate Guide

1 hourLive

Upcoming live sessions

No upcoming sessions scheduled yet. Get in touch to arrange a session for your team.

Request a Session

Frequently asked questions

Next Session
TBA
Book a SessionRequest team booking
Live interactive session
Expert certified trainer
Certificate of completion

Need help?

Not sure if this course is right for your team? Our learning specialists can help.

Chat with an expert
Getting Started with Excel

Getting Started with Excel

1 hourLive