Introduction to Excel Pivot Tables

About this course

A comprehensive introduction to excel pivot tables for newcomers.

• 5 lessons
• 30 min
• beginner

What you'll learn

• Define a pivot table and explain how it aggregates groups of values from a larger dataset
• Describe the historical origins and evolution of pivot tables
• Recognize common professional use cases for pivot tables
• Explain why source data must be in a tabular format before creating a pivot table
• Identify and fix common data preparation issues that cause pivot table problems
• Decide whether to convert your data range into an official Excel table before inserting a pivot table

Finishing the course

• 20 knowledge-check questions along the way, so you know the ideas stuck before you move on.
• Watching is free and needs no account. Sign in to save your progress. Pass each lesson's quiz (60%+) to earn the certificate. Each certificate has its own public verification link to share, marked quiz-verified.

Created by