Classroom Instructor Led Microsoft Excel Training 832-852-3196

Excel Intermediate Part 2

Overview

This is the second part of our Excel Intermediate classes, and it is focused on presenting and analyzing data using PivotTables. We cover PivotTables from the ground up teaching all the fundamental concepts. Then we go into more advanced topics like PivotTable calculations, PivotCharts, and integrating PivotTables and PivotCharts into robust dashboards. After taking this class, we highly recommend you take the third part of this class which is Excel Intermediate Part 3.

Price

$425 per Student

CPE Credits

8 CPE Credits

Prerequisites

For the best results, participants should be familiar with the topics covered in the Excel Introduction and Excel Intermediate Part 1 classes.

Duration

1 Day

Class Outline
PivotTable Fundamentals
  • Preparing the Data
  • Anatomy of a PivotTable
  • Slicing and Dicing with a PivotTable
  • Grouping Data
  • Sorting Data
  • Custom PivotTable Field Names
  • PivotTable Slicers
  • PivotCache
  • Refreshing Data
PivotTable Calculations
  • Customize Subtotals
  • Showing Values as Calculations
  • Calculated Fields
  • Calculated Items
PivotCharts
  • Creating a PivotChart
  • PivotChart Control Buttons
  • PivotChart and PivotTable Filters
PivotChart with Slicers Dashboards
  • Example Dashboards
  • Key Components of Dashboard
  • Basic Steps to Create Dashboard
  • PivotTable Cache
PivotChart with Slicers Dashboards Integrating Everything Together
  • Creating Dashboards
  • Creating Dashboards with Multiple Sheets
  • Utilizing Hyperlinks for Navigation
  • Utilizing Icons for Navigation
  • Drilling into Details of Dashboard Charts

Excel Intermediate Part 2 Schedule

In-Person Classes Schedule


Date Location Price Registration
January 16, 2025
9:00 AM to 5:00 PM
The Woodlands, TX $425.00 Class is Full. Waiting List
February 13, 2025
9:00 AM to 5:00 PM
The Woodlands, TX $425.00 Register
March 13, 2025
9:00 AM to 5:00 PM
The Woodlands, TX $425.00 Register
April 10, 2025
9:00 AM to 5:00 PM
The Woodlands, TX $425.00 Register
May 8, 2025
9:00 AM to 5:00 PM
The Woodlands, TX $425.00 Register
June 5, 2025
9:00 AM to 5:00 PM
The Woodlands, TX $425.00 Register
July 3, 2025
9:00 AM to 5:00 PM
The Woodlands, TX $425.00 Register
July 31, 2025
9:00 AM to 5:00 PM
The Woodlands, TX $425.00 Register
August 28, 2025
9:00 AM to 5:00 PM
The Woodlands, TX $425.00 Register
September 25, 2025
9:00 AM to 5:00 PM
The Woodlands, TX $425.00 Register
October 23, 2025
9:00 AM to 5:00 PM
The Woodlands, TX $425.00 Register
November 20, 2025
9:00 AM to 5:00 PM
The Woodlands, TX $425.00 Register
December 18, 2025
9:00 AM to 5:00 PM
The Woodlands, TX $425.00 Register
Live Online Classes Schedule


Date Location Price Registration
January 8, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
January 23, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
February 5, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
February 20, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
March 5, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
March 20, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
April 2, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
April 17, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
April 30, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
May 15, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
May 28, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
June 12, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
June 25, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
July 10, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
July 23, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
August 7, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
August 20, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
September 4, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
September 17, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
October 2, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
October 15, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
October 30, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
November 12, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
November 27, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Class is Full. Waiting List
December 10, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Register
December 25, 2025
9:00 AM to 5:00 PM
Live Online $425.00 Class is Full. Waiting List

Don't see a Class Date that works for you?

Let us know when you would like to take the class and we will see if we can add a new class date to our schedule.

Contact Us

Phone

832-852-3196

Office Address

2002 Timberloch Place, Suite 200

The Woodlands, TX 77380

Mailing Address

PO Box 712
Aledo, TX 76008

Communication Preference

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.