Irvine Training Company                               www.IrvineTrainingCo.com
Excel 325
Excel 325
All About Pivot Tables and Pivot Charts

1/2 day
This course is challenging
Prerequisites: Excel Level 1 and Level 2 or equivalents for both
click here to return
    Understand the weird naming conventions of Pivot Tables
    Hands On:  Create a Pivot Table Report the hard way with “finish”
    Hands On:  Create a Pivot Table Report the easier way
    Hands On:  Create a Pivot Table with multiple Page items
    Hands On:  Create a Pivot Table with multiple Row and/or Column items
    Hands On:  Drill down in a Pivot Table

Enhance Pivot Tables with Groupings
    See some of the limitations on grouping items
    Hands On:  Quickly group hundreds of dates by month
    Hands On:  Quickly group hundreds of dates by week
    Hands On:  Create Grouped Row or Column items
    Hands On:  Create Grouped Page items (you thought this was impossible?)

The Pivot Table Toolbar
    Hands On: Find the Pivot Table Toolbar (similar to where’s Elmo)
    Hands On: Use the Toolbar to change the contents of a pivot table
    Hands On: Use the Toolbar to change the displayed format of a pivot table
    Hands On: Use the Toolbar to refresh data

A  Quick Review of Excel Charts
    A quick review of popular standard chart types
    A quick look at custom chart types
    Hands On:  Create a Chart and place it in the same page as the table
    Hands On:  Create a Chart and place it on a separate page
    Hands On:  Put an Excel Chart into a Word document

Create Excel Pivot Charts
    Understand some of the differences between regular charts and pivot charts
    Understand the relationship between Pivot Charts and Pivot Tables
    Hands On:  Create a Pivot Chart Report using Chart layout (the hard way)
    Hands On:  Create a Pivot Chart Report the easier way
    Hands On:  Quickly add a Pivot Chart to an existing Pivot Table
    Hands On:  Change the contents of an existing Pivot Chart
    Hands On:  Change the type of an existing Pivot Chart