Uploaded March 2026 | Updated November 2026, 4 days ago
Register for the Power Query Learning Festival on 10 & 24 May 2026.
Join the live masterclasses, take part in quizzes, win prizes, and get access to special offers
Register here → goodly.co.in/power-query-festival
Download the Practice Kit ⬇️ - goodly.co.in/become-a-genius-at-pivot-tables
Learn DAX & Data Modeling - products.goodly.co.in/learn-dax-powerbi
youtu.be/RydHZIQeaww?si=DyXKtWyLuRsMjqEY
In this video, I’m going to show you some advanced Pivot Table tricks in Excel, divided into two parts: advanced formula tricks using Power Pivot and DAX, and formatting tricks that make your reports look clean and professional.
We’ll solve real problems like:
• Finding best-selling product using Pivot Table + DAX
• Getting text values based on numerical criteria (CONCATENATEX)
• Building nested Pivot Table logic without messy setups
• Writing custom totals using DAX in Power Pivot
• Using GETPIVOTDATA for dynamic dashboards
• Designing better Pivot Table slicers and formatting
If you work with Excel, Pivot Tables, Power Pivot, or DAX, these tricks will help you go beyond basic reporting and build smarter, more dynamic dashboards.
Watch till the end and let me know which Pivot Table trick you found most useful.
===== 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
===== CHAPTERS =====
0:00 Intro
0:17 Formula Trick 1
7:39 Formula Trick 2
15:06 Formatting Trick 1
16:17 Formatting Trick 2
18:55 Formatting Trick 3
===== 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!
Register for the Power Query Learning Festival on 10 & 24 May 2026.
Join the live masterclasses, take part in quizzes, win prizes, and get access to special offers
Register here → goodly.co.in/power-query-festival
Download the Practice Kit ⬇️ - goodly.co.in/become-a-genius-at-pivot-tables
Learn DAX & Data Modeling - products.goodly.co.in/learn-dax-powerbi
youtu.be/RydHZIQeaww?si=DyXKtWyLuRsMjqEY
In this video, I’m going to show you some advanced Pivot Table tricks in Excel, divided into two parts: advanced formula tricks using Power Pivot and DAX, and formatting tricks that make your reports look clean and professional.
We’ll solve real problems like:
• Finding best-selling product using Pivot Table + DAX
• Getting text values based on numerical criteria (CONCATENATEX)
• Building nested Pivot Table logic without messy setups
• Writing custom totals using DAX in Power Pivot
• Using GETPIVOTDATA for dynamic dashboards
• Designing better Pivot Table slicers and formatting
If you work with Excel, Pivot Tables, Power Pivot, or DAX, these tricks will help you go beyond basic reporting and build smarter, more dynamic dashboards.
Watch till the end and let me know which Pivot Table trick you found most useful.
===== 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
===== CHAPTERS =====
0:00 Intro
0:17 Formula Trick 1
7:39 Formula Trick 2
15:06 Formatting Trick 1
16:17 Formatting Trick 2
18:55 Formatting Trick 3
===== 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!










