Recall
Set 1: Quick Check
Place fields correctly, recognize refresh needs, and confirm that the source is tidy.
Pivot Tables & Summaries
PivotTables for Quick Summaries
Build practical skills in pivot tables & summaries.
Start Chapter PracticeChapter plan
What you will be able to do
- Apply pivot tables & summaries concepts in realistic spreadsheet work.
- Study time
- 28–34 minutes, self-paced
- Course
- Excel for Work (Beginner)
- Practice order
- Four sets, completed in sequence
Chapter practice
Practice in chapter order
10 activities · 80% mastery target
Start set 1
Guided application
Set 2: Core Practice
Choose the right aggregation and arrange row, column, and report-filter fields deliberately.
Hands-on
Set 3: Workplace Task
Create regional order-count and revenue summaries in the spreadsheet workspace.
Independent check
Set 4: Mastery Check
Reconcile a grand total and refresh the summary after the source data grows.