How-To Geek on MSN

Conditional formatting breaks in Excel PivotTables—until you turn on this hidden setting

PivotTable-aware conditional formatting ties rules to fields, so visuals persist even when you refresh, filter, or change ...
How-To Geek on MSN

Nobody told me about these 5 Excel PivotTable tricks—now I use them every day

PivotTables can do more than you think, from splitting reports by category to calculating unique counts and percentage growth ...
JournalofAccountancy

Using Excel’s GROUPBY function as a PivotTable alternative

Q. Are there any alternatives to traditional PivotTables in Excel? A. The first thing that comes to mind is the function GROUPBY. The primary purpose of GROUPBY is to make data analysis easier by ...