Excel
Excel Pivot Table
Build practical, job-ready Excel skills with hands-on, instructor-led training focused on real business tasks.
CPE Eligible - visit /cpe for details.CPE page →
Course objective
In this course, students will create and analyze PivotTable data.
Prerequisites
Before starting this course, students are recommended to take the following courses or have equivalent knowledge: Microsoft® Office Excel® Level 1 and Level 2. Contact us to discuss if this class is right for you.
Course outline
Lesson 1: Building a PivotTable
- Topic 1A: Insert a PivotTable
- Topic 1B: Create a PivotTable from External Data
- Topic 1C: Customize a PivotTable
- Topic 1D: Refresh a PivotTable
Lesson 2: Analyze Data using PivotTables
- Topic 2A: Create Custom Calculations
- Topic 2B: Restructure a PivotTable
- Topic 2C: Group and Sort a PivotTable
- Topic 2D: Summarize Values by a Variety of Methods
Lesson 3: Presenting PivotTable Data Visually
- Topic 3A: Format A PivotTable
- Topic 3B: PivotTable Options
- Topic 3C: Present Data in a Pivot Chart
- Topic 3D: Print PivotTables and Pivot Charts
Lesson 4: Analyzing with a PivotTable
- Topic 4A: Use Multiple Value Fields
- Topic 4B: Create Calculated Fields
- Topic 4C: Use Value Field Properties
- Topic 4D: Group Pivot Data
Lesson 5: Filtering a PivotTable
- Topic 5A: PivotTables from Multiple Tables
- Topic 5B: Filter by Grouped Data
- Topic 5C: Filter by Slicers and Timeline
Lesson 6: Creating a Pivot Chart
- Topic 6A: Create Pivot Chart
- Topic 6B: Modify Pivot Chart