Microsoft Excel 2010 PivotTables

1 day

Course Description

You will create and analyze PivotTable data.

Target Student

This course is meant for people with a sound working knowledge of Microsoft Excel and general computer proficiency.

Prerequisites

Before starting this course, students are recommended to take the following Element K courses or have equivalent knowledge: Microsoft® Office Excel® 2010: Level 1 and Microsoft® Office Excel® 2010: Level 2.

Course Objectives

Upon successful completion of this course, students will be able to:

  • Build a PivotTable.
  • Analyze data using PivotTables.
  • Present PivotTable data visually.

Course Outline

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