10 Mind Blowing Pivot Table Tricks 🤩 - How many do YOU know?

This is the last 'Pivot Table' tricks video's follow-up video. Here are 10 more Pivot Table Tricks that can help you to become smarter with Pivot Tables!

Join this channel to get access to perks:

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== 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'd find a ton of interesting videos that I have created :) Cheers!

[jayeshsuthar]

I am able to surprise my manager every time I work on excel by watching your amazing tricks and tips. Thank you bro❤️

[briandennehy]

That concatenatex example is superb and is gonna be a life saver for me, thanks!

[Julyenderson]

The first one just blown my mind. It basically convert a table in a database and it's exactly what I was looking for and couldn't find it weeks ago. ❤❤❤

[donduck]

For the first one whenever I get data like this, I hit Ctrl+A, Ctrl+C, Ctrl+Alt+V (paste special), hit E to select Transpose and then Return. That transposes the data in seconds perfectly for a pivot table which I think is a lot simpler and quicker than using a legacy pivot table within excel. As others have mentioned, Unpivot Columns in PQ is efficient too

[ArmandoReportes]

Pivot tables? Those I know... Well, I'll watch the video. There might be something new... Tip 1: 😱🤯

[ExcelWithChris]

Once again - BRILLIANT STUFF! Thanks from South Africa.

[ankursharma]

AMAZING!
AMAZING!
AMAZING!

This Inspires Me So Much . . that there is SO MUCH to LEARN!

[martyc]

Thanks Chandeep- best trick I picked up was at 14:12 when you hit “more tables” to instigate sending the existing pivot to the data model, I did not know you could do that so easily.

[IvanCortinas_ES]

Very complete, powerful and with many functionalities to apply in daily work. Thank you

[szymonmatusiak]

Trick number 8 is amazing. I use pivots to create 90 percent of my reporting and this trick will allow me to go even further. Thank you so much!

[EslamAbdo]

that's really cool.

Thank you.

[SanaKhairi-op]

Hi Chandeep, I'm a big fan of you and your videos.
I've a nested table in a column with more than one records for each record on the main table. I want to filter the nested table to keep only the record which has matching ID on the current record of the main table, before expanding, in order to avoid duplicates.
If I just remove duplicates after expanding, it may remove the matching ID and keep any one of the others, which I don't want.
Thank you, and keep up the good work.
You're simply the best!

[meniporat]

Amazing video.
About tip no.1:
If your interface isn't in English or if you don't remember the the shortcut: Alt+D+P
it is better to add the "Pivot Table and Pivot Chart Wizard" to your QAT (Quick Access Toolbar).
1. right-click the QAT
2. select "customize the QAT"
3. in the "choose commande from" drop-down select "All commands"
4. scroll down in the list and choose "Pivot Table and Pivot Chart Wizard"
5. click the Add button to add this shortcut to the QAT
6. that's all. frorn now on, you can easily use the QAT instead of memorizing the shortcut 🙂

[GeertDelmulle]

Good stuff, Chandeep! That old wizard keep popping up and amaze me. And yes, trick no. 9: that is my favorite and default setting, too.
Trick no. 10: I didn't know that was possible...
PS: here's one more trick for you: use Grouping on a numerical field in the row headers to automatically create bins useful for histograms. Yet, be careful to keep the data in the pivot table cache, because of you add the table to the data model, you lose this capability.
Thanks for another great video! 🙂👍

[ishaq]

Hello there, your channel was suggested to me by my Arab friend, although I'm Indian. my Arab friend is just obsessed about your video .

[Everythingexcelpro]

You alway deliver productive information.

[guitars]

Thank you for the pivot table tricks. Next time could you please include an index or chapter timeline so I can easily jump to each trick. Love all the pivot table content!

[finzblazin]

Tip #1 my jaw dropped .... You are my hero

[CreativelyChallenged]

These are awesome; I am pretty new to learning intermediate Excel. Anyway, to make a tutorial for inbound calls into a Call Center by the different queues?

[karenboatwright]

Another great video. Thanks for sharing