Expliquewatch · explain · prove

← all topics

Excel pivot table

6 lessons · 2:47 · updated 8/29/2026

Watch them in order, then explain the topic in your own words below.

Nobody with subject knowledge has checked this course yet. It was put together automatically.

What you will do in this course

  • What Is Pivot Table
  • Group Pivot Data
  • Top Ten Customers
  • Create Pivot Table
  • Master Calculated Fields
  • Auto Refresh Pivot
0 / 6 lessons watched

Getting started

2 lessons · short section, not a full path on its own

1. What Is A Pivot Table And How Do I Create One?

Pete - HowToAnalyst · watch the original · 0:51

2. How to make a Pivot Table in 3 Steps

Create Pivot Table

CheatSheets · watch the original · 0:34

Check yourself

Four questions on this section. Wrong answers are the point: each one explains itself.

Now you explain it

Close what you watched and explain the topic in your own words in 30 seconds. What you can explain is what you have learned. You are marked against this course's lessons and nothing beyond them.

Explain how you would do this: Getting started — Create Pivot Table.

You are judged on these, and nothing else in the course:

  • What Is Pivot Table
  • Create Pivot Table

Doing it properly

1 lessons · short section, not a full path on its own

1. How to group pivot table data in excel

Excel With JT · watch the original · 0:23

Check yourself

Four questions on this section. Wrong answers are the point: each one explains itself.

Now you explain it

Close what you watched and explain the topic in your own words in 30 seconds. What you can explain is what you have learned. You are marked against this course's lessons and nothing beyond them.

Explain how you would do this: Doing it properly — Group Pivot Data.

You are judged on these, and nothing else in the course:

  • Group Pivot Data

Going deeper

3 lessons · short section, not a full path on its own

1. Excel Pivot Tables: Identify Top 10 Customers by Sales Volume

Top Ten Customers

GetFormula · watch the original · 0:27

2. Mastering Pivot Tables With Calculated Fields Made Easy

Master Calculated Fields

How to Learn Excel · watch the original · 0:18 · a taster

3. Auto Refresh Pivot Table Data When the Excel File Is Opened

How to Learn Excel · watch the original · 0:14 · a taster

Check yourself

Four questions on this section. Wrong answers are the point: each one explains itself.

Now you explain it

Close what you watched and explain the topic in your own words in 30 seconds. What you can explain is what you have learned. You are marked against this course's lessons and nothing beyond them.

Explain how you would do this: Going deeper — Auto Refresh Pivot.

You are judged on these, and nothing else in the course:

  • Top Ten Customers
  • Master Calculated Fields
  • Auto Refresh Pivot