Uploaded January 2026 | Updated September 2026, 2 weeks ago
Download the Practice Kit ⬇️ - goodly.co.in/7-awesome-pivot-table-tricks
Join my Power BI Community - products.goodly.co.in/learn-dax-powerbi#:~:text=Start%20Your%20Learning%20Journey!
In this video, I share some powerful Excel Pivot Table tricks, divided into two clear categories. The idea is to move beyond basic Pivot Tables and show what is possible when you stop using them in the "standard" way.
We start with Happy Tricks. These are simple formatting and reporting hacks that solve common daily problems. Things like applying filters to calculations or splitting one master report into multiple sheets, all without complex formulas.
Next, we move to Intelligent Tricks. These are advanced techniques using Power Pivot and DAX in Excel that often make people ask, “How did you do that?” You will see how to create dynamic year over year growth and even return text values from Pivot Tables.
This video is for anyone tired of manual work and looking to build scalable, impressive reports. The practice file is linked below so you can follow along step by step.
youtu.be/2y2VP6i8S8c?si=ns8Cx2l9u2PDYfsq
===== ONLINE COURSES =====
✔️ Grab My Power Query Book -
products.goodly.co.in/power-query-book
✔️ Master 'M' in Power Query -
products.goodly.co.in/learn-m-powerquery/?
✔️ Mastering DAX in Power BI -
products.goodly.co.in/learn-dax-powerbi
✔️ Power Query Course -
products.goodly.co.in/learn-power-query
✔️ Master Excel Step-by-Step-
products.goodly.co.in/learn-excel
===== LINKS 🔗 =====
Blog 📰 - goodly.co.in/blog
Corporate Training 👨🏫 - goodly.co.in/training
Need my help on a Project 💻- goodly.co.in/consulting
Download the Practice Kit ⬇️ - goodly.co.in/7-awesome-pivot-table-tricks
===== CHAPTERS 📖 =====
00:00 - Intro
00:30 - Trick 1
02:05 - Trick 2
04:09 - Trick 3
07:26 - Trick 4
08:45 - Trick 5
11:36 - Trick 6
17:44 - Trick 7
===== CONTACT 🌐 =====
Twitter - twitter.com/chandeep2786
LinkedIn - linkedin.com/in/chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Download the Practice Kit ⬇️ - goodly.co.in/7-awesome-pivot-table-tricks
Join my Power BI Community - products.goodly.co.in/learn-dax-powerbi#:~:text=Start%20Your%20Learning%20Journey!
In this video, I share some powerful Excel Pivot Table tricks, divided into two clear categories. The idea is to move beyond basic Pivot Tables and show what is possible when you stop using them in the "standard" way.
We start with Happy Tricks. These are simple formatting and reporting hacks that solve common daily problems. Things like applying filters to calculations or splitting one master report into multiple sheets, all without complex formulas.
Next, we move to Intelligent Tricks. These are advanced techniques using Power Pivot and DAX in Excel that often make people ask, “How did you do that?” You will see how to create dynamic year over year growth and even return text values from Pivot Tables.
This video is for anyone tired of manual work and looking to build scalable, impressive reports. The practice file is linked below so you can follow along step by step.
youtu.be/2y2VP6i8S8c?si=ns8Cx2l9u2PDYfsq
===== ONLINE COURSES =====
✔️ Grab My Power Query Book -
products.goodly.co.in/power-query-book
✔️ Master 'M' in Power Query -
products.goodly.co.in/learn-m-powerquery/?
✔️ Mastering DAX in Power BI -
products.goodly.co.in/learn-dax-powerbi
✔️ Power Query Course -
products.goodly.co.in/learn-power-query
✔️ Master Excel Step-by-Step-
products.goodly.co.in/learn-excel
===== LINKS 🔗 =====
Blog 📰 - goodly.co.in/blog
Corporate Training 👨🏫 - goodly.co.in/training
Need my help on a Project 💻- goodly.co.in/consulting
Download the Practice Kit ⬇️ - goodly.co.in/7-awesome-pivot-table-tricks
===== CHAPTERS 📖 =====
00:00 - Intro
00:30 - Trick 1
02:05 - Trick 2
04:09 - Trick 3
07:26 - Trick 4
08:45 - Trick 5
11:36 - Trick 6
17:44 - Trick 7
===== CONTACT 🌐 =====
Twitter - twitter.com/chandeep2786
LinkedIn - linkedin.com/in/chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
