Power Pivot: Unlock the Potential of Your Data with Excel Training Course

Power Pivot: Unlock the Potential of Your Data with Excel

Course Introduction This Power Pivot in Excel training course is designed to provide participants with advanced skills and techniques to maximize the potential of Power…

5 daysClassroom or online

14Upcoming dates

6Cities

£2,250Fees from

Course overview

Course Introduction

This Power Pivot in Excel training course is designed to provide participants with advanced skills and techniques to maximize the potential of Power Pivot.

Gain proficiency in analyzing, modeling, and visualizing data using the latest Power Pivot features, enabling you to make data-driven decisions with confidence.

This interactive course is ideal for professionals seeking to deepen their Excel expertise and optimize their reporting workflows.

Course highlights include:

Advanced data modeling and relationship building
Using DAX for custom calculations
Enhancing data analysis with Power Query
Designing interactive dashboards and reports
Hands-on exercises focused on real-world applications

Training Objectives

By the end of this training course, participants will be able to:

Understand advanced Power Pivot capabilities
Develop optimized data models in Excel
Apply DAX for complex calculations
Design professional dashboards and visuals
Analyze and interpret data effectively

Training Methodology

This training course will utilize a variety of proven adult learning techniques to ensure maximum understanding, comprehension, and retention of the information presented.

This includes instructor-led presentations, practical demonstrations, group discussions, and hands-on exercises to provide an engaging and impactful learning experience.

Who should Attend?

This training course is suitable for professionals across various industries who work with data and Excel.

This training course is suitable for:

Data analysts and business analysts
Finance and accounting professionals
Project managers handling reporting
IT professionals managing data modeling
Any Excel user seeking advanced skills

Course outline

1Day One: Introduction to Power Pivot
- Overview of Power Pivot capabilities
- Enabling and configuring Power Pivot in Excel
- Loading data from multiple sources
- Creating relationships between data tables
- Understanding data modeling concepts
- Exploring Power Pivot interface and features
2Day Two: Data Modeling and Relationships
- Optimizing data tables for analysis
- Defining relationships in Power Pivot
- Understanding cardinality and filter directions
- Managing hierarchies in data models
- Resolving common relationship issues
- Best practices for data modeling
3Day Three: Introduction to DAX (Data Analysis Expressions)
- Fundamentals of DAX calculations
- Creating calculated columns and measures
- Using basic DAX functions (SUM, AVERAGE)
- Understanding filter context in DAX
- Applying time intelligence functions
- Debugging and troubleshooting DAX formulas
4Day Four: Advanced DAX and Power Query
- Writing advanced DAX expressions
- Applying logical and statistical DAX functions
- Combining DAX with Power Query
- Cleaning and transforming data using Power Query
- Creating custom columns in Power Query
- Connecting Power Pivot with Power BI
5Day Five: Dashboards and Reporting
- Building interactive dashboards in Excel
- Using slicers and timelines for filtering
- Designing visually appealing reports
- Publishing and sharing dashboards
- Automating data refresh processes
- Best practices for Power Pivot reporting

Schedule

Dates and fees

14 upcoming dates in 6 cities. Fees are per delegate; bring colleagues and every seat is discounted. Every date can also be joined live online for £1,280.

All dates as PDF

November 2026

16NOV 16 - 20 Nov 2026Mon to Fri · 5 daysNext sessionOur home city

LondonUnited Kingdom · Classroom

£2,750per delegate2+ people: £2,200 each

December 2026

7DEC 7 - 11 Dec 2026Mon to Fri · 5 days

MunichGermany · Classroom

£3,450per delegate2+ people: £2,760 each

January 2027

11JAN 11 - 15 Jan 2027Mon to Fri · 5 days

BarcelonaSpain · Classroom

£3,850per delegate2+ people: £3,080 each

February 2027

8FEB 8 - 12 Feb 2027Mon to Fri · 5 days

FrankfurtGermany · Classroom

£3,250per delegate2+ people: £2,600 each

March 2027

8MAR 8 - 12 Mar 2027Mon to Fri · 5 days

RomeItaly · Classroom

£4,250per delegate2+ people: £3,400 each

April 2027

12APR 12 - 16 Apr 2027Mon to Fri · 5 days

Kuala LumpurMalaysia · Classroom

£2,250per delegate2+ people: £1,800 each

May 2027

10MAY 10 - 14 May 2027Mon to Fri · 5 days

BarcelonaSpain · Classroom

£3,850per delegate2+ people: £3,080 each

June 2027

14JUN 14 - 18 Jun 2027Mon to Fri · 5 daysOur home city

LondonUnited Kingdom · Classroom

£2,750per delegate2+ people: £2,200 each

July 2027

12JUL 12 - 16 Jul 2027Mon to Fri · 5 days

MunichGermany · Classroom

£4,250per delegate2+ people: £3,400 each

August 2027

9AUG 9 - 13 Aug 2027Mon to Fri · 5 days

BarcelonaSpain · Classroom

£3,850per delegate2+ people: £3,080 each

September 2027

13SEP 13 - 17 Sep 2027Mon to Fri · 5 days

FrankfurtGermany · Classroom

£3,250per delegate2+ people: £2,600 each

October 2027

11OCT 11 - 15 Oct 2027Mon to Fri · 5 days

RomeItaly · Classroom

£4,250per delegate2+ people: £3,400 each

November 2027

8NOV 8 - 12 Nov 2027Mon to Fri · 5 days

Kuala LumpurMalaysia · Classroom

£2,250per delegate2+ people: £1,800 each

December 2027

13DEC 13 - 17 Dec 2027Mon to Fri · 5 days

BarcelonaSpain · Classroom

£3,850per delegate2+ people: £3,080 each

Live online, on the same dates

Join the class in real time from your office or home: live sessions with the trainer, group discussion, course materials and a certificate of completion. Joining details are emailed before the course starts.

November 2026

16NOV 16 - 20 Nov 2026Mon to Fri · 5 daysNext session

Live onlineVirtual classroom · join from anywhere