Log On/Register  

855.838.5028

Excel: Data Analysis with Pivot Tables

Duration: 1 Module
Module Price: $130

Excel: Data Analysis with Pivot Tables

Module 1

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

 

Lesson 2: Analyzing Data Using PivotTables

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

Topic A: Create a PivotChart

Topic B: Manipulate PivotChart Data

Topic C: Format a PivotChart

Excel: Data Analysis with Pivot Tables

Module 1

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

 

Lesson 2: Analyzing Data Using PivotTables

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

Topic A: Create a PivotChart

Topic B: Manipulate PivotChart Data

Topic C: Format a PivotChart

Learn More
Please type the letters below so we know you are not a robot (upper or lower case):