Use PivotTables to Organize, Summarize and Analyze Data (VOMC)

Pre-requistes:

A good understanding of Excel is needed

Knowledge Level:

Intermediate

Major Topics:

• Overview of PivotTables
• Creating a PivotTable
• Rearranging a PivotTable
• Modify a PivotTable
• Sorting and Grouping with a PivotTables
• PivotTable Calculations
• Auto Formatting a PivotTable
• PivotTable Charts

Learning Objectives:

• Identify a PivotTable and its components and defaults
• Identify the steps needed to create a PivotTable
• Recognize the steps needed to modify and format a PivotTable
• Recognize how to use and modify slicers
• Recognize how to create fields, items and calculations in a PivotTable
• Identify how to change and or update underlying data
• Recognize how to create a PivotTable Charta and how it differs from a regular chart
• Identify methods to update a PivotTable and locate its data source

Designed For:

This course is designed for users of Excel 2019 and Microsoft 365 users but Excel 2010 and 2013 users should experience little difficulty. This course is NOT intended for 2007 or earlier versions of Excel. It assumes a familiarity with Excel and is intended for an intermediate Excel user.