PivotTables and Pivot Charts with Excel 2010

PivotTables are powerful! PivotTables allow you to combine, compare and summarize thousands of rows of data into just a few rows. What’s more, pivot tables are interactive. Rows and columns are easily rotated, allowing you to analyze your data from different perspectives.

Duration: 1 days

Audience

This course is designed for the user experienced with creating spreadsheets but needing or desiring to use Excel features to analyze spreadsheet data.

Prerequisites

To ensure success, students must have previous experience creating spreadsheets in Excel and the use of formulas and functions. Previous experience with PivotTables is not required.

Course Outline

Lesson 1: Understanding PivotTables

Topic 1A: Understanding Data Analysis

Topic 1B: PivotTable Benefits

Topic 1C: Survey PivotTable Uses

Topic 1D: Exploring PivotTable Features

Lesson 2: Building a PivotTable

Topic 2A: Preparing Worksheet Data

Topic 2B: Build a Basic PivotTable from an Excel List

Topic 2C: The PivotTable Wizard

Topic 2D: Refreshing the PivotTable

Lesson 3: Manipulating the PivotTable

Topic 3A: The PivotTable Toolbar

Topic 3B: Working with PivotTable Fields

Topic 3C: Displaying Details

Topic 3D: Converting a PivotTable to a Range

Topic 3E: Changing the PivotTable View

Topic 3F: Customizing PivotTable Fields

Topic 3G: Printing PivotTables

Topic 3H: Sort and Display Top Ten Data

Topic 3I: Show Pages as Worksheets

Topic 3J: Group Data by Time, Numbers & Text

Lesson 4: Performing PivotTable Calculations

Topic 4A: Changing Summary Calculations

Topic 4B: Creating Difference Calculations

Topic 4C: Creating Running Totals

Topic 4D: Creating Percentage Calculations

Topic 4B: Working with Custom Calculations

Lesson 5: Creating a PivotChart

Topic 5A: Understanding PivotChart Limitations

Topic 5B: Creating a PivotChart

Topic 5C: Modifying a PivotChart

Topic 5D: Printing a PivotChart

Lesson 6: Building More Advanced PivotTables

Topic 6A: Create a PivotTable from Multiple Ranges

Topic 6B: Create a PivotTable from External Data

What You Will Learn

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to: