713.589.2655
Houston, Texas

210.568.3904
San Antonio, Texas


Course Links

training schedule
 
  •  Houston
 
  •  San Antonio
training schedule
training schedule

Resources

training schedule
training schedule
training schedule


 

 


 

 

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: 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


Excel 365 Training Course Outlines

Excel 365 Core Features & Functions:

Excel 365 LV 1: Fundamentals of Excel
Excel 365 LV 2: Intermediate Functions & Features
Excel 365 LV 3: Advanced Tools &
Collaboration Features

Excel 365 LV 4: Advanced Functions

Excel 365 New Functions & Features:

Excel 365: New Functions & Formulas
Excel 365: New Features

Excel VBA Macros:

Excel 365 LV 5: Introduction To VBA Macros
Excel 365 LV 6: Advanced VBA Macros
 

Excel In-Depth Essentials:

Excel In-Depth: Charting Essentials
Excel In-Depth: PivotTable Essentials
Excel In-Depth: Advanced Excel Keyboarding

Excel Power Tools:

Excel Get & Transform (PowerQuery)
Excel PowerPivot Part 1
Excel PowerPivot Part 2

 

 

 
   
     

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