Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Introduction to Excel Pivot Tables (Basics Only)
🎯 Pivot Table Success Essentials
Course Introduction (1:10)
What is a Pivot Table? How Can it Help You? (1:25)
🗃️ Pivot Table Basics & Must-Knows
How to Create a Pivot Table in Excel (12:17)
Filters, Columns & Hierarchies in Pivot Tables (6:23)
Format Numbers the Right Way (Plus Dynamic Formatting!) (4:03)
Rename Headings, Totals & Items in Pivot Tables (2:52)
How to Drill Down a Pivot Table to Show Detailed Data (2:17)
Show / Hide Totals & Subtotals (5:14)
Pivot Table Layout to Separate Fields into Columns (2:18)
Repeat Labels vs. Merge & Center Labels (3:52)
🤔 Quiz 1
Pivot Table Style to Fit Your Reports (5:35)
Create Multiple Pivot Tables (4:43)
Delete / Move Pivot Tables (3:33)
Auto-Create Pivot Tables for Each Item (2:33)
Print to PDF - Useful Layout Choices (3:02)
Add Slicers to Pivot Tables (8:30)
Connect, Disconnect Slicers from Pivot Tables (5:16)
Stop Pivot Table Columns From Resizing (1:43)
GETPIVOTDATA - Reference Pivot Table with Formulas (12:52)
🤔 Quiz 2
💪 Challenge - Mastering Pivot Tables Must-Knows
✅ Solution - Mastering Pivot Table Must-Knows (6:25)
📝 Key Takeaways
🔃 Refresh Data Without Issues
Intro to Refresh & Best Practices (0:48)
How to Refresh a Pivot Table (Shortcut & Autorefresh) (5:46)
Pivot Table Not Showing All Data (11:52)
Using Tables as Data Source (Best Practice) (8:26)
Slicer or Pivot Table Showing Deleted Items (3:31)
How to Verify Pivot Tables Are Up to Date (5:58)
💪 Challenge - Refresh Not Working
✅ Solution - Refresh Not Working (4:13)
🤔 Quiz 3
📝 Key Takeaways
🥳 Wrap-Up & Your Next Steps to Master Pivot Tables
Well Done! Next Steps for Pivot Table Mastery (1:58)
Master Advanced Pivot Table Skills
Auto-Create Pivot Tables for Each Item
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock