Excel
Excel In-Depth: PivotTable Essentials
Master the single most powerful feature in Excel. Build PivotTables from any data, add custom calculations, summarize thousands of rows in seconds, and make them interactive with slicers, timelines, and PivotCharts.
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