Excel PowerPivot

Full Day1 DayVersion 365Official CPE Provider

Analyze millions of rows Excel alone can't handle. Load data into the PowerPivot data model, relate tables, write introductory DAX measures, and build PivotTables and PivotCharts that reach across all your data.

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.

Course Outline

6 lessons · 20 topics

1Get 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

2Manipulate PowerPivot Data

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

3Create PowerPivot Reports

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

4Introduction to DAX Measures in PowerPivot

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

5Perform Date and Time Sensitive Calculation in PowerPivot

Work with Time Dependent Data
Handle Fiscal and Calendar Periods
Use Time Intelligence Functions DATESYTD, DATESQTD, DATESMTD and DATEADD

6Distributing PowerPivot Data

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

Excel Solutions Team
Kirkwood Tower, 11757 Katy Fwy, Suite 1300, Houston, TX 77079
(713) 589-2655 · contactinfo@excelsolutionsteam.com · excelsolutionsteam.com

Official CPE Provider (TX State Board of Public Accountancy)
BBB Accredited since 2006 · 20+ years training Houston professionals