PivotTable Tricks That Will Change the Way You Excel (Free File)

Advanced Pivot Table tips & tricks to make you a PRO Excel user.

There's no denying, PivotTables are time-savers. They're one of Excel's most powerful tools, but they have a lot of cool features that most Excel users will never discover on their own. So, in this video, I'm going to uncover the pro tips & tricks that will take your PivotTables to the next level, so you can analyze data like an Excel boss.

LEARN MORE
===========



⏲ TIMESTAMPS
==============
0:00 Save time with PivotTable tricks
0:25 Trick №1
2:23 Trick №2
4:30 Trick №3
6:35 Trick №4
8:26 Trick №5
9:55 Trick №6
12:48 Trick №7
14:55 Trick №8
15:51 Trick №9
16:53 Trick №10

#Excel #ExcelTutorial #PivotTable

[MyOnlineTrainingHub]

❓Which one of these tricks do you like the most?

[skyking]

I have learned SO much about Excel and PQ from you. But I've actually learned more about how to teach technical content. Your approach is the master class in how to structure the flow of a technical feature, create relevant examples, and provide robust context. Simply the best I have ever seen.

[deebradford]

adding a filter to the pivot table. Wow, how many times have I struggled with sorting. And to find out how simple it was to add the filter. Now hoping I'll remember it next time I need it!

[c.l]

4 minutes into the video and directly decided to follow your channel... Something that I don't do that often.
Great explanation and so helpful. Calm and clear, no music, no excited screaming or sales pitch style of talking (God, so many you tubers have that...)
I could listen to you all day!
Will use everything right away on my huge list of data!

[viktorasgolubevas]

The 🍕 example is my winner!
I somehow overlooked these amazing features of PT:
Report Connections for Slicers,
Filter Connections for PivotTables.
... and what a brilliant idea to tag/classify sheets with emojis 😍

[chrism]

Excellent Mynda. I knew about the timeline slicer but always forget to use it!

[Shhhpeppys]

Wish I had this when I was working. Oh the joy I would have had when month-end came around. So powerful yet simple. Thanks for the education. Your vids are outstanding.

[tashadj]

Without a doubt one of the best excel teachers on you tube, so clear

[alxj]

hi Mynda, the navigation on side left when you were navigating is something I've never seen before too - ideal for complicated progress claims and invoice excel reports

[ivanbork]

You are one of the weekly highlights, and especially the formula to tell “Only select one item in the slicer” is a good idea to improvement.
The other stuff I know about, or have been using, but it´s always good to have it refreshed or see new ways to use the features.

[mogarrett]

excellent as always Mynda...thank you

Mo

[rajanghadi]

First time I thought nothing was new for me. But you nailed it. Click for not showing details was new for me.

[munim]

Mynda 5:49 you can also select more options, and select the cell T7 to sort on Dec. I really liked trick 10. Thanks

[humansizedaperture]

Thank you for giving a good use case for when you need calculated fields: “instead of adding a column”!

[kumarsb]

Thank you for this. It's a treasure trove of Pivot Table tricks in a short time frame.

[MrsJerjev]

Thank you for your patience in teaching the me and the audience

[alexanderadamov]

Great video, thank you. Mexico is still North America, though :)

[DineshKumar-xlug]

Your Explanation is Top Noth and straight to the Point. Great Teaching Skills.Thanks a lot

[Fabi_terra]

Amazing and easy to follow tutorial! Thanks so much, Mynda! 😍

[flaviogarlatticosta]

Thank you for your impeccable explanations, clear even for those who, like me, are not English speakers. Great.