Excel – Data Analysis with PivotTables

Description

Overview:

In this course you will use the advanced PivotTable functionality in Excel to analyze raw data. You will learn to prepare data for PivotTable reporting and create PivotTables from various data sources, analyze data by using PivotTables, and work with PivotCharts.

Prerequisite(s):

Excel Level 2

Audience:

Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables.

Outline:

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 by 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