Using Excel's Pivot Table to Analyze Learning-Assessment Data Workshop

February 13, 1:30pm - 2:45pm
Mānoa Campus, KUY 106

Making Program Assessment Happen Workshop Series by the Assessment Office

Are there quick and easy ways to check data accuracy, summarize data, and present data? Yes! Excel's Pivot Table can help. Pivot table reports and charts can help organize large sets of data, observe patterns and trends in seconds, and graphically communicate findings to your colleagues and students. In this workshop, the presenter will demonstrate how to create and modify pivot tables and pivot charts to organize, summarize, and present data in meaningful ways. The presenter's examples and hands-on practice will involve program learning-assessment data. The participants are expected to learn how to

  • set up pivot tables;
  • alter pivot table data;
  • sort tables and create filters;
  • format pivot tables for effective presentations; and
  • create pivot charts.

Level: Beginner (basic Excel skills needed for optimal learning)
Format: Demonstration + hand-on practice
Requirement: Please bring a laptop with Microsoft Excel installed (Version 2007 and 2010 are preferred)

Click to register

Ticket Information
Register at the Assessment Office website.

Event Sponsor
Assessment Office, Mānoa Campus

More Information
Assessment Office (Yao Hill), 956-4283,,

Share by email

Wednesday, February 13

7:30am Maui Campus, Pilina Bldg., Wellness Center
9:30am Mānoa Campus, Harold L. Lyon Arboretum 3860 Manoa Road Honolulu, HI 96822
9:45am Windward Campus, Hale Kuhina 106
10:30am Windward Campus, Hale Kuhina 115
12:00pm Mānoa Campus, Moore Hall 319 (Tokioka Room)
12:00pm Maui Campus, The Learning Center
1:30pm Mānoa Campus, KUY 106
5:30pm Mānoa Campus, Imin Center, East-West Center
6:15pm Mānoa Campus, Law School, Moot Court Room
7:00pm Windward Campus, Windward Community College, Paliku Theatre