ULTIMATE Guide to the GROUPBY and PIVOTBY Functions in Excel!

[@Luciano_mp]

These new features are very good. Microsoft has been implementing many features in recent years that make our day-to-day life much easier! Your work is top-notch. Thanks!

[@robertoschenone9648]

Accurate and exhaustive. In one word:excellent

[@ruminsb330]

You Make It So Easy To Understand

[@michael6malone]

You make it sooooo easy to understand :) Thank you.

[@cellmatestraining]

You’re welcome!

[@et.sachin]

Great video!

[@cellmatestraining]

Thanks!

[@SimplyDigitalLK]

Very well explained. I really like the groupby and pivotby functions, makes a lot of interesting things in my spreadsheets. But its still true, these will most likely not be used in daily operation life. There - the pivot table still wins :). I guess, mostly - people still dont learn too much of excel.

[@Abdul-b9f5v]

Good video

[@cellmatestraining]

Thanks!

[@willm7994]

Can you please do a similar group by video using drop or choose please .

[@Simon-vc1wk]

I thought pivot tables had refresh on open function, albeit won't refresh if your data changes while workbook is open but could have a macro that periodically refreshes pivot I think

[@mosaidso73]

Great video, but I still believe pivot table is easier to use.

[@cellmatestraining]

Different tools for different things. It’s not a replacement for Pivot Tables

[@jerrydellasala7643]

One thing, a Pivot Table is the ONLY way to report data that has more than 1,000,000 rows of data which cannot be loaded into a table.

[@ExcelOffTheGrid]

Data model + CUBE functions. Can handle more than 1,000,000 rows and doesn’t use a PivotTable.