Skip Navigation LinksHome > Training > Technology Training > Class Catalog

Excel 2010: Intermediate - PivotTables & PivotCharts

This course will focus on analyzing data using Excel's pivot table feature, a very powerful tool that allows users to extract summary information from a spreadsheet and further analyze its contents. Pivot tables are used for reporting of:
-financial data
-student information within a department or program
-or customer data.

For example, a pivot table can quickly summarize how many students (or customers) attended a program by gender, age range, ethnicity, etc.

Topics Include
Sorting data
Using autofilter and advanced filters
Creating and revising pivot tables
Adding pivot table fields
Changing a pivot table layout
Creating a pivot chart report
Changing chart features