Use Pivot Tables to Organize, Summarize and Analyze Data
SKU: 02-075-01-CPE
Credit Hours: 5
Level: Overview
CPE Category: Computer Software and Applications-Non Technical
Requires Prerequisites or Advanced Preparation: No
Delivery Method: PDF
Instructor: Patricia McCarthy, MBA
Course Description:
This course will discuss how to manage and organize data more effectively and transform it into information.
At the end of this course, students will be able to:
- Identify a PivotTable and its components and defaults
- Identify the steps needed to create a Pivot Table
- Recognize the steps needed to modify and format a pivot table
- Recognize how to use and modify slicers
- Recognize how to create fields, items and calculations in a Pivot Table
- 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 pivot table and locate its data source