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

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

Excel Tests Lists and Arrays That Store Multiple Values in a Single Cell

Microsoft has announced lists and in-cell arrays for Excel's Beta channel. Here is how they differ from dynamic arrays, where ...

The fastest way to create a cross-tabulation for surveys in Excel

Whether you want to compare satisfaction levels by grade or see if response trends differ between genders, cross-tabulation ...

Google Sheets now plays more nicely with your imported Excel spreadsheets

Google Sheets is getting a few new features, including improvements for handling Microsoft Excel spreadsheets.