Excel 2010 Pivot Tables

Course Length

Three hours

Prerequisites

Excel 2010 Introduction or equivalent experience

Course Description

Participants will learn how to create and use PivotTable reports to quickly summarize and manipulate large amounts of data. After creating PivotTable reports, we will explore PivotCharts – a flexible chart based on the data in a PivotTable.

Course Topics

  • Create a blank PivotTable report from an Excel list or table
  • Work with the PivotTable Field List window
  • Change the view of the PivotTable Field List window
  • Add, remove, and rearrange fields
  • Sort data
  • Refresh a PivotTable report
  • Change the data source
  • Move, clear, and delete a PivotTable report
  • Change the number format of a data field
  • Change the summary function and/or custom calculation for a value field
  • Insert, edit, and delete calculated fields
  • Insert, edit, and delete calculated items
  • Display or hide subtotals and grand totals
  • Change the PivotTable style
  • Expand or collapse levels of detail
  • Display details for a value field in a table on a new worksheet
  • Filter data and use report filters
  • Show report filter pages
  • Filter labels or numbers
  • Create, format, and delete slicers
  • Group and ungroup in a PivotTable
  • Create and modify PivotCharts
  • Change the PivotTable report layout
  • Merge and center cells
  • Insert or remove blank lines
  • Show or hide field headers
  • Print sections of a PivotTable report on separate pages
  • Set print titles in a PivotTable
  • Print expand/collapse buttons
  • Filter dates or times in a PivotTable
  • Filter by selection in a PivotTable
  • Filter labels for top or bottom numbers in a PivotTable
  • Manually group selected items in a PivotTable
  • List formulas used in a PivotTable
  • View PivotTable and PivotChart specifications and limits

What Participants Receive

Each participant receives a guide containing step-by-step instructions and practice exercises.