Excel Pivot Table

Full Day1 DayVersion 365Official CPE Provider

Build practical, job-ready Excel skills with hands-on, instructor-led training focused on real business tasks.

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

6 lessons · 21 topics

1Lesson 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

2Lesson 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

3Lesson 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

4Lesson 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

5Lesson 5: Filtering a PivotTable

Topic 5A: PivotTables from Multiple Tables
Topic 5B: Filter by Grouped Data
Topic 5C: Filter by Slicers and Timeline

6Lesson 6: Creating a Pivot Chart

Topic 6A: Create Pivot Chart
Topic 6B: Modify Pivot Chart

Excel Solutions Team
Kirkwood Tower, 11757 Katy Fwy, Suite 1300, Houston, TX 77079
(713) 589-2655 · contactinfo@excelsolutionsteam.com · excelsolutionsteam.com

Official CPE Provider (TX State Board of Public Accountancy)
BBB Accredited since 2006 · 20+ years training Houston professionals