📊 Pivot Table — 10 Subtopics

1. Pivot Table Basics
   • What is a Pivot Table?
   • Why use it?
   • Creating a Pivot Table
2. Pivot Table Fields
   • Rows
   • Columns
   • Values
   • Filters
3. Value Calculations
   • Sum
   • Count
   • Average
   • Max
   • Min
4. Sorting
   • A → Z / Z → A
   • Smallest → Largest
   • Largest → Smallest
5. Filtering
   • Basic filters
   • Value filters
   • Top 10 / Bottom 10
6. Grouping
   • Dates → Months / Quarters / Years
   • Numbers → Ranges
7. Pivot Table Formatting
   • Number/currency format
   • Grand Totals
   • Subtotals
   • Report Layout
8. Calculated Fields / Calculations
   • Calculations inside Pivot Tables
   • Percentage of total
   • Difference / comparison
9. Refreshing & Managing Pivot Tables
   • Refresh
   • Refresh All
   • Changing the source data
   • Changing the data source
10. Practical Analysis
    • Build Pivot Tables from raw data
    • Ask business questions
    • Find insights
    • Combine Rows + Columns + Values + Filters

⭐ After these, learn separately

These are related to Pivot Tables but I recommend not mixing them into the basic Pivot Table lesson:

11. Pivot Charts
12. Slicers
13. Timeline
14. Pivot Table + Dashboard

So your learning structure can be:

Pivot Table → Pivot Chart → Slicer → Timeline → Dashboard