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 ...

At one point, Pivot Tables were the greatest feature in Excel, but as with most tools and tricks, that’s no longer the case. Instead of setting up a Pivot Table, adjusting the layout, and refreshing ...