Electronic Learning and Development Systems Logo


Microsoft® Office EXCEL® 2016: DATA ANALYSIS WITH Pivot tables

Course Content

(1/2 day)

Lesson 1: Preparing Data and Creating PivotTables
Prepare Data
Create a PivotTable from a Local Data Source
Create a PivotTable from Multiple Local Data Sources
Create a PivotTable from an External Data Source
Lesson 2: Analyzing Data Using PivotTables
Summarize PivotTable Data
Organize PivotTable Data
Filter PivotTable Data
Format a PivotTable
Refresh and Change PivotTable Data
Lesson 3: Working with PivotCharts
Create a PivotChart
Manipulate PivotChart Data
Format a PivotChart