Microsoft Excel Logo Training

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.

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

  • 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

Clare ChaffeyClare 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 LowAlexander 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 mulhollandhelen 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 mottkatherine 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 EstibeiroLucio Estibeiro
14:38 28 Jan 18