EXC10PT: Microsoft Excel 2010 Pivot Table Workshop - Level 3 / Advanced

Start Date Time Days Price GTR Availability
October 02, 2017 09:00 (EST) 1 $355.00 Register
October 02, 2017 09:00 (EST) 1 $355.00 Register
November 20, 2017 09:00 (EST) 1 $355.00 Register
November 20, 2017 09:00 (EST) 1 $355.00 Register

Duration: 1 Day

Course Description

Students will learn how to use PivotTables to summarize large amounts of data and analyze large amounts of data. They will learn about the available tools that are available to assist with this task.

Prerequisites

Previous experience with Office 2010 and Intermediate Excel skills.

Course Objectives

Upon successful completion of this course, students will be able to build a PivotTable. Analyze data using PivotTables. Present PivotTable data visually.

Audience

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

Course Content

Pivoting Data
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