The Power of the Pivot: Using Pivot Tables and Charts to Simplify Data Analysis

Requiring no special pre-existing knowledge, this webinar exemplifies the power of Excel for data analysis using Pivot Tables and Charts. The presenters share examples from the University of New Mexico “Faculty Experience with COVID-19” Survey as well as a live survey of attendees, to illustrate the simplicity and accessibility of these tools. The presentation also highlights basic visualization principles to help simplify graphics and clarify data stories. 

As a result of this webinar, participants will:

  • Learn about Pivot Tables (i.e., what they are, why we use them).
  • Gain confidence to create and modify a Pivot Table.
  • Identify/locate additional Pivot Table resources.

Registration Information


  • One registration may be used in a conference room setting to share with a group of colleagues.
  • Registration closes one hour prior to the webinar.
  • Registered participants will have access to the webinar recording for 30 days following the live event.

Length/Time Commitment

1 Hour

Date(s): July 16

Time: 2:00 p.m. - 3:00 p.m. ET

Format: Live Online

Topic: Analytics

Experience Level: Beginner

Member/Non-Member Price: $59 Member/$99 Nonmember

Presenter(s): Charla Orozco, University of New Mexico; Samuel Hatch, University of New Mexico