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 workshop, 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 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.

Please bring laptops and power cords.

What People Are Saying

“The workshop was really thought provoking about how we can be more efficient in our data analysis!”

“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

Registration

This is a members-only workshop for the Emerging Practitioners in Philanthropy (EPIP). Membership is $150/year for individuals ($85/year for students). Learn more at http://www.epip.org/.