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: PowerPivot

New – Learn how to import data from various sources and create a dynamic report.

GK# 6741

$355 - $790 CAD

Enroll Request Group Training

Course Overview

TOP

Students will make use of the PowerPivot add-in to import data from various sources and create a dynamic report. You learn how to manipulate data in a PowerPivot, how to create reports, use DAX functions, and how to distribute the results.

Schedule

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

$

What You'll Learn

TOP

Students will learn how to:

  • Gett Started with PowerPivot
  • Manipulate PowerPivot Data
  • Create PowerPivot Reports
  • Use DAX Functions in PowerPivot
  • Distribute PowerPivot Data

Outline

TOP
Viewing outline for:

Virtual Classroom Live Outline

Getting Started with PowerPivot

  • Explore the PowerPivot Application
  • Import Data from Various Data Sources
  • Refresh Data from a Data Source
  • Create Linked Tables

Manipulating PowerPivot Data

  • Organize and Format Tables
  • Create Calculated Columns
  • Sort and Filter PowerPivot Data
  • Create and Manage Table Relationships

Creating PowerPivot Reports

  • Create a PivotTable
  • Create PivotCharts
  • Filter Data Using Slicers
  • Present PivotTable Data Visually

Using DAX Functions in PowerPivot

  • Manipulate PowerPivot Data Using DAX Functions
  • Extract Data from Tables Using Functions
  • Work with Time Dependent Data

Distributing PowerPivot Data

  • Protect Reports
  • Save Reports in Different File Formats

Who Should Attend

TOP

This course is for students with a sound working knowledge of Microsoft Excel 2010 and general computing proficiency, including those who will be using Excel to make business decisions.

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

Classroom Live

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

Duration: 1 day

Virtual Classroom Live

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

Duration: 1 day

Request this course in a different delivery format.
Enroll