Excel V Pivot Tables
Scheduled Dates
| Course Name | Date | Time | Open Seats In-Person | Open Seats Online | Price | |
|---|---|---|---|---|---|---|
| Excel V Pivot Tables | 6/24/2023 (Sat) | 9AM - 12PM | 4 | 4 | $95.00 | Register |
| Excel V Pivot Tables | 8/2/2023 (Wed) | 9AM - 12PM | 5 | 4 | $95.00 | Register |
| Excel V Pivot Tables | 8/3/2023 (Thu) | 9AM - 12PM | 5 | 4 | $95.00 | Register |
Need a Different Date?
Do the current classes not work for your schedule, or are no classes currently available? No problem! Visit our Schedule a Class page and choose an available day and time or call us at (909) 981-6331 for more information.
Topics Include:
Pivot Table Basics
- Creating A Pivot Table
- Laying out a New Pivot table On the Worksheet
- Adding Sub-Details to an Item
- Managing Pivot Tables
- Grouping Pivot Table Items
- Displaying Pivot Table Details
- Creating a Slicer
Pivot Table Layouts
- Adding/Deleting Subtotals
- Grouping Text Fields
- Inserting a Chart
Advanced Features
- Adding a Calculated Percentage Field
- Displaying the Top/Bottom Number of Items
- Adding a Calculated Field
- Adding a Data Field That Calculates the Difference Between Two Data Fields
- Adding a Data Field That Calculates Percentages from One Item of the Row Field
- Adding a Data Field That Calculates
- Automatically separating data with pivot tables