Pivot Table Excel Tips & Tricks: Excel learning resource
Pivot Table Excel Tips & Tricks
A tips-format follow-up to Stratvert's beginner PivotTable video, aimed at someone who can already build one.
What this video actually covers
A tips-format follow-up to Stratvert's beginner PivotTable video, aimed at someone who can already build one. Two tricks are worth calling out specifically: double-clicking any total inside a PivotTable drills into the underlying rows behind that number, useful for auditing a total you don't trust, and building a single PivotTable from data spread across multiple sheets rather than one flat range. The rest of the video tours slicers, a timeline filter for date fields, grouping numeric or date values into buckets, and customizing how repeated row labels display — each treated as a standalone trick rather than one connected workflow.
Where to jump in
What to practice while watching
- Double-click a total cell in a PivotTable built from the practice dataset to drill into the individual rows behind that number.
- Add a Slicer for Region or Product and confirm it filters the PivotTable live.
- Add a Timeline for the date column and filter the report to a single month or quarter.
- Group a numeric field, such as Amount, into custom buckets instead of listing every individual value.
Exercise file
Practice the steps above on a real workbook instead of a blank sheet — no sign-up required.
Download PivotTable practice: sales transactions (.xlsx)Recommended learning path
Start by watching the lesson once without pausing, then reopen Excel and rebuild the example with your own small dataset. Save one clean practice workbook before moving to the next topic.
Source details
- Channel: Kevin Stratvert
- Format: video
- Level: Intermediate
- Topic: Pivot Tables
Go deeper with this skill
Use PivotTables to explore data quickly while keeping the source table clean and refreshable. For this article, the goal is to practice: A tips-format follow-up to Stratvert's beginner PivotTable video, aimed at someone who can already build one.
Practice workbook setup
Prepare a source table with headers, dates, categories, and numeric measures.
Practice workflow
- Convert the source data into an Excel Table before inserting the PivotTable.
- Build one simple summary first, then add filters, slicers, or grouping.
- Change value field settings and number formats so the result matches the question.
- Refresh after changing the source data and confirm new rows appear.
Quality checks
- The source table has no blank header names or merged cells.
- The PivotTable answers a specific question.
- Filters and slicers are visible enough for readers to know what they are seeing.
Common mistakes
- Building pivots from messy ranges instead of clean tables.
- Forgetting to refresh after source changes.
- Counting text fields when a numeric sum was expected.
Next actions
- Add one slicer and one PivotChart to turn the summary into a small report.
- Create a second PivotTable from the same source to answer a different question.
Formula focus: even if this workflow is not formula-heavy, add one check cell that confirms the final output still matches the source data.
