The Guide to PivotTables

oil-295619_960_720

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:

WhyPivotTables?

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: