Font size:

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



Highlights:

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

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

Prerequisites:

Previous experience with Office 2010 and Intermediate Excel skills.



Audience:

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


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
Find a class and register in three easy steps:
  • 1. Select Location:
  • 2. Select Date Range:
    to
  • 3. Select Class Type:
    • All Types
    • C Classroom
    • V Virtual Live
    • Cv In-Class Virtual
    • O Online
ON Mississauga3/29/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002463660
MB Winnipeg3/29/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002463639
BC Victoria3/29/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002463645
AB Edmonton3/29/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002463654
AB Calgary3/29/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002463652
BC Vancouver3/29/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002463637
Virtual Live3/29/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>1 day295.002460974
NS Halifax3/29/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002463666
ON Ottawa3/29/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002463641
QC Montreal3/29/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002463668
ON TORONTO3/29/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002463633
ON Mississauga5/10/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002463662
AB Edmonton5/10/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002463656
NS Halifax5/10/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002463658
BC Victoria5/10/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002463648
Virtual Live5/10/2018 9:00:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>1 day295.002460978
QC Montreal5/10/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002463664
ON TORONTO5/10/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002463635
AB Calgary5/10/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002463646
ON Ottawa5/10/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002463629
MB Winnipeg5/10/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002463627
BC Vancouver5/10/2018 9:00:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>1 day355.002463643
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 22 of 22 items