Skip to content

Learn to create and analyze PivotTable data.

Select a date below

Categories:
Topics:

Dates are listed in Pacific Time Zone

= Guaranteed to run date

Description

Print Friendly, PDF & Email

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

Additional information

Length

3.5 Hours

Guaranteed to run

Yes