Skip to Main Content

Microsoft Excel 2016 PowerPivot  (MO16EX401)

Time: 9AM - 4PM Eastern Time (ET)
Duration: 1 Day

Compatible with 2013

Description:

This course takes a look at the free PowerPivot add-in for Microsoft Excel 2016. Its aim is for all users of PowerPivot to get a good grasp of how its features are set and how it works. It covers interface features, techniques for manipulating PowerPivot data, how to create PowerPivot reports, the structure of DAX functions, and ways to distribute PowerPivot data.

Prerequisites:

MO16EX301—Microsoft Excel 2016 - Part Three or equivalent knowledge or experience is mandatory.

Public Class Schedule

Location Language Date Price Register
Ottawa English January 9 $ 435.00
Web-based(Opens in new window) English January 9 $ 435.00
Ottawa English February 13 $ 435.00
Web-based(Opens in new window) English February 13 $ 435.00
Ottawa English March 12 $ 435.00
Web-based(Opens in new window) English March 12 $ 435.00
Ottawa English April 9 $ 435.00
Web-based(Opens in new window) English April 9 $ 435.00
Ottawa English May 7 $ 435.00
Web-based(Opens in new window) English May 7 $ 435.00
Ottawa English June 4 $ 435.00
Web-based(Opens in new window) English June 4 $ 435.00

We're Here to Help

Don't see the dates you need? Call us at 888.484.2933 or Tell Us What You Need.

Course Outline

  • Getting Started with PowerPivot
    • This initial lesson shows students how to: explore the PowerPivot application, import data from sources, refresh data, and create linked tables.
  • Manipulating PowerPivot Data
    • Students will then move on to learning how to: organize and format tables, create calculated columns, sort and filter PowerPivot data, and create and manage table relationships.
  • Creating PowerPivot Reports
    • In this lesson, students build upon what they have learned by being shown how to: create PivotTables and PivotCharts, filter data using slicers, and present PivotTable data visually.
  • Using DAX Functions in PowerPivot
    • Here, students will learn how to: manipulate PowerPivot data using DAX functions, extract data from tables using functions, and work with time dependent data.
  • Distributing PowerPivot Data
    • This course wraps up with a look at how to protect reports and how to save reports in different file formats.

Private training is available for this course.

Call us at 1-888-484-2933 to learn more about our flexible scheduling options or complete our Information Request Form.

© 2019 Eliquo, Inc. All rights reserved.

Back to Top