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.

⬇DOWNLOAD the example file here: https://www.myonlinetraininghub.com/e...

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
===========
⁉ Power Query course: https://www.myonlinetraininghub.com/e...

PivotTable Quick Start course: https://www.myonlinetraininghub.com/e...

LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/

EXCEL NEWSLETTER join here: https://www.myonlinetraininghub.com/e...

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

Please leave me a COMMENT. I read them all!

CONNECT with me on LinkedIn:   / myndatreacy  

SHARE this video and spread the Excel love.

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

EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e...


⏲ 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