Pivot tables are the fastest, easiest way to make sense of spreadsheets. Whether you spend 10% or 100% of your day working with data, pivot tables are a must-have spreadsheet skill. In this 90-minute webinar, you’ll learn how to:

• design your spreadsheet to be compatible with pivot tables (e.g., prerequisites like contiguous data);
• create pivot tables from scratch;
• navigate the field list, row headers, column headers, and filters;
• run descriptive statistics such as averages, means, counts, and frequencies;
• clean data by checking for duplicates;
• make sure your pivot table still works even after you’re updated the raw numbers in your spreadsheet; and
• group items like names and dates together so that you can analyze them in aggregate.

We’ll look at several different types of datasets together, like demographic data on people from your organization’s member database and survey responses similar to your organization’s latest consumer satisfaction survey.

You’ll get to keep the spreadsheets used during the webinar, and I’ll give you access to the webinar recording so you can watch it again while you’re practicing on your own.

What People Are Saying

“Webinar is amazing! I’m learning so much! Thank you! This is awesome.”
“This is sooo helpful!”
“I LOVE THIS!”

@AnnKEmery is an amazing teacher! Pivot Tables are cool! @EPIPDC #data #eval #nonprofits #philanthropy #skills

— Jenny (@JennyB_DC) March 19, 2015

One thing I learned from @AnnKEmery today: you don’t have to know what you’re looking for to start looking at your data #dataanalysis

— Jenny (@JennyB_DC) March 19, 2015

Learning about pivot tables for data analysis with @AnnKEmery, which will be really useful for #Philamplify — thanks @EPIPDC! #philanthropy

— Caitlin Duffy (@DuffyInDC) March 19, 2015

Pivot table webinar w @AnnKEmery is fantastic!!… — Museology Evaluation (@UWNewDirections) January 12, 2015

Outstanding webinar by @AnnKEmery on Pivot Tables! Stay tuned for highlights & notes on http://t.co/ZHHYedOcdw — Katherine Haugh (@Katherine_Haugh) January 12, 2015

Purchase the Recording and Accompanying Materials

This webinar has finished, but you can still purchase the recording and accompanying spreadsheets. Contact me.