Excel for Evaluation: Organize, Analyze, and Visualize Your Data

Ever feel like you’re swimming upstream in data? Want to visualize your data, but not sure where to start? Do you have a gut feeling that you’re not getting the most out of Microsoft Excel? This workshop is for you! Join Ann K. Emery and the Indiana Evaluation Association on Friday, October 24 from 10:00 am – 1:00 pm at the Lumina Foundation in downtown Indianapolis for a hands-on workshop to build your data management and analysis skills. In the first hour, we’ll cover beginner, intermediate, and advanced spreadsheet skills and then move on to data visualization during the second half of the workshop. Data visualization requires two skillsets: critical thinking skills to match your visualization to your audience’s information needs numeracy level and technical skills to create visualizations in a software program like Excel. You’ll get a behind-the-scenes look into the design process, plus time to actively create and share your own charts.

Objectives
By the end of this hands-on workshop, you’ll be armed and ready to:

• Merge data from multiple sheets and files into a single master spreadsheet;
• Organize your spreadsheets by adding filters and freezing panes;
• Clean and recode messy data to get it ready for analysis;
• Run basic descriptive statistics and frequencies;
• Explore your data more fully through pivot tables; and
• Visualize your data through effective and easy-to-ready charts.

Please bring…
We’ll be working through real datasets together. Bring your laptops, power cords, and enthusiasm.

Organizer
The Indiana Evaluation Association (www.indianaevaluation.org) is a membership organization open to evaluators and to others who are interested in the practice and principles of evaluation. Meetings are usually held the third Friday of January, April, July and October. IEA is an affiliate of the American Evaluation Association.

Instructor
Ann K. Emery is an evaluator based in Washington, DC. She has taught workshops about data visualization, data analysis, and dashboards for dozens of nonprofits and foundations, as well as professional societies such as the American Evaluation Association, Washington Evaluators, and Nonprofit Technology Network. Connect with Ann through her blog (www.annkemery.com) and through Twitter (@annkemery).

Register
https://excelforevaluation.eventbrite.com