Sign up for my email newsletter and get free access to my analytics resource library.

Stringfest Analytics

Teaching analytics with modern Excel

The Guide to PivotTables

The Guide to PivotTables

posted on

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.”

 

Newsletter signup

Please wait...

Thank you for signing up. I look forward to becoming savvier about data with you.

Reader Interactions

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.