
Excel Power Query: Tiefgehende Datenanalyse und Manipulation
Affiliate link — we may earn a commission. Learn more
Excel Power Query: Tiefgehende Datenanalyse und Manipulation – Sebastian Glöckner
Updated July 2026
If you are searching for a free Excel Power Query course that teaches real‑world data‑automation techniques, this Udemy course by Sebastian Glöckner fits the bill. It covers everything from importing data from the web to building automated monthly reports, giving you the practical skills needed to let Excel work for you. The curriculum focuses on eliminating manual copy‑paste chores, consolidating files with a single click, and creating pivot‑ready tables without writing a line of code. Whether you need a certification‑ready training or a hands‑on tutorial, this course delivers a complete, up‑to‑date solution for data analysts, business users, and developers alike.
What You'll Learn
- Build automated data‑import pipelines that pull information from websites, SQL databases, and SharePoint lists using Power Query.
- Master the art of consolidating dozens of Excel files in a folder into a single, clean data set with one click.
- Learn how to transform foreign date and number formats into standardized German conventions without manual effort.
- Understand grouping, pivoting, and unpivoting techniques to reshape raw tables for immediate analysis.
- Create conditional columns and custom calculations that replace complex VBA macros.
- Implement end‑to‑end reporting workflows that generate monthly dashboards in seconds.
- Apply advanced text‑extraction methods to split and clean SAP‑style downloads or other messy sources.
- Analyze data quality issues and automate error‑handling to ensure reliable results for decision‑making.
Course Details
- Instructor: Sebastian Glöckner – 300 000+ participants
- Rating: 4.5 stars (based on reviews)
- Language: German (de‑DE)
- Certificate: Yes, upon completion
- Includes: Lifetime access, mobile‑friendly videos, downloadable resources
What This Course Covers
Einführung & Motivation
- Überblick über Power Query und seine Rolle in der modernen Datenanalyse
- Gründe, warum Power Query häufig unterschätzt wird
- Vergleich von manuellen Prozessen vs. automatisierten Workflows
Datenextraktion & -konsolidierung
- Import von Textteilen und Teilstrings aus komplexen Feldern
- Zusammenführen aller Dateien eines Ordners zu einer einzigen Abfrage
- Abrufen von Daten aus dem Internet, z. B. aktuelle Aktienkurse
Datenformatierung & -bereinigung
- Umwandlung fremder Gebietsschemas (Dezimalpunkt → Komma)
- Automatische Konvertierung unterschiedlicher Datumsformate
- Manuelles Zerlegen problematischer Werte, etwa aus SAP‑Downloads
Transformations‑ und Berechnungslogik
- Unterschied zwischen Transformieren und Spalte hinzufügen (Beispiel Rundung)
- Einfügen bedingter Spalten mit einfacher WENN‑Formel
- Berechnungen über, mit und zwischen Spalten in Power Query
Pivot‑ und Aggregationsstrategien
- Erstellung einer Pivot‑Tabelle direkt aus Power‑Query‑Ergebnissen
- Schnellste Aggregation: ANZAHL‑Funktion nutzen
- Aufsummieren wie in einer Pivot‑Tabelle bereits beim Import
Fortgeschrittene Datenmodellierung
- Transponieren von Daten (Zeilen ↔ Spalten) für flexible Analysen
- Pivotieren und Entpivotieren, um Daten für unterschiedliche Szenarien zu formen
- Rekonstruktion einer ursprünglichen Pivot‑Tabelle aus den transformierten Daten
Who Should Take This Course
- Power Query users who want to deepen their expertise and automate repetitive tasks.
- Business analysts and data‑driven professionals who create weekly or monthly reports in Excel.
- Developers looking for advanced Power Query techniques without writing VBA code.
- Employees who regularly work with large numbers of Excel files and need a fast consolidation method.
- Anyone aiming to become a certified data‑analyst by mastering Excel’s built‑in data‑engine.
Prerequisites
- No prior experience needed — this course is beginner‑friendly.
- Basic familiarity with Excel’s interface and standard functions is recommended.
- Understanding of common data‑types (dates, numbers, text) will help you progress faster.
Why Enroll in This Course
Enrolling now gives you access to a free coupon that makes the full Udemy course 100 % off for a limited time. The training combines step‑by‑step video lessons with downloadable practice files, ensuring you can apply each technique immediately. Compared with other tutorials, this course focuses on end‑to‑end automation, allowing you to replace hours of manual work with a single Power Query click. The certification‑ready curriculum also prepares you for real‑world data‑analysis roles, making it a valuable addition to any résumé.
Course Highlights
- Lifetime access to all video lessons and updates, so you stay current with new Power Query features.
- Mobile‑friendly format lets you learn on a tablet or smartphone during commute time.
- Practical, hands‑on exercises that mirror everyday business scenarios.
- Certificate of completion that can be added to LinkedIn or your CV.
- Self‑paced learning – progress at your own speed without deadlines.
- Comprehensive resource pack including sample workbooks and cheat‑sheet PDFs.
Frequently Asked Questions
Q: Is this course really free?
A: Yes. By applying the available Udemy free coupon, you can enroll in the full course at no cost. The 100 % discount is valid for a limited period, so act quickly to secure the free access.
Q: What will I learn in this Excel Power Query course?
A: You will learn how to import data from multiple sources, transform and clean it, automate repetitive reporting tasks, and build pivot‑ready tables—all without writing VBA code. The curriculum covers text extraction, date conversion, conditional columns, and advanced aggregation techniques.
Q: Do I get a certificate after completing this course?
A: Yes. Udemy provides a downloadable certificate of completion once you finish all video lessons and pass the optional quizzes. This certificate can be shared on professional networks to showcase your new Power Query skills.
Q: Is this course suitable for beginners?
A: Absolutely. The instructor starts with the fundamentals of Power Query and gradually introduces more complex transformations. No prior Power Query experience is required, and basic Excel knowledge is sufficient.
Q: How long do I have to enroll for free?
A: The free coupon is available for a limited time, typically a few weeks from the date you view the offer. After the coupon expires, the course reverts to its regular price, so enrolling promptly ensures you receive the 100 % discount.
Final Thoughts
Excel Power Query: Tiefgehende Datenanalyse und Manipulation equips beginners and seasoned analysts alike with the tools to automate data workflows and boost productivity. If you work with Excel daily and want to master Power Query for faster, error‑free reporting, this Udemy training
Affiliate link — we may earn a commission
Affiliate link — we may earn a commission. Learn more




