FreeCourse Logo
FreeCourse.io
Verified CouponsFree CoursesBlog
Categories
Home/Courses/Power Query in Excel 1 - Daten zusammenführen für Einsteiger
Power Query in Excel 1 - Daten zusammenführen für Einsteiger
Office Productivity100% OFF

Power Query in Excel 1 - Daten zusammenführen für Einsteiger

Udemy Instructor
0(4.9K students)
Self-paced
All Levels

About this course

Dieser Online-Kurs ist der ideale Ausgangspunkt für deine Reise mit Microsoft Power Query. Egal, ob du ein Datenanalyst oder eine erfahrener Entwicklerin bist, Power Query ist das perfekte Tool zum Transformieren und Kombinieren von Datensätzen in Excel.Dieser Kurs hilft dir bei den ersten Schritten mit Power Query und zeigt dir, wie du es bei Ihrer täglichen Arbeit einsetzen kannst.Microsoft Power Query ist der beste Weg, um deine Daten von einem Chaos in ein Wunder zu verwandeln.In diesem Online-Kurs lernst du:Daten aus verschiedenen Quellen zu manipulieren und kombinieren leistungsstarke Abfragetechniken zu verwenden, um das zu finden, wonach Sie in Ihren Daten suchenunübersichtliche Dateien zu bereinigen, damit du sie problemlos verwenden kannstmehr aus Excel herausholen, und auf umständliche Copy&Paste-Orgien zu verzichteneinige deiner Makros durch einfacher zu bedienende Power Query Abfragen zu ersetzen oder zukünftig direkt Power Query zu verwenden.Lerne endlich, Microsoft Power Query zu verwenden, das kostenlose Tool zur Datenanalyse und -bearbeitung, das im Lieferumfang von Microsoft Excel enthalten ist.Microsoft Power Query ist ein leistungsstarkes Tool, mit dem du deine Daten vollautomatisiert aus verschiedenen Quellen laden, bereinigen und kombinieren kannst - aber es ist nicht immer einfach herauszufinden, wie man es benutzt. Nach diesem Kurs wirst du in der Lage sein:zu Verstehen, was Power Query ist und wie es funktioniert.Power Query im täglichen Alltag zu verwenden, um deine Daten zu manipulieren und damit Pivot-Tabellen oder Dashboards zu erstellen.

Skills you'll gain

MicrosoftGerman

Available Coupons

Loading...

Course Information

Level: All Levels

Suitable for learners at this level

Duration: Self-paced

Total course content

Instructor: Udemy Instructor

Expert course creator

This course includes:

  • 📹Video lectures
  • 📄Downloadable resources
  • 📱Mobile & desktop access
  • 🎓Certificate of completion
  • ♾️Lifetime access
$0$49.99

Save $49.99 today!

Enroll Now - Free

Redirects to Udemy • Limited free enrollments

Share this course

https://freecourse.io/courses/power-query-excel-daten-zusammenfuhren-einsteiger

You May Also Like

Explore more courses similar to this one

Data Skills for Finance Professionals
Office Productivity
0% OFF

Data Skills for Finance Professionals

Udemy Instructor

Data Skills for Finance Professionals is a comprehensive bundle designed to equip finance professionals with in-demand data analysis skills using Excel and Power BI. Whether you’re preparing dashboards, building data models, or analyzing business performance, this course gives you the tools to work smarter and faster with data.Start with the Advanced Excel Dashboard Masterclass, where you’ll learn to design dynamic dashboards using form controls, charts, and formulas. You'll master techniques like interactive filtering, dynamic charting, and professional formatting — essential for reporting in financial roles.Then, dive into Power Pivot Masterclass, where you’ll handle large datasets, build relationships, and create powerful reports using Excel’s Data Model. You'll learn to use DAX (Data Analysis Expressions), logical functions, calculated columns, KPIs, and time intelligence — all critical for financial modeling and performance tracking.Next, deepen your skills with the Data Analysis in Excel Course. Learn essential tools like data validation, advanced filters, conditional formatting, and what-if analysis. These techniques help you control data inputs, explore scenarios, and create cleaner, more reliable spreadsheets for financial decisions.Finally, level up with the Advanced DAX in Power BI course. You'll understand how Power BI’s DAX engine works, build complex calculations, and apply advanced functions like CALCULATE, FILTER, RANKX, and time intelligence for fiscal reporting. You'll also master relationships, iterator functions, and custom calendar logic — ideal for budgeting, forecasting, and performance analysis.This bundle is ideal for finance professionals who want to transition from basic spreadsheet tasks to advanced data analysis and reporting using Excel and Power BI. By the end, you’ll confidently transform raw data into insights that drive strategic financial decisions.

4.5•1.1K•Self-paced
FREE$60.99
Enroll
Learn Microsoft Office with ChatGPT Gemini and Copilot
Office Productivity
0% OFF

