YouTube on MSN

Try the new GROUPBY function instead of pivot tables

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

3 Steps to Reduce Pivot Table Reference Errors from 6 to 0 per Month Using Excel GETPIVOTDATA | Unbreakable KPI Dashboards

A Monday that started with, "The numbers from last month are off."Monday morning at the start of the month, 9:00 AM. A chat ...

Counting Unique Customers with Excel Pivot Table 'Distinct Count' | 3 Steps to Reduce Monthly Manual Counting from 90 Minutes to 5

The story of how I spent 90 minutes answering, 'How many companies did we trade with last month?'It's 5:00 PM on the day ...