Microsoft Excel 2016 PowerPivot

Request more details:

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