Analyzing Grantmaking Data: Saving Time and Energy with Pivot Tables

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.

During this 60-minute online 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;
• drag and drop variables to calculate averages, tallies, and sums;
• remove duplicate entries from your dataset;
• make sure your pivot table still works even after you’ve updated the raw numbers in your spreadsheet; and
• group items like names and dates together so that you can analyze them in aggregate.

Format

This workshop is heavily hands-on, so bring your energy and enthusiasm! The instructor will demonstrate a skill and then you’ll have a chance to practice using the sample datasets provided. We’ll look at several different types of datasets together, like demographic data from your organization’s member database and survey responses similar to your organization’s latest consumer satisfaction survey.

Target Audience

Anyone who uses spreadsheets. This online workshop is perfect for anyone who’s brand new to pivot tables and serves as an excellent refresher for anyone who’s used pivot tables in the past and wants to learn new shortcuts.

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 webinar is offered exclusively to EPIP members. To join EPIP, please visit http://www.epip.org/membership/.

Want to discuss a possible workshop or webinar for your team? Contact me.