YouTube on MSN
I ditched pivot tables for GROUPBY
Learn how to use Excel’s GROUPBY function as an alternative to PivotTables. GROUPBY updates automatically when source data changes (unlike pivot tables, which require manual refresh). The video also ...
Hosted on MSN
Excel hack: GROUPBY beats pivot tables
Excel's GROUPBY and PIVOTBY functions can replace Pivot Tables in many everyday scenarios. Compared with Pivot Tables, these formulas update automatically when source data changes, expose their logic ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results