Excel Level 2 - Pivot Tables (online)

For employees of Duke University and DUHS. Continuing Education Credits (CEUs): 0.2
Duration: 2 hours 15 minutes
Learn how to analyze and summarize data, and create reports with Pivot Tables. Objectives:

* Prepare the proper data structure
* Create a pivot table
* Add and remove fields to a pivot table
* Change layouts and create different perspectives
* Update data and refresh the pivot table report
* Filter data
* Add page fields and display them on separate sheet tabs
Prerequisites: Excel Level 1 or equivalent knowledge.

Format: Online course via WebEx. Download this free software through the Duke OIT website: https://oit.duke.edu/help/articles/kb0014282 and contact OIT if you have any questions (919) 684-2200. Two days before the class, the instructor will contact participants by email to provide login instructions.