Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel: PivotTables for Beginners

via LinkedIn Learning

Write review

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
Learn PivotTables from scratch with Excel expert Deb Ashby—covering setup, slicers, formatting, date grouping, data refresh, and AI-powered PivotTables with Microsoft 365 Copilot.

Syllabus

Introduction
  • Getting started with Excel PivotTables
1. Basic PivotTable Concepts
  • PivotTables: Key concepts and benefits
  • Prepare your data for analysis using Power Query
  • Prepare your data for analysis using Copilot
  • Challenge: Clean and structure a raw dataset
  • Solution: Clean and structure a raw dataset
2. Building a Basic PivotTable
  • Create a PivotTable and pivot the fields
  • PivotTable aggregation: Sum, Count, Average, and more
  • Format PivotTable values: Currency, percentage, and more
  • Customize the PivotTable report layout
  • Add slicers to filter PivotTable data
  • Group dates in a PivotTable (days, months, quarters, years)
  • Refresh a PivotTable after data changes
  • Use Copilot to generate and analyze PivotTables
  • Challenge: Build a sales summary PivotTable
  • Solution: Build a sales summary PivotTable
Conclusion
  • PivotTables: Next steps and further learning

Taught by

Dave Ludwig

Reviews

4.8 rating at LinkedIn Learning based on 340 ratings

Start your review of Excel: PivotTables for Beginners

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.