Microsoft Excel 2016 PowerPivot
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
PowerPivotThe PowerPivot Window
The PowerPivot Ribbon Interface
PowerPivot Worksheets
Import Data from Various Data Sources
PowerPivot Data SourcesData Feeds
The Table Import Wizard
Data Types
How to Import Data From Various Data Sources
Refresh Data from a Data Source
Data RefreshConnections
How to Refresh Data from a Data Source
Create Linked Tables
Linked TablesHow to Create Linked Tables
Organize and Format Tables
PowerPivot TablesManaging Tables
How to Organize and Format Tables
Create Calculated Columns
Calculated ColumnsPowerPivot Formulas
How to Create Calculated Columns
Sort and Filter PowerPivot Data
Sort OptionsFilter Options
How to Sort and Filter PowerPivot Data
Create and Manage Table Relationships
Table RelationshipsTypes of Relationships
The Create Relationship Dialog Box
The Manage Relationships Dialog Box
The Diagram View
How to Create and Manage Table Relationships
Create PivotTables
PivotTablesFlattened PivotTables
The PowerPivot Field List Pane
Creating Key Performance Indicators
How to Create a PivotTable
Create PivotCharts
PivotChartsPivotChart Types
How to Create PivotCharts
Create Power Views
SlicersHow to Filter Data Using Slicers
Present PivotTable Data Visually
SparklinesTypes 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
MeasuresDAX Functions
DAX Variables
Aggregate Functions
How to Manipulate PowerPivot Data Using DAX Functions
Extract Data from Tables Using Functions
Filter FunctionsHow to Extract Data From Tables Using Functions
Work with Time Dependent Data
Time Intelligence FunctionsCreate a Date Table
How to Work with Time Dependent Data
Protect Reports
Workbook ProtectionWorksheet Protection
How to Protect Reports
Save Reports in Different File Formats
File FormatsHow to Save Reports in Different File Formats
Advanced ExcelExcel 2016Microsoft ExcelMicrosoft Excel 2016MS ExcelPivot TablesPowerPivotPowerPivotsExcel 365Excel 2019