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