Microsoft Excel Data Analysis with Pivot Tables

Time & Location

Contact us to Schedule Courses
Virtual Instructor Led Hands on Courses

About the Course

Microsoft® Excel’s advanced Pivot features will create Pivot Tables and Charts. Pivot Tables and Pivot Charts are tools you can use to analyze and summarize raw data.

COURSE CONTENT

PREPARING DATA AND CREATING PIVOT TABLES

• Prepare Data

• Create a Pivot Table from a Local Data Source

• Create a Pivot Table from Multiple Local Data Sources

• Create a Pivot Table from an External Data Source

ANALYZING DATA USING PIVOT TABLES

• Summarize Pivot Table Data

• Organize Pivot Table Data

• Filter Pivot Table Data

• Format a Pivot Table

• Refresh and Change Pivot Table Data

WORKING WITH PIVOT CHARTS

• Create a Pivot Chart

• Manipulate Pivot Chart Data

• Format a Pivot Chart

Register
Prix
Qté
Total
  • 4 or more Course Participants
    $299
    +$38.87 HST
    $299
    +$38.87 HST
    0
    $0
  • 2 - 3 Course Participants
    $399
    +$51.87 HST
    $399
    +$51.87 HST
    0
    $0
  • Course Calendar Date Pricing
    $299
    +$38.87 HST
    $299
    +$38.87 HST
    0
    $0
  • 1 on 1 Training
    $499
    +$64.87 HST
    $499
    +$64.87 HST
    0
    $0
Total$0

Share This Event