Computer Training Classes

Excel Pivot Tables & Pivot Charts - 1 Day - $159

This class is intended for:

PC/Windows Users: Excel 2010-2013-2016-2019-365
Version Used in Class: Excel 2016
Course Materials: FREE
Certificate of Completion (optional): $5
Course Length: 1 Day


Create a Pivot Table
Layout & Design
Move a PivotTable
Filter a Pivot Table
Sort a Pivot Table
Expand & Collapse Columns
Grand Totals and Subtotals
Functions (Sum, Average, Min, Max)
Change Data Source (change range of cells, use Access as data source, etc.)
Append (Add) Data to a Pivot Table
Convert Underlying Data Into a Table
Combine Multiple Data Sources
Use GetPivotData Function
Refresh Data
Group by Dates (Week, Month, Year)
Calculated Fields (Create, Edit, Delete, List Formulas, Change Solve Order)


Layout & Design
Chart Styles & Formatting
Change Chart Type
Filtering Options
Sorting Options

excel classes san diego

Contact Us Map / Directions Schedule Home Page View Non-Mobile Site