Q. Traditional PivotTables have always intimidated me. I see there is a new Excel function called PIVOTBY. What is the difference between it and the traditional PivotTable? With the PIVOTBY function, ...

Have you ever found yourself wrestling with Excel, trying to make sense of messy data or create reports that actually tell a story? Whether you’re a seasoned pro or just starting out, Excel can ...

When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions. The TechRepublic article How to create a sorted unique list in an Excel ...

Have you ever grouped data in Excel only to find your months sorted alphabetically instead of chronologically? It’s a frustrating quirk of the GROUPBY function, one that can turn a clean dataset into ...

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