How-To Geek on MSN

I ditched multiple Excel worksheets for one dynamic report and saved myself a ton of work

One selector can replace a stack of nearly identical Excel reports, while FILTER handles the changing results.
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 ...

Are you exhausted at the end of the month from aggregating time charges?

Are you exhausted at the end of the month from aggregating time charges?After the 25th of every month, I always start feeling heavy. Our office is a small firm with four lawyers, and we use a mix of ...

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