Professional training – Microsoft 365 and Office

Excel Power Query

Hands-on Excel Power Query course: you work on Importing data, Transforming columns and Merging queries and take away knowledge you can apply right away.

Duration
6 hours, one session
Level
Intermediate
Format
Online or on-site
Language
German or English
Certificate
Certificate of attendance

Overview

In “Excel Power Query” we combine fundamentals and practice: you get to know Importing data, Transforming columns and Merging queries, apply what you learn in exercises and receive templates and checklists for your own use.

Microsoft 365 is part of almost every office routine, yet most employees use only a fraction of what it offers. Our Office courses focus on the features that save time: from Excel formulas and pivot analyses to professional documents, collaboration in Teams, SharePoint and Planner, and automation with Power Automate. Excel Power Query is a one-day workshop with short explanations and plenty of exercises on practical tasks. You receive exercise files, keyboard shortcuts and templates for immediate use in your daily work.

The course is delivered live – either online in a virtual classroom or on-site in our training rooms in Munich, Salzburg, Berlin, Augsburg, Hanover, Bremen, Stuttgart and Kaiserslautern. We can also run it exclusively for your team.

Focus areas of the course

Importing dataTransforming columnsMerging queriesFolders with multiple filesPivoting and unpivotingAutomating refresh

Who is this course for?

  • Administrative staff and assistants
  • Controllers, project managers and team leads
  • Business users in all departments
  • IT owners and Microsoft 365 administrators

What you will be able to do

  • You know the key topics of Excel Power Query – Importing data, Transforming columns, Merging queries, Folders with multiple files, Pivoting and unpivoting and Automating refresh – and can apply them in practice.
  • You work noticeably faster and more reliably with Excel Power Query.
  • You use features deliberately for recurring tasks.
  • You design results professionally and consistently.
  • You share and collaborate in a data-protection-compliant way.

Course outline

Module 1 Getting started and interface of Excel Power Query
  • Where Excel Power Query fits in Microsoft 365
  • Interface, ribbon and quick access toolbar
  • Navigating efficiently with keyboard shortcuts
  • Exercise files and practical examples
Module 2 Focus areas: Excel Power Query
  • Importing data
  • Transforming columns
  • Merging queries
  • Folders with multiple files
  • Pivoting and unpivoting
  • Automating refresh
Module 3 Core features of Excel Power Query
  • The most important functions step by step
  • Working in a structured and low-error way
  • Formatting, templates and standards
  • Avoiding common pitfalls
Module 4 Hands-on exercises with Excel Power Query
  • Guided exercises on everyday office tasks
  • Bringing and solving your own work examples
  • Time-saving workflows and automation
  • Questions and solutions in the group
Module 5 Collaboration, security and transfer
  • Sharing, permissions and co-authoring
  • Data protection and safe file handling
  • Integration with other Microsoft 365 services
  • Checklist for your daily work
Module 6 Transfer to your daily work
  • Exercise based on a realistic case
  • Typical mistakes and how to avoid them
  • Checklist and templates to take away
  • Open questions, outlook and resources for further learning

Prerequisites

Depending on the level, basic PC skills are enough. Advanced courses assume confident use of the basic functions. Basic knowledge of the topic is helpful.

Technical requirements

Your own laptop with internet access; Microsoft 365 access or a training environment is provided in advance.

Dates & locations

For every location we suggest a date roughly four weeks ahead. Your preferred date is always possible.

  • Munich Thu, 10 December 2026 6 hrs Request
  • Salzburg Tue, 15 December 2026 6 hrs Request
  • Berlin Fri, 11 December 2026 6 hrs Request
  • Augsburg Thu, 10 December 2026 6 hrs Request
  • Hanover Mon, 14 December 2026 6 hrs Request
  • Bremen Tue, 15 December 2026 6 hrs Request
  • Stuttgart Tue, 15 December 2026 6 hrs Request
  • Kaiserslautern Fri, 11 December 2026 6 hrs Request
  • Online Tue, 15 December 2026 6 hrs Request

Frequently asked questions

Which version of Microsoft 365 is required for Excel Power Query?

We follow the version your company uses and point out differences between the desktop and web versions. Features that are only available in certain licenses are marked as such. Tell us about your environment in advance so we can prepare the content accordingly.

Can we work with our own files in Excel Power Query?

Yes, gladly. For in-house sessions we include your templates, spreadsheets or processes, provided they contain no confidential content or are anonymized. Alternatively we use practical exercise files that cover all the learning content.

How much does “Excel Power Query” cost?

The course costs a flat €949 plus VAT per participant – whether online or on-site. This includes 6 hours of live training with a trainer, course materials, a lab environment and a certificate of attendance.

Can I suggest my own date?

Yes. For every location we suggest a date roughly four weeks ahead. In the request form you can always describe your preferred date or period in free text – we check availability and get back to you within one working day.

Is the course online or on-site?

Both are possible: live online in a virtual classroom or on-site in Munich, Salzburg, Berlin, Augsburg, Hanover, Bremen, Stuttgart and Kaiserslautern. We can also run the course exclusively for your team.

Can the course be tailored to our team?

Yes. Tailor-made courses cost approx. €4,500 more, depending on the topic and by arrangement. We agree content, examples and exercises with you in advance.

More courses in Microsoft 365 and Office

All 29 courses in Microsoft 365 and Office