Excel 2010 – PivotTables

Working World provides training on many of the leading software programs and applications.  To book your next computer training course please call our main office number at (800) 463-3074.

Course Length

  •  0.5 (half) day

Objectives

  • build a PivotTable.
  • analyze data using PivotTables.
  • present PivotTable data visually.

Prerequisites

  • Excel 2010 – Level 1 and Excel 2011 – Level 2

Content

Building a PivotTable

  • Insert a PivotTable
  • Create a PivotTable Based on External Data
  • Categorize PivotTable Data
  • Customize a PivotTable

Analyzing Data Using PivotTables

  • Create Custom Calculations in a PivotTable
  • Restructure a PivotTable

Presenting PivotTable Data Visually

  • Format a PivotTable
  • Present a PivotTable in a PivotChart
  • Print PivotTables and PivotCharts

 

 
"With the service agreement with Working World, we don’t worry about the day-to-day maintenance of our computers. We are pleased with the managed services which ensure that updates occur on a regular basis, there is daily monitoring of our system, and backups are not only taking place but are tested for accuracy. Staff are dedicated to resolving our issues." - Jane Angus, Contact Brant