The Gap Between Basic and Advanced Pivot Tables @GoodlyChandeep
The Gap Between Basic and Advanced Pivot Tables  @GoodlyChandeep
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!
The Gap Between Basic and Advanced Pivot TablesXLOOKUP Multiple Columns TrickThe Skill That Decides Your Career GrowthAdvanced Pivot Table Tricks Nobody Else Teaches YouNested Table Tricks That Save Hours of Power Query WorkPower BIs New Update – Quickly Format Your Charts with Double ClicksText Values in a Pivot Table? Yes, PossibleWhy DAX Feels So Hard to LearnConflicting Filters in CALCULATE 🤔Plan Your Power BI Model in 4 StepsFind Columns in Power Query in 2 SecondsHow to work with Multiple Fact Tables in Power BI
Goodly |

The Gap Between Basic and Advanced Pivot Tables

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER