Course outline for
Microsoft Excel 2016 PowerPivot

About This Course

Course Prerequisites

Course Overview

Course Objectives

How To Use This Book

Lesson 1:
Getting Started with PowerPivot

PowerPivot

The PowerPivot Window

The PowerPivot Ribbon Interface

PowerPivot Worksheets

Activity 1-1

PowerPivot Data Sources

Data Feeds

The Table Import Wizard

Data Types

How to Import Data From Various Data Sources

Activity 1-2

Data Refresh

Connections

How to Refresh Data from a Data Source

Activity 1-3

Linked Tables

How to Create Linked Tables

Activity 1-4

Summary

Review Questions

Lesson 2:
Manipulating PowerPivot Data

PowerPivot Tables

Managing Tables

How to Organize and Format Tables

Activity 2-1

Calculated Columns

PowerPivot Formulas

How to Create Calculated Columns

Activity 2-2

Sort Options

Filter Options

How to Sort and Filter PowerPivot Data

Activity 2-3

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

Activity 2-4

Summary

Review Questions

Lesson 3:
Creating PowerPivot Reports

PivotTables

Flattened PivotTables

The PowerPivot Field List Pane

Creating Key Performance Indicators

How to Create a PivotTable

Activity 3-1

PivotCharts

PivotChart Types

How to Create PivotCharts

Activity 3-2

Customize the Ribbon

Power Views

Activity 3-3

Slicers

How to Filter Data Using Slicers

Activity 3-4

Sparklines

Types of Sparklines

The Sparkline Tools – Design Contextual Tab

Conditional Formatting

Conditional Formats

How to Present PivotTable Data Visually

Activity 3-5

Summary

Review Questions

Lesson 4:
Using DAX Functions in PowerPivot

Measures

DAX Functions

DAX Variables

Aggregate Functions

How to Manipulate PowerPivot Data Using DAX Functions

Activity 4-1

Filter Functions

How to Extract Data From Tables Using Functions

Activity 4-2

Time Intelligence Functions

Create a Date Table

How to Work with Time Dependent Data

Activity 4-3

Summary

Review Questions

Lesson 5:
Distributing PowerPivot Data

Workbook Protection

Worksheet Protection

How to Protect Reports

Activity 5-1

File Formats

How to Save Reports in Different File Formats

Activity 5-2

Summary

Review Questions

Lesson Lab 1-1

Lesson Lab 1-2

Lesson Lab 2-1

Lesson Lab 2-2

Lesson Lab 3-1

Lesson Lab 3-2

Lesson Lab 4-1

Lesson Lab 5-1

Appendices

Keyboard Shortcut Quick Reference Sheet

Glossary

Index