Excel 2007

Pivot Tables and Pivot Charts

½ Day

Learn How to

Create pivot tables to analyse data

Understand the potential data sources for a pivot table

Group data based on numeric value, date, or personal choice

Subtotal the groups

Format the pivot table report

Create pivot charts

Pre-Requisites

Delegates should be familiar with working in Excel as can be gained from our Excel 2007 Core Skills course.

Understanding Pivot Tables

What is a Pivot Table?

Pivot Table Definitions

Pivot Table Source Data

 

Creating Pivot Tables

Creating a Pivot Table

Layout of a Pivot Table (Row, Column, Data, Page)

Pivot Table Wizard, Toolbar, Options

 

Managing Pivot Tables

Refreshing a Pivot Table?

Modifying a Pivot Table

Swapping PivotTable Row and Column Headings

Grouping in Pivot Tables

Grouping Selected Items

Grouping Numeric Items Into Ranges

Grouping a Date or Time in a Range

Subtotalling

 

Formatting PivotTable Reports

Indented formats

Non-Indented formats

 

Creating Pivot Charts

What is a Pivot Chart?

Creating a Pivot Chart