The Guide to PivotTables


I call PivotTables the “WD-40 of Excel” because they allow you to loosen up and extract meaning and trends out of your data.

Introductory SlideShare:

Here are a few of my top posts on PivotTables:


PivotTable Data Prep

Anatomy of a PivotTable

#PivotTableProblems: Always be Refreshing

#PivotTableProblems: Avoid GETPIVOTDATA

#PivotTableProblems: Tweak Your View

PivotTables: Add a Calculated Field

Learn how your new PivotTable chops can get you a job! Check out my course “Hired with Excel: The Essential Guide to Interviews.”


Subscribe to my mailing list.

Leave a Reply

%d bloggers like this: