Onsite Microsoft Excel PowerPivot Training

Onsite Microsoft Excel PowerPivot Training Sessions

PowerPivot was introduced in Office 2013 and is a powerful add-in to Excel that gives you the ability to analyse and summarise large/multiple data. This Microsoft® PowerPivot course teaches you how to use PowerPivot to import data from a variety of sources and create powerful Pivot Tables.

Ideally you should be an experienced Excel user and have attended an Excel advanced course. To speak to us about delivering a bespoke training package, please call us on 01892 665353 or email us.

Course Outline

This course is for experienced users of Excel who want to gain a progress further in managing large amounts of data with PowerPivot.

Download Course as a PDF

Installing the PowerPivot Add-in
Looking at the Data Model window

Importing data from multiple sources
Creating relationships between tables

Creating a PivotTable with PowerPivot
Using the Field List
PowerPivot and Excel PivotTables compared

Grouping Dates in PivotTables
Using Year and Month Columns
How to use Date filters

Using slicers to filter data
Using slicers across multiple PivotTables

Using Charts and slicers to create interactive dashboards

A brief overview of PowerView

Introducing DAX
Using Dax in PowerPivot Tables
Creating Calculated Columns and Fields
Using DAX to create calculated columns and fields
Using popular DAX functions

Using Advanced DAX Functions including: SumX and ALL Functions

Finding year to date, month to date and other popular groupings

Using a PowerPivot set to get the required data from a PowerPivot PivotTable

Please note that in there may not always be time to cover both lists and charts and the group will be given the opportunity to choose which of these they wish to cover.

All Oregen Training Onsite Courses

Microsoft Excel
Microsoft Word
Microsoft Powerpoint
Microsoft Outlook
Microsoft Project
Microsoft Publisher
Microsoft Visio
Microsoft Teams
Microsoft Sharepoint
Excel VBA
Power BI
Word VBA
Office 365 & One Drive