In this one hour online short course you will learn how to work with Excel Pivot Tables and Pivot Charts. Excel Pivot Tables are used to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. Pivot Charts are a great way to add data visualizations to your data. Topics will include learning how to create a Pivot Table; rearrange and then format the data; set filters including the use of Slicers and Timelines; and finally creating a Pivot Chart of the data in the Pivot Table. This workshop is aimed at beginner users of Pivot Tables.
Prerequisite: Completion of Excel Getting Started or equivalent knowledge.
Length: 1 hour
Offered at NO CHARGE to all University of Illinois (Urbana campus) faculty/staff.