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