Excel Intermediate Part 2
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.
$425 per Student
8 CPE Credits
For the best results, participants should be familiar with the topics covered in the Excel Introduction and Excel Intermediate Part 1 classes.
1 Day
- 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
- Customize Subtotals
- Showing Values as Calculations
- Calculated Fields
- Calculated Items
- Creating a PivotChart
- PivotChart Control Buttons
- PivotChart and PivotTable Filters
- Example Dashboards
- Key Components of Dashboard
- Basic Steps to Create Dashboard
- PivotTable Cache
- 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 |
April 23, 2025 9:00 AM to 5:00 PM |
Hurst, TX | $425.00 | Register |
May 8, 2025 9:00 AM to 5:00 PM |
Hurst, TX | $425.00 | Class is Full. Waiting List |
May 21, 2025 9:00 AM to 5:00 PM |
Hurst, TX | $425.00 | Register |
June 5, 2025 9:00 AM to 5:00 PM |
Hurst, TX | $425.00 | Register |
June 18, 2025 9:00 AM to 5:00 PM |
Hurst, TX | $425.00 | Register |
July 3, 2025 9:00 AM to 5:00 PM |
Hurst, TX | $425.00 | Register |
July 16, 2025 9:00 AM to 5:00 PM |
Hurst, TX | $425.00 | Register |
July 31, 2025 9:00 AM to 5:00 PM |
Hurst, TX | $425.00 | Register |
August 13, 2025 9:00 AM to 5:00 PM |
Hurst, TX | $425.00 | Register |
August 28, 2025 9:00 AM to 5:00 PM |
Hurst, TX | $425.00 | Register |
September 10, 2025 9:00 AM to 5:00 PM |
Hurst, TX | $425.00 | Register |
September 25, 2025 9:00 AM to 5:00 PM |
Hurst, TX | $425.00 | Register |
October 8, 2025 9:00 AM to 5:00 PM |
Hurst, TX | $425.00 | Register |
October 23, 2025 9:00 AM to 5:00 PM |
Hurst, TX | $425.00 | Register |
November 5, 2025 9:00 AM to 5:00 PM |
Hurst, TX | $425.00 | Register |
November 20, 2025 9:00 AM to 5:00 PM |
Hurst, TX | $425.00 | Register |
December 3, 2025 9:00 AM to 5:00 PM |
Hurst, TX | $425.00 | Register |
December 18, 2025 9:00 AM to 5:00 PM |
Hurst, TX | $425.00 | Register |
December 31, 2025 9:00 AM to 5:00 PM |
Hurst, TX | $425.00 | Class is Full. Waiting List |
Live Online Classes Schedule
Date | Location | Price | Registration |
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.
Public Classes
Contact Us
Phone
817-841-9560
Office Address
227 NE Loop 820
Suite 161
Hurst, TX 76053
Mailing Address
Aledo, TX 76008
For common questions, the chatbot located in bottom right of screen can answer most common questions about pricing, classes, and many other topics.