Uploaded January 2026 | Updated September 2026, 2 weeks ago
Take your PivotTable skills to the next level by learning advanced features that go beyond basic summaries. This video covers working with GETPIVOT functions, creating and customizing PivotCharts, and using powerful PivotTable tools to analyze data more efficiently. Ideal for anyone who wants faster insights and more control over Excel-based reporting.
✅Download the free course files and follow along here:
➡️ simonsezit.com/advanced-pivottable-in-excel-course-files
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - Create Custom Pivot Table Style
00:08:40 - Apply Custom Number Formatting
00:15:20 - Sort Using a Custom List
00:18:58 - Create Report Filter Pages
00:21:00 - Adjust Slicer Settings
00:30:02 - Lock Workbooks but not Slicer
00:37:16 - Add a Calculated Item
00:41:56 - Use GETPIVOTDATA
00:48:54 - Create Dynamic Chart Labels
00:54:54 - Exercise
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ simonsezit.com/courses
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 11,000+ ad-free videos and begin your transformation today! ➡️ simonsezit.lpages.co/ssit-14-day-free
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ hour training course playlist here ➡️
youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🔥 For a full training experience, check out our FREE YouTube course: 👉 youtube.com/@SimonSezIT/courses
✅ Microsoft Excel Tips and Tricks 👉youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
✅ Microsoft Office 2021 and Office 365 Training here 👉youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
💬Stay in touch!
SimonSezIT.com: SimonSezIT.com
LinkedIn: linkedin.com/company/simon-sez-it
FaceBook: facebook.com/SimonSezIT
🔔 Subscribe to our channel:
youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
Take your PivotTable skills to the next level by learning advanced features that go beyond basic summaries. This video covers working with GETPIVOT functions, creating and customizing PivotCharts, and using powerful PivotTable tools to analyze data more efficiently. Ideal for anyone who wants faster insights and more control over Excel-based reporting.
✅Download the free course files and follow along here:
➡️ simonsezit.com/advanced-pivottable-in-excel-course-files
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - Create Custom Pivot Table Style
00:08:40 - Apply Custom Number Formatting
00:15:20 - Sort Using a Custom List
00:18:58 - Create Report Filter Pages
00:21:00 - Adjust Slicer Settings
00:30:02 - Lock Workbooks but not Slicer
00:37:16 - Add a Calculated Item
00:41:56 - Use GETPIVOTDATA
00:48:54 - Create Dynamic Chart Labels
00:54:54 - Exercise
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ simonsezit.com/courses
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 11,000+ ad-free videos and begin your transformation today! ➡️ simonsezit.lpages.co/ssit-14-day-free
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ hour training course playlist here ➡️
youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🔥 For a full training experience, check out our FREE YouTube course: 👉 youtube.com/@SimonSezIT/courses
✅ Microsoft Excel Tips and Tricks 👉youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
✅ Microsoft Office 2021 and Office 365 Training here 👉youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
💬Stay in touch!
SimonSezIT.com: SimonSezIT.com
LinkedIn: linkedin.com/company/simon-sez-it
FaceBook: facebook.com/SimonSezIT
🔔 Subscribe to our channel:
youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
