← All courses
FREN

Power Pivot and next-generation PivotTables

From the classic PivotTable to the Data Model: relationships, DAX measures in Excel, PIVOTBY and an interactive dashboard.

6
modules
≈ 3 h
of training
€180
the full course, incl. VAT
Start for free

Access: an e-mail address is enough, you receive a sign-in code. Free modules need no bank card.

What you will be able to do

  • Link several tables in the Data Model and create DAX measures from a PivotTable
  • Build a multi-table model with Power Pivot and tell measures from calculated columns
  • Produce formula-based summaries with GROUPBY and PIVOTBY
  • Make a PIVOTBY interactive: search filter, SWITCH, LET, formatting
  • Build a star schema fed by Power Query, with a date table and shared slicers

Who it is for

Excel users who build PivotTables and VLOOKUPs and want to analyse several tables without merging them.

Prerequisites

Able to create a structured table and a simple PivotTable (foundation modules of the Excel course). The “Power Query: the fundamentals” course is recommended for the last module.

Included

  • Video with chapters
  • PDF slides
  • Marked quiz
  • Verifiable certificate

Programme

Fundamentals

  1. 01Super PivotTables: linking two tables in the Data Model25 min10-question quizFree

Intermediate

  1. 02Power Pivot: multi-table model, measures and large volumes42 min10-question quiz€50 incl. VAT
  2. 03Summaries with formulas: GROUPBY and PIVOTBY25 min10-question quiz€50 incl. VAT
  3. 04PIVOTBY: a living PivotTable with a search filter23 min10-question quiz€50 incl. VAT

Advanced

  1. 05Shape-shifting PivotTable: PIVOTBY, LET and SWITCH20 min10-question quiz€50 incl. VAT
  2. 06Next-generation PivotTables: Power Query, Power Pivot and DAX48 min10-question quiz€50 incl. VAT
Start for free

Training a team? Access for several employees, on quotation. admin@axent-consulting.com