In this whirlwind hands-on introduction to visualizing data with pivot tables and pivot charts, you will use a carefully crafted Excel instructional file to create a pivot table and pivot chart. You will then practice changing the look of your pivot table/chart and working with built-in Excel features to display and filter data in your table and chart. This beginner-friendly workshop covers creating, formatting, filtering, and configuring pivot tables and pivot charts. Prerequisite: Excel 2016+ for desktop (Windows) or a really recent copy of Excel (Mac). 

After attending or viewing the workshop session, you will be able to: 

• Identify the data structures conducive to creating pivot tables and pivot charts.  
• Build pivot charts/tables and customize the look of your charts/tables using the contextual design ribbon. 
• Modify pivot table/chart data outputs using the PivotChart or PivotTable Fields menu, and filter data outputs with the help of the insert slicer tool, the insert timeline tool, the group selection tool, and the filters area. 

Location: Rowe Building, Room 3080.