Computer Training Classes
 
Excel Pivot Tables & Pivot Charts - 3.5 hours - $99

This class is intended for:

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

PIVOT TABLES:

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)
Slicers

PIVOT CHARTS:

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