PPPQ16: Power Pivot and Power Query for Excel 2016

Home / PPPQ16: Power Pivot and Power Query for Excel 2016

This course teaches students the add-ins that expand and combine the features and capabilities of Excel. Students will learn PowerPivot, Power Query, Power View, 3D maps and their features. Students will also learn how to import, manipulate and work with large amounts of data from a variety of data sources both inside and outside Excel. Students will learn the techniques for manipulating querying data, the structure of DAX functions, ways to distribute and visualize data using Pivot Charts, Slicers, Sparklines, Timelines, Power View and 3D maps.

Course Length: 2 day(s)

Course Price: $790 CAD

Available Course Formats:

  • In-class
  • Instructor Led Online

Enroll Now

Course: PPPQ16: Power Pivot and Power Query for Excel 2016

  • Getting Started with PowerPivot
    • Enable and Navigate
    • 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
  • Manipulate PowerPivot Data Using DAX Functions
    • Measures
    • DAX Functions
    • DAX Variables
    • Aggregate Functions
    • How to Manipulate PowerPivot Data Using DAX Functions
  • Extract Data from Tables Using Functions
    • Filter Functions
    • How to Extract Data From Tables Using Functions
  • Work with Time Dependent Data
    • Time Intelligence Functions
    • Create a Date Table
    • How to Work with Time Dependent Data
    • Distributing PowerPivot Data
  • Power Query and When to Use It
    • (NOTE: Power Query is known as Get & Transform in Excel 2016. Information provided here applies to both.)
  • Data Sources
    • Connect to a web data source
    • Connect to a spreadsheet
    • Connect to a database
  • Organizing Data
    • Build repeatable processes to filter, clean, aggregate, and transform your data.
    • Shape data in the subject table
    • Remove Columns
    • Replace values
    • Filter values in a column
  • Queries
    • Name a query
    • Load the query to a worksheet
  • Create PivotTables
    • Flattened PivotTables
    • The PowerPivot Field List Pane
    • Creating Key Performance Indicators
  • Bringing it all together with visualizations
    • Create PivotCharts
    • Create Power Views
    • Create 3D Maps
    • Filter Data Using Slicers
    • Create Sparklines
    • Create Timelines
    • Conditional Formatting
    • Creating a dashboard


This course is designed for students who are experienced with Excel 2016 and want to advance their skills in Power Pivot and Power Querry applications.


  • Experience using the Excel 2016 interface
  • Understanding and experience with formulas, functions, and PivotTables is strongly recommended

Instructor Led In Classroom

Newcomp can directly deliver courses through the use of in-class training facilities.

Currently,  in-class courses are offered in Markham, Ottawa, Vancouver, Halifax, and Edmonton. Please note that classes can be added to new areas based on demand.

Instructor Led Online

Students receive the same quality as an in-class course, with a live instructor and the ability to participate in hands-on labs through real-life examples

ILOs help cut costs by reducing time and travel as they can be taken from home or the office and require only the use of a computer, high-speed wired internet and a headset.