Microsoft® Office Excel® 2016/2019: Data Analysis with PivotTables (Self-Paced)

Excel® 2016, Excel® 2019, Self-Paced

Current Status

Not Enrolled

Price

250.00

Get Started

This course is currently closed

091066SE (Rev 1.01), Digital Courseware

Course Content

Expand All

Lesson 1: Preparing Data and Creating PivotTables 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

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 an External Data Source

Lesson 2: Analyzing Data by Using PivotTables 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Topic A: Summarize 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 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Topic A: Create a PivotChart

Topic B: Manipulate PivotChart Data

Topic C: Format a PivotChart