Controlling
Webinar

Excel snack: Importing data from different sources with Power Query

Favorite Share Open as PDF (German) PDF FILE
This webinar is held in German.
With Power Query and Power Pivot, two tools have found their way into Excel that enable a performance boost in data analysis with Excel as self-service business intelligence (SSBI). In this module, you will learn how to use Power Query to import external data in a menu-driven manner, combine individual files and adapt the structures of your source data so that they form a perfect basis for evaluations. This allows you to update queries at any time at the click of a mouse and focus on the essentials of data analysis.

Contents

Choose 4 Excel snacks!
  • Import data from different sources (Excel, CSV, databases).
  • Customize table structures menu-driven (columns, remove rows, fill areas, split and merge columns).
  • Import and combine data from local or SharePoint folders.
  • Organize and combine queries.

Please note:

The module is part of the webinar series "Excel Snacks in Controlling" and cannot be booked individually. Select a total of four "Excel snacks" and improve your Excel knowledge in a targeted manner.

Learning environment

Once you have registered, you will find useful information, downloads and extra services relating to this training course in your online learning environment.

Your benefit

  • You will receive a brief and concise overview of the topic and compact knowledge on importing data from external sources and transforming data.
  • You will get to know the ETL concept (Extract Transform Load) of Power Query.
  • You will familiarize yourself with the essential steps for menu-driven cleansing and structuring of raw data in order to minimize future effort.
  • You will learn about options for integrating Power Query into your daily work with Excel.
  • The webinar will take place live and you will have the opportunity to ask your questions and benefit from the discussions in the group.

Methods

Live online webinar with presentation, discussion of sample solutions, tips and tricks, question and answer session.

Recommended for

The webinar is suitable for controllers who have a sound knowledge of Excel and would like to expand their Excel knowledge in a targeted and customized manner. 

Open Badges - Show what you can do digitally too.

Open Badges: Qualification 4.0

Open Badges are recognized, digital certificates of participation. These verifiable credentials are the current standard for integration in career networks such as LinkedIn.

With them, you digitally demonstrate the competences you possess. After successful completion, you will receive an Open Badge from us.

Read more
Joint online training
more
Booking number
35322
€ 172,- plus VAT
Details
1 module of 1.5 ...
Online
on 18.09.2025
German
Events
Train several employees internally
more
Pricing upon request
  • Customized training courses according to your needs
  • Directly at your premises or online
  • Cost advantage from 5 participants
  • We contact you within 24 hours (Mon-Fri)
1 module of 1.5 hours each.
In-person or Online
Request

This training is available as part of course:

Excel snacks in controlling

Start dates and details

  Select time period
0 events
18.09.2025
Live-Online
Details
Booking number: 35322
€ 172,- plus VAT.
€ 204.68 incl. VAT.
Course
zoom
zoom
Read more
Technical notes
We use various software to conduct our online events.
To the system check
Days & Times
1 module of 1.5 hours each.

Thursday, 18.09.2025

09:00 am - 10:30 am

Sufficient places are still free.
Don't wait too long to book.
Fully booked.
The next booking ensures this course will take place
Booking number: 35322
€ 172,- plus VAT.
€ 204.68 incl. VAT.
Details
1 module of 1.5 hours each.
Booking number: 35322
€ 172,- plus VAT.
€ 204.68 incl. VAT.
Details
1 module of 1.5 hours each.
Book later
You are welcome to make a non-binding advance reservation.
Book in advance
No suitable date?
You are welcome to be notified by e-mail as soon as new dates are released.
E-mail notification
Also bookable as in-house training
demand-oriented adaptations possible
on-site or live online for multiple employees
save time and traveling expenses
In-house request
Please note: We use third-party tools for selected events. Personal data of the participant will be passed on to them for the implementation of the training offer. You can find more information in our privacy policy.

About us – The Haufe Akademie

Your optimizer, innovator and companion since 1978 -
Your professional partner for professional development and seminars, training courses and topical conferences.

Whether on site, live online or in-house - our customised solutions, our claim to the highest level of consulting expertise and training tailored to your needs simplify the acquisition of skills for the working world of the future and sustainably facilitate professional development.

A wide range of seminars, individual coaching and our flexible formats support HR managers and decision-makers in shaping the future and developing employees, in-house teams and companies.

Experience the benefits of online training from the comfort of your own home. Our online formats meet the highest quality standards and are in no way inferior to face-to-face events in terms of practical relevance. Learn together live online in interactive groups or digitally at a time of your choice.

2,500+ further training
600,000+ apprentices per year
Over 95% positive reviews
2,500 trainers and coaches
17,500+ training courses held per year
Call us or send an email

Do you have any questions?

We are there for you Mon - Fri 8 a.m. - 5:00 p.m.

Stephanie Göpfert

Head of Customer Service

service@haufe-akademie.de
+49 761 595339-00
*Mandatory fields
FAQs

Questions & Answers

In our Questions & Answers (FAQ) section, you will find all the answers and the most frequently asked questions about your selected topic.