Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Microsoft Excel 2010 PivotTable Workshop - Level 3 / Advanced

Learn to create PivotTables in Excel 2010 to summarize, analyze and present large amounts of data.

GK# 6742

Course Overview

TOP

Students will learn how to use PivotTables and the available tools to assist with summarizing and analyzing large amounts of data.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP

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

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

Outline

TOP
Viewing outline for:

Classroom Live Outline

Getting Started with PivotTables

  • What is a PivotTable?
  • Creating a PivotTable
  • Using the PivotTable Tools Tabs
  • Adding and Removing Data with the Field List
  • Changing the Field List Layout
  • Pivoting Data

Working with PivotTable Data

  • Expanding and Collapsing Data
  • Filtering Data
  • Sorting Data
  • Grouping Data
  • Refreshing Data
  • Editing the Data Source

Formatting a PivotTable

  • Modifying Fields and Labels
  • Modifying Values
  • Using the Layout Group on the Design Tab
  • Applying a Style to a PivotTable
  • Changing PivotTable Style Options
  • Manually Formatting a PivotTable
  • Using the PivotTable Options Dialog

Using the Classic PivotTable Layout

  • Creating an Empty (Classic) PivotTable Frame
  • Switching an Existing PivotTable to a Classic Layout
  • Adding Data
  • Pivoting Data

Advanced PivotTable Tasks

  • Creating a PivotTable Based on External Data
  • Refreshing External Data
  • Creating a Slicer
  • Using the Slicer Tools Tab

Using PowerPivot

  • System Requirements
  • Downloading and Installing
  • Importing Access Data
  • Importing Excel Data
  • Integrating Data with Relationships
  • Creating a PivotTable with PowerPivot Data

Charting Pivoted Data

  • Getting Started with PivotCharts
  • Creating a PivotChart from Scratch
  • Creating a PivotChart from Existing Data
  • Adding Data to your Chart
  • Pivoting Data

Formatting a PivotChart

  • Renaming Fields
  • Changing the Chart Type
  • Applying a Chart Style
  • Manually Formatting Chart Elements
  • Changing the Layout of Chart Elements

Advanced PivotChart Tasks

  • Creating a PivotChart Based on External Data
  • Creating a Slicer
  • Creating a PivotTable and PivotChart from a Scenario
  • Creating PivotCharts with PowerPivot Data

Additional Tools for Managing Large Amounts of Data

  • Outlining and Grouping Data
  • Using Automatic Outlining
  • Displaying and Collapsing Levels
  • Grouping Data Manually
  • Creating Subtotals

Prerequisites

TOP

Previous experience with Office 2010 and Intermediate Excel skills as provided in the following course:

Who Should Attend

TOP

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

Resources

TOP
Found the Pivot Table course to be extremely beneficial. The instructor was knowledgeable, friendly, and patient with all students.
Sabrina P , Ministry of Education
Training Exclusives

This Office course comes with extended access to the following benefits:

  • Concept Training
  • ClipTraining Video Library
  • Free Refreshers
  • Online Course Content
Learn More >
Course Delivery

This course is available in the following formats:

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 1 day

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 1 day

Request this course in a different delivery format.
Enroll