Course Objective: In this course, students will make use of the PowerPivot add-in to import data from various sources and create a dynamic report.

Prerequisites: To ensure your success, we recommend that you first take Excel Level 1, Level 2, and Excel PivotTables, or have equivalent knowledge and skills - such as a strong understanding of PivotTable, PivotCharts, Tables and the use of intermediate to advanced Excel functions.

Contact us to discuss if this class is right for you.

Lesson 1: Get Started with PowerPivot

• Explore the PowerPivot Application
• Import Data from Various Data Sources like Excel, Access or a Text file
• Refresh Data from a Data Source
• Create Refreshable Tables

Lesson 2: Manipulate PowerPivot Data

• Organize and Format Tables
• Create Calculated Columns
• Sort and Filter PowerPivot Data
• Work with Table Relationships and the Data Model

Lesson 3: Create PowerPivot Reports

• Create PivotTables from PowerPivot
• Create PivotCharts from PowerPivot
• Filter Data Using Slicers
• Present PivotTable Data Visually

Lesson 4: Introduction to DAX Measures in PowerPivot

• Differences between Calculated Columns and DAX Measures
• Create and Manage Measures
• Learn DAX Functions COUNT, COUNTA, DISTINCTCOUNT and CALCULATE
• Manipulate PowerPivot Data Using DAX Measures

Lesson 5: Perform Date and Time Sensitive Calculation in PowerPivot

• Create a Date Table
• Work with Time Dependent Data
• Handle Fiscal and Calendar Periods
• Use Time Intelligence Functions DATESYTD, DATESQTD, DATESMTD and DATEADD

Lesson 6: Distributing PowerPivot Data

• Load Data Model to Power BI
• Load Excel File to Power BI

Additional Power BI Courses:

• Excel: Get & Transform (PowerQuery)
• Excel: PowerPivot Part 2
• Excel: Introduction to Excel Power Tools Boot Camp (3 Days)
• Power BI Desktop

Excel 2016 Training Class Outlines:

Excel 2016 Level 1: Fundamentals of Excel
Excel 2016 Level 2: Intermediate Functions and Features
Excel 2016 Level 3: Advanced Tools and Collaboration Features
Excel 2016 Level 4: Advanced Formulas and Functions
Excel 2016 Level 5: Introduction To VBA Macros
Excel 2016 Level 6: Advanced VBA Macros