Introduction to Microsoft Excel Power Pivot

1 Day, 9:00-4:00

Course Overview

This course shows you how to use Power Pivot (an Excel add-in) to connect to your enterprise databases, import data from various sources, analyze data, and create dynamic reports in Excel. This course is for students with a sound working knowledge of Microsoft Excel and general computing proficiency, including those who will be using Excel to make business decisions.

Course Objectives

• Become familiar with the Power Pivot application and import data
• Manipulate data in a Power Pivot worksheet
• Use DAX functions in Power Pivot
• Create reports using Power Pivot data
• Distribute Power Pivot Data

Getting Started with Power Pivot

• Explore the Power Pivot Application
• The Power Pivot Window and Ribbon
• Power Pivot Worksheets
• Import Data from Various Data Sources
• The Table Import Wizard
• Data Types
• Importing Data from a Text File, Excel, and Access
• Refresh Data from a Data Source
• Refreshable Tables

Manipulating Power Pivot Data

• Organize and Format Tables
• Sort and Filter Power Pivot Data
• Create Calculated Columns
• Create and Manage Table Relationships
• Table Relationships
• Types of Relationships
• Create Hierarchy

Using DAX Functions in Power Pivot

• Manipulate Power Pivot Data Using DAX Functions
• Measures: Implicit and Explicit
• DAX Functions
• Extract Data from Tables Using the Related function
• Work with Time Intelligence Functions
• TOTALMTD

Creating Power Pivot Reports

• Create a PivotTable
• Flattened PivotTables
• The Power Pivot Field List Pane
• Create PivotCharts
• Filter Data Using Slicers
• Present PivotTable Data Visually
• Sparklines
• Key Performance Indicators

Distributing Power Pivot Data

• Protect Reports
• Workbook Protection
• Worksheet Protection
• Secure a PivotTable
• Save Reports in Different File Formats
• TOTALYTD