Learn Microsoft Office with ChatGPT Gemini and Copilot

Udemy Instructor

Welcome to the Complete Microsoft Office with AI Mastery Course, a practical, step-by-step program designed to help you master Microsoft Word, Excel, and PowerPoint while learning how to use powerful AI tools such as ChatGPT, Gemini, and Microsoft Copilot to transform your productivity. Whether you're a beginner, office professional, student, teacher, freelancer, or business owner, this course shows you exactly how to combine traditional Office skills with modern AI-driven workflows to save time, automate tasks, and create high-quality work faster and more accurately. By the end of this course, you will not only become confident in using Word, Excel, and PowerPoint, but you will also learn how to integrate AI assistants to write better content, analyze data, build presentations, generate ideas, and speed up repetitive work. This makes it ideal for improving productivity, accuracy, and overall professional performance. What You Will LearnHow to use Microsoft Word, Excel, and PowerPoint from beginner to advanced levelHow to combine Microsoft Office with AI for real-world tasksHow to use ChatGPT, Google Gemini, and Microsoft Copilot to automate Office workAI-powered writing, editing, formatting, summarizing, and content generation in WordAI-powered formulas, data analysis, dashboards, and automation in ExcelAI-enhanced slide creation, design, storytelling, and templates in PowerPointHow to create reports, emails, proposals, resumes, and presentations using AI toolsHow to build automated workflows that reduce manual work and improve accuracyReal-world examples, downloadable files, templates, and ready-to-use AI promptsWhy This Course Is DifferentThis is not just another Microsoft Office tutorial. It is a complete AI-enhanced productivity system built for modern workplaces.You will learn a combination of traditional Office skills, AI automation techniques, practical real-life applications, and step-by-step demonstrations using ChatGPT, Gemini, and Copilot. This integrated approach ensures you work faster, smarter, and more efficiently.Who This Course Is ForAnyone wanting to leverage ChatGPT, Gemini, and Copilot with Office toolsAfter Completing This Course, You Will Be Able ToWork confidently in Word, Excel, and PowerPointUse AI tools to speed up writing, data analysis, and designAutomate repetitive tasks using ChatGPT, Gemini, and CopilotProduce higher-quality documents, spreadsheets, and presentationsIncrease productivity using Microsoft Office with AIIf you want to stay competitive and productive in the modern workplace, this course will equip you with the essential skills you need. Enroll now to learn Microsoft Office with AI step by step, gain hands-on practice with Word, Excel, PowerPoint, and discover how ChatGPT, Gemini, and Copilot can transform the way you work. Start today and build the AI-driven digital skills that employers demand.

4.6•2.3K•Self-paced
FREE$55.99
Enroll
MS Office With Canva Word Excel PowerPoint Canva All  in One
Office Productivity
0% OFF

MS Office With Canva Word Excel PowerPoint Canva All in One

Udemy Instructor

Are you ready to learn Microsoft Word, Excel, PowerPoint, and Canva for creativity using all in one comprehensive course?Whether you're a student, professional, entrepreneur, or freelancer, this all-in-one course is designed to give you the practical skills you need to create documents, analyze data, design engaging presentations, and build visually stunning content with ease.This course combines the power of Microsoft Office with the creative flexibility of Canva to help you succeed in work, school, or business.What You’ll LearnMicrosoft Word: Create and format professional documents, reports, and resumes. Work with templates, styles, tables, and images effectively.Microsoft Excel: Enter and organize data, apply formulas and functions, create charts, and perform basic data analysis.Microsoft PowerPoint: Design impactful presentations, apply transitions and animations, and structure slides for effective communication.Canva: Design graphics, social media posts, presentations, flyers, and more using drag-and-drop tools — no design experience required.Who This Course Is ForAnyone looking to improve productivity with MS Office and design capabilities with CanvaTools You’ll MasterMicrosoft Word for document creationMicrosoft Excel for data managementMicrosoft PowerPoint for presentation designCanva for graphic and visual content creationBy the End of This Course, You Will Be Able ToConfidently use Microsoft Office applications for everyday tasksCreate polished, professional documents and reportsManage and visualize data effectively in ExcelBuild engaging slide presentations in PowerPointDesign high-quality visual content using Canva for both print and digital useCombine productivity and creativity in your personal or professional projectsLearn the most in-demand digital tools in one convenient course. Enroll now and start building the skills that will help you work smarter, communicate better, and stand out professionally.

0.0•4.8K•Self-paced
FREE$49.99
Enroll
FreeCourse LogoFreeCourse

Freecourse.io brings you high-quality online courses with free certificates to help you upskill, boost your career, and achieve your goals anytime, anywhere.

Resources

  • Courses
  • Categories
  • Features

Company

  • About
  • Blog
  • Contact

Legal

  • Privacy
  • Terms
  • Cookies
  • Licenses

© 2026 FreeCourse. All rights reserved.