Houston, Texas

San Antonio, Texas

training schedule Course

Houston Schedule
San Antonio Schedule


Better Business Bureau






Microsoft® Office Excel: PivotTables

Training Course Content (3.5 hours)

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.

Lesson 1: Inserting a PivotTable

Topic 1A: Insert a Pivot from Worksheet Data
Topic 1B: Insert Pivot from Table
Topic 1C: Insert Pivot from External Data 
Topic 1D: Insert from Blank Worksheet

Lesson 2: Modifying a PivotTable

Topic 2A: Sort a Pivot
Topic 2B: Move and Delete Pivot
Topic 2C: Use Pivot Drop Zones
Topic 2D: Rearrange Pivot Fields

Lesson 3: Customizing a PivotTable

Topic 3A: PivotTable Tools Menu 
Topic 3B: PivotTable Options
Topic 3C: Field Settings
Topic 3D: Format a Pivot

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

Lesson 6: Creating a PivotChart

Topic 6A: Create PivotChart
Topic 6B: Modify PivotChart

Appendix: New PivotTable Features

Topic A: Recommended PivotTables
Topic B: PivotTables from Multiple Tables
Topic C: Filter by Timeline
Topic D: Use Multi-Slicers

Excel 2016 Training Class Outlines:

Excel 2016 Level 1: Fundamentals of Excel
Excel 2016 Level 2: Intermediate Functions and Features
Excel 2016 Level 3: Advanced Tools and Collaboration Features
Excel 2016 Level 4: Advanced Formulas and Functions
Excel 2016 Level 5: Introduction To VBA Macros
Excel 2016 Level 6: Advanced VBA Macros




                                                         |   Home   |   Email Us   |   Privacy Notice   |   Site Map   |