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!”
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/.
Comments