How-To Geek on MSN

Excel PivotTables seem complicated—until you understand the basics

You don't need complex formulas to summarize thousands of rows when PivotTables can do the heavy lifting for you.
Hosted on MSN

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

Conditional formatting and PivotTables are two of Excel's most powerful features, but they don't always play nicely together. Apply a standard color scale or data bar to a PivotTable, and a refresh, ...