LEARNIA | Course Contents | Analyze data with Excel Power Pivot

Analyze data with Excel Power Pivot

Monday , Monday
27 July 2026
3 August 2026

Online

09:00 - 17:00

NL Dutch

Tailor-made training

Would you rather have a tailor-made training based on this course? Contact us and we will make it work.

Non-binding request

Description

Introduction: Business Intelligence and Power Pivot

What is Business Intelligence
What is the function of the different parts of Excel Power Query and Power Pivot

Collect & Transform

Import data into Power Pivot
Transform data through Power Query
Merge tables using Power Query

Setting up a data model in Power Pivot

Creating relationships between tables
Expanding tables (calculated columns)
Hide columns and tables
Custom sorting

Setting up measurements

Normal aggregating functions (SUM, COUNT, COUNTROWS, ETC.)
Using Aggregating Expressions (SUMX, AVERAGEX, MAXX...)
CALCULATE and various filter functions
Date calculation (SAMEPERIODLASTYEAR ...)

How to Create Dashboards in Excel

PivotTables
Building dashboards using Slicers

Target audience

Do you use Excel on a daily basis? Do you regularly create PivotTables and/or do you analyse fast quantities of data? Do you have to use VLOOKUP that often that you have build a love/hate relationship with this function? Then maybe it would be about time to get started with the Excel Power BI tools. These add-ons extend Excel with very powerful options allowing you to import, transform and analyse data.

Prerequisites

A decent knowledge of Excel is required to be able to benefit fully of this training. We will mainly work with PivotTables, so some knowledge of using this is really necessary.

Download PowerPivot_availability.pdf (only Dutch), please contact us if you need more information

Duration

2 days

Price per participant

990 EUR

Tailor-made training

Each organization is unique in its identity, and no co-worker is the same. That's why we at Learnia offer our clients tailor-made courses as well.
Continue reading