Science at the heart of medicine

Faculty Development Event

Excel III: Analyzing Data with Pivot Tables

Date: Wednesday, June 20, 2018

Time: 9:00 AM To 11:00 AM

Location: Forchheimer 119N

Event Description:
Pivot Tables are one of the most powerful analytical tools featured in Microsoft Excel 2016 enabling users to analyze and summarize large quantities of data. This workshop is the last in the Excel series and will allow participants to master the intricacies of Pivot tables and charts as they will be introduced to the concepts, techniques and powerful features of this mysterious excel tool. If you manage a lot of data in Excel, you will not want to miss this workshop! At the end of this hands-on workshop, participants will be able to: -Create a basic pivot table -Customize a pivot table -Group, sort and filter data -Drill down into the underlying data -Create and customize a pivot chart

Target Audience:
All Faculty. Due to space constraints, participation in workshops sponsored by the Office of Faculty Development is limited to individuals with faculty appointments at the medical school. Thank you for understanding.

Speaker:
Martin Penn, CPA

Directions:
Click here for directions to this event

Register for this event