3 PivotTable Grouping Tricks to Summarize Data FAST!

Battling to consolidate monthly figures into quarters, or segment data into numeric bands? Perhaps you're aiming for a bespoke grouping in your PivotTables.

PivotTable grouping lets you intuitively classify dates, times, and number intervals, while also allowing for tailored group creations to reveal the hidden narratives in your data.

With just a few clicks:
📅 Group dates into months, quarters and years
🕰️ Group Time into seconds, minutes and hours
🔢 Group numeric data into intervals or bands
⁉️ Group items into custom groups

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

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

📢 Please leave me a COMMENT. I read them all!


🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

⏲ TIMESTAMPS
==============
0:00 Advanced PivotTable Grouping
0:28 Group dates into months, quarters and years
4:16 Group numeric values into bands
5:45 Custom Groups

[michaelbrown]

That was adorable...AND I didn't know I could create my own pivot table groupings!! Always something new to learn. Thanks Mynda!

[notesfromleisa-land]

An engagingly humorous way to show better ways to work with data. Love it.

[tomfontanella]

Don’t know what to say. Yes, I learned a bundle of pivot table tricks … with a smile on face the whole time. The only problem is that you have seriously raised the bar for your videos!

[johncowie]

I am also an excel trainer consultant and it’s good to re-affirm that your own top tips align with others.
This was an excellent video.
Particularly in the main benefit which is if you do things efficiently through knowledge and understanding you free up time.
I.e. you can get your work done and get the bus at 5 instead of working till 7 inefficiently.
This why companies need to train their staff

[mashuur]

Absolutely beautiful! So many tips and tricks, yet delivered in an entertaining way!

[equiwave]

Thanks for this useful PivotTable Grouping video.
It was a good refresher for me especially the Age grouping and the Categorical data grouping!!!

[MegaTrickykid]

Thank you very much indeed, EXCELSIA!

[EleanorStart-zgui]

Thank you so much for this! I was spending hours trying to group data by month using Pivot Tables but failed. Cleaning the data on Power Query fixed it straight away.

[vijayarjunwadkar]

I wonder, how I missed this video earlier, but thank god, I found it. Excellent as usual, learnt new things about grouping, I didn't knew before! Thanks a lot Mynda, you are doing great service to Excel community, keep it up! Would love to see more of this series with Krysta! 🙂

[UstedTubo]

The Excel Enchantress! Yes! I don't even own Excel 365 and I don't miss a single one of these videos.

[peterscobbie]

What a fun way to deliver content, Mynda, don't get to see Excelsia often enough ;-)

[tarquinalgernonmoncrief]

did not know about custom grouping. Love that

[khersheonteoh]

i'm not going home, i'm going back to work right now to update my pivot

[occelusorac]

There's always something new to learn. Thanks Mynda

[guillermoagz]

What an amazing video and I love the conversation, makes it so easy to follow and have fun at the same time. You simply make magic with all the tricks you shared, , 👏

[ildikojanosi]

Amazing Mynda! Plenty of tricks supported by a lovely storyboard ♥ The Grouping function within a pivot table is absolutely new for me, could have saved me a lot of time... Thank you so much!

[alisavas]

Nice tricks, especially using PQ! Very helpful

[reng]

I really enjoyed the way this Video was crafted!

[CeliaAlvesSolveExcel]

Congratulations on the new production style, Mynda! I can only imagine how much work and time it took you and your team, but it was worth it. I had a great time watching it. 🎉

[annajennison-phillips]

This is a really easy to grasp and very cute video, thank you so much Mynda and Excel-sior and well done Kirsty for "seeing the light"! (I also learnt new stuff about the pivot groupings btw)