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
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/.
Ann K. Emery equips organizations to visualize data more effectively. Within the past year alone, she has led more than 60 professional development trainings for more than 2,800 participants around the globe. Her design consultancy also overhauls graphs, publications, and slideshows with the goal of making data-heavy reports easier to digest for non-technical audiences. Recent clients include the United Nations, Centers for Disease Control, National Institutes of Health, and dozens of professional societies, associations, foundations, and nonprofits.