Week 7 · 45-60 min
Introduction to Pivot Tables
Week Summary
A quick preview of the main ideas in this week before you begin the slides.
- What Is a Pivot Table?
- Creating a Basic Pivot Table
- Grouping Data with Pivot Tables
- Summarizing Values (Sum, Average, Count)
Glossary
Review these key terms before starting this week. They are kept simple so students can learn the new vocabulary before moving into the slides.
- What Is a Pivot Table?
- What Is a Pivot Table?
- Creating a Basic Pivot Table
- Creating a Basic Pivot Table
- Grouping Data with Pivot Tables
- Grouping Data with Pivot Tables
What Is a Pivot Table?
Progress
1 / 8
Summarize and explore data using pivot tables.
Read one card at a time. Focus on the main idea first, then look at the visual on the right to help it stick.
A pivot table summarizes large datasets quickly.
It groups and aggregates data interactively.
It does not change the original data.
It helps explore data from different angles.
It is a powerful step beyond basic formulas.
Remember
Pivot tables are powerful because they let you reorganize the same data to answer new questions quickly.
What Is a Pivot Table?
Slide 1 of 8
Use arrows or dots to move through the lesson
Practice
- Write 2-3 sentences about what you learned this week.
Coming Next Week: Next: Data Cleaning Basics