EPIP Webinar: Analyzing Grantmaking Data: Saving Time and Energy with Pivot Tables

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




Ann K Emery, Data Analysis + Visualization

Through her workshops, webinars, and consulting services, Ann K. Emery equips organizations to visualize data more effectively. She leads 30 to 50  workshops each year about Excel, Tableau, dashboard design, and spreadsheet skills for foundations, nonprofits, for-profits, and professional societies, both domestically and abroad. A researcher at heart, she is the Co-Chair of the American Evaluation Association's Data Visualization interest group and Secretary for the Washington Evaluators. Prior to launching her own consulting firm, Emery evaluated advocacy and public policy projects at Innovation Network; managed an internal performance management system at the Latin American Youth Center; evaluated educational programs for local, state, and national education agencies at ICF International; helped to build a coalition of youth-serving nonprofits at the Charlottesville/Albemarle Commission on Children and Families; and contributed to research-to-policy projects at the University of Virginia. Connect with Emery through her blog (www.annkemery.com/blog).



This webinar has been reserved for EPIP members only. If you are an EPIP member, email [email protected] to obtain the code to access the Eventbrite registration page. If not, become a member today!


Add to Calendar 08/26/2015 15:00:00 08/26/2015 16:00:00 America/New_York EPIP Webinar: Analyzing Grantmaking Data: Saving Time and Energy with Pivot Tables Check https://www.epip.org/analyzing_grantmaking_data_saving_time_and_energy_with_pivot_tables for the latest info.
August 26, 2015 at 3:00pm - 4pm Eastern Time (US & Canada)
Marie Moser ·

Be the first to comment

Please check your e-mail for a link to activate your account.