Summary
Excel PivotTables
This is a 2-hour virtual instructor-led class, and in celebration of our 30th Anniversary, it will be held for $30!
Outline
-
Lesson 1: Preparing Data and Creating PivotTables
- Topic A: Prepare Data
- Topic B: Create a PivotTable from a Local Data Source
- Topic C: Create a PivotTable from Multiple Local Data Sources
- Topic D: Create a PivotTable from External Data Source
-
Lesson 2: Analyzing Data by Using PivotTables
- Topic A: Summarize a PivotTable Data
- Topic B: Organize PivotTable Data
- Topic C: Filter PivotTable Data
- Topic D: Format a PivotTable
- Topic E: Refresh and Change PivotTable Data
-
Lesson 3: Working with PivotCharts
- Topic A: Create a PivotChart
- Topic B: Manipulate PivotChart Data
- Topic C: Format a PivotChart
Course Schedule
DATES
LOCATION
START
END
STATUS
**Indicates a course that is only a half day.