Microsoft Excel 2016 PowerPivot

This course has been superseded

We suggest the following instead:
Power BI Desktop Essentials - 1 Day course

Course 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.
1 day
Contact us for pricing
 

Prerequisites

Participants should be comfortable using the Excel 2016 interface and have a firm understanding of how Excel works and what it is used for. Understanding and experience with formulas, functions, and PivotTables is strongly recommended. No previous experience with PowerPivot is required.

Course Objectives

By the end of this course, users should be comfortable with navigating the PowerPivot application, manipulating PowerPivot data, creating PowerPivot reports, using DAX functions, and distributing PowerPivot data using a variety of different file formats.

Enable and Navigate

PowerPivot
The PowerPivot Window
The PowerPivot Ribbon Interface
PowerPivot Worksheets

Import Data from Various Data Sources

PowerPivot Data Sources
Data Feeds
The Table Import Wizard
Data Types
How to Import Data From Various Data Sources

Refresh Data from a Data Source

Data Refresh
Connections
How to Refresh Data from a Data Source

Create Linked Tables

Linked Tables
How to Create Linked Tables

Organize and Format Tables

PowerPivot Tables
Managing Tables
How to Organize and Format Tables

Create Calculated Columns

Calculated Columns
PowerPivot Formulas
How to Create Calculated Columns

Sort and Filter PowerPivot Data

Sort Options
Filter Options
How to Sort and Filter PowerPivot Data

Create and Manage Table Relationships

Table Relationships
Types of Relationships
The Create Relationship Dialog Box
The Manage Relationships Dialog Box
The Diagram View
How to Create and Manage Table Relationships

Create PivotTables

PivotTables
Flattened PivotTables
The PowerPivot Field List Pane
Creating Key Performance Indicators
How to Create a PivotTable

Create PivotCharts

PivotCharts
PivotChart Types
How to Create PivotCharts

Create Power Views

Slicers
How to Filter Data Using Slicers

Present PivotTable Data Visually

Sparklines
Types of Sparklines
The Sparkline Tools and Design Contextual Tab
Conditional Formatting
Conditional Formats
How to Present PivotTable Data Visually

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

Protect Reports

Workbook Protection
Worksheet Protection
How to Protect Reports

Save Reports in Different File Formats

File Formats
How to Save Reports in Different File Formats

Advanced ExcelExcel 2016Microsoft ExcelMicrosoft Excel 2016MS ExcelPivot TablesPowerPivotPowerPivotsExcel 365Excel 2019