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

You know how you build a PivotTable in Excel and then quickly eyeball the numbers to check whether they add up? It can be frustrating when they don't, especially when you're not sure what's causing ...