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

Oregen Computer Training Ltd.

4.8

review us on

Clare Chaffey

12:36 09 Jun 21

Great one day course on MS Project. Basic introduction covered all the fundamentals and friendly teacher with a great teaching style. Would highly recommend.

Alexander Low

13:36 08 Jul 19

I went on an Excel Introductory Course provided by Oregen Computer Training Ltd. It was a small group but actually was just what was needed to get through the workshop. There were enough breaks to allow us to absorb the information which was delivered expertly by our Trainer for the day. The surroundings were quiet and well-suited to the course. I learnt an amazing amount which I have started to put into practice in my business in order to organise my statistics to see how the business is doing very month. I would absolutely recommend Oregen to anyone who wants to start or simply update their software knowledge. Well done to Jo Humphrey for organising and to Oregen Computer Training Ltd for hosting this excellent course. Thank you

helen mulholland

11:00 04 Jul 19

Thanks to Oregen Computer Training for a great one day basic Excel course for beginners. Great content delivered in calm quiet environment. Ideal for learning. Easy to get to nearby free parking

katherine mott

10:43 29 Oct 18

Thank you to Oregen Computer Training for a successful and informative training session in Introductory and Intermediate Excel training.

Lucio Estibeiro

14:38 28 Jan 18