Excel PowerPivot
Build practical, job-ready Excel skills with hands-on, instructor-led training focused on real business tasks.
Scheduled dates
This course is available for private and onsite training - delivered for your team anywhere in the U.S., or virtually on your schedule. You can also ask us to add it to the public calendar, or let us know you’re interested and we’ll reach out when a date is set.
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
- 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
- Organize and Format Tables
- Create Calculated Columns
- Sort and Filter PowerPivot Data
- Work with Table Relationships and the Data Model
- Create PivotTables from PowerPivot
- Create PivotCharts from PowerPivot
- Filter Data Using Slicers
- Present PivotTable Data Visually
- Differences between Calculated Columns and DAX Measures
- Learn DAX Functions COUNT, COUNTA, DISTINCTCOUNT and CALCULATE
- Manipulate PowerPivot Data Using DAX Measures
- Work with Time Dependent Data
- Handle Fiscal and Calendar Periods
- Use Time Intelligence Functions DATESYTD, DATESQTD, DATESMTD and DATEADD
- Load Data Model to Power BI
- Load Excel File to Power BI