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 |
May 8, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Class is Full. Waiting List |
May 22, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
June 5, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
June 19, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
July 3, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
July 17, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
July 31, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
August 14, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
August 28, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
September 11, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
September 25, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
October 9, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
October 23, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
November 6, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
November 20, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
December 4, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
December 18, 2024 9:00 AM to 5:00 PM |
Fort Worth, TX | $425.00 | Register |
Live Online Classes Schedule
Date | Location | Price | Registration |
May 8, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
May 22, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
June 5, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
June 19, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
July 3, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
July 17, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
July 31, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
August 14, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
August 28, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
September 11, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
September 25, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
October 9, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
October 23, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
November 6, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
November 20, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
December 4, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
December 18, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
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
2601 Scott Avenue
Suite 107
Fort Worth, TX 76103
Mailing Address
Aledo, TX 76008