Course

Power Query and Power Pivot for data analysis in Excel («MEPQPP»)

During this one-day Microsoft Excel course, you will learn how to use Power Query and Power Pivot to efficiently merge, process, and analyse large amounts of data from multiple data sources.
Duration 1 day
Price 750.–
Course documents Digital Digicomp coursware
Register
Add to watch List

Course facts

Key Learnings
  • Creating sophisticated reports and data visualisations of high-volume data (more than 1 million rows) from multiple sources using Power Query and Power Pivot
  • Analysing key performance indicators (KPIs) and creating management reports
Content

1 Power Query

  • Import data from a wide variety of sources and storage locations
  • Sort, filter and query data
  • Clean or prepare data
  • Display and combine queries
  • Visualise data in a targeted manner using pivot tables and charts

2 Power Pivot

  • Importing data from a variety of data sources
  • Editing and formating Power Pivot tables
  • Creating and applying relationships between Power Pivot tables
  • Calculating with Power Pivot (DAX functions)
  • Using hierarchies, date tables and KPIs
Target audience

This course is aimed at experienced users of PivotTables in Excel and at anyone who wants to analyse and visualise large amounts of data using Microsoft Excel.

Requirements

Participants of this course must have attended the following course or have equivalent knowledge: 

    COURSE

    PivotTables and Data Analysis with Excel («MEPT»)

    1 day
    • Berne, Geneva, Lausanne, Virtual Training
    CHF
    700.–
    Learn more

Download

Download course details as PDF

Questions

Any questions?
First name
Last name
Company optional
Email
Phone
I would like to book this course as a company course
First name
Last name
Company optional
Email
Phone
Number of participants
Desired course location
Start date (DD.MM.YYYY)
End date (DD.MM.YYYY)

Choose your date

28
Apr
2025
Zürich
German
Timetable
Guaranteed to take place. Only 17 days left until the start! Register now!
CHF 750.-
exkl. 8.1% Mwst.
Guaranteed to take place. Only 17 days left until the start! Register now!
CHF 750.-
exkl. 8.1% Mwst.
28
Apr
2025
Lausanne
French
Timetable
Guaranteed to take place. Only 17 days left until the start! Register now!
CHF 750.-
exkl. 8.1% Mwst.
Guaranteed to take place. Only 17 days left until the start! Register now!
CHF 750.-
exkl. 8.1% Mwst.
13
Jun
2025
Geneva
French
Timetable
CHF 750.-
exkl. 8.1% Mwst.
CHF 750.-
exkl. 8.1% Mwst.
21
Jul
2025
Lausanne
French
Timetable
If you register now, this course is guaranteed to take place!
CHF 750.-
exkl. 8.1% Mwst.
If you register now, this course is guaranteed to take place!
CHF 750.-
exkl. 8.1% Mwst.
25
Jul
2025
Zürich
German
Timetable
CHF 750.-
exkl. 8.1% Mwst.
CHF 750.-
exkl. 8.1% Mwst.
25
Jul
2025
Berne
German
Timetable
CHF 750.-
exkl. 8.1% Mwst.
CHF 750.-
exkl. 8.1% Mwst.
1
Sep
2025
Geneva
French
Timetable
CHF 750.-
exkl. 8.1% Mwst.
CHF 750.-
exkl. 8.1% Mwst.
10
Sep
2025
Virtual Training
German
Timetable
CHF 750.-
exkl. 8.1% Mwst.
CHF 750.-
exkl. 8.1% Mwst.
16
Oct
2025
Zürich
German
Timetable
Guaranteed to take place. Register now!
CHF 750.-
exkl. 8.1% Mwst.
Guaranteed to take place. Register now!
CHF 750.-
exkl. 8.1% Mwst.
17
Oct
2025
Lausanne
French
Timetable
CHF 750.-
exkl. 8.1% Mwst.
CHF 750.-
exkl. 8.1% Mwst.
13
Nov
2025
Zürich
German
Timetable
CHF 750.-
exkl. 8.1% Mwst.
CHF 750.-
exkl. 8.1% Mwst.
13
Nov
2025
Berne
German
Timetable
CHF 750.-
exkl. 8.1% Mwst.
CHF 750.-
exkl. 8.1% Mwst.
13
Nov
2025
Basel
German
Timetable
CHF 750.-
exkl. 8.1% Mwst.
CHF 750.-
exkl. 8.1% Mwst.
28
Nov
2025
Geneva
French
Timetable
CHF 750.-
exkl. 8.1% Mwst.
CHF 750.-
exkl. 8.1% Mwst.
12
Dec
2025
Virtual Training
German
Timetable
CHF 750.-
exkl. 8.1% Mwst.
CHF 750.-
exkl. 8.1% Mwst.
Next date
28
Apr
2025
Zürich
German
Timetable
Guaranteed to take place. Only 17 days left until the start! Register now!
CHF 750.-
exkl. 8.1% Mwst.
Guaranteed to take place. Only 17 days left until the start! Register now!
CHF 750.-
exkl. 8.1% Mwst.

Further courses

WORKSHOP

Microsoft Power BI – Fundamentals («MPBI01»)

1 day
CHF
900.–
Learn more
COURSE

Creating interactive dashboards with Microsoft Excel («ME7»)

2 days
CHF
1'290.–
Learn more