Power query in excel Course

4.4 (150 reviews)
Created by:

Simon Sez IT

  • 6 Lessons
  • 59 Students
  • Certificate of completion

Power query in excel, in this course teaches you how to collect, clean, and transform data efficiently without complex formulas. You’ll learn how to import data from multiple sources such as Excel files, databases, and the web, then reshape and combine it using intuitive tools. The course covers essential topics like removing duplicates, splitting columns, merging tables, and automating data refreshes. You’ll also explore advanced techniques like conditional columns and custom transformations using the M language. By the end, you’ll master how to build repeatable workflows for preparing data, saving hours of manual work and improving accuracy in reports and analysis. Simon Sez IT

To Register in Course you have to watch at least 30 Second of any lesson

What You'll Learn

  • Master data import from Excel, databases, and web sources using Power Query in Excel
  • Apply data cleaning techniques like removing duplicates, splitting columns, and filtering data efficiently
  • Create and merge tables, automate data refreshes, and build repeatable data transformation workflows
  • Utilize advanced Power Query features such as conditional columns and custom M language transformations

Course Content

6 Lessons • 4 h 3 m total

How to Get The Certificate

  • You must have an Account on the platform.
  • Complete all lessons.
  • Watch at least 50% of Lesson Duration.
  • Get your Certificate free 🎉 !

Certificate Example

Mind Luster Certificate Template

4.4 (150 reviews)

Overall rating

  • 5.0 0%
  • 4.0 0%
  • 3.0 0%
  • 2.0 0%
  • 1.0 0%

Reviews

Ricardo Ozuna

· 2mos ago

is excelent.

AKASH RAJVIR

· 3mos ago

Great learning Experience

Yared Hailemariam Yesho

· 6mos ago

i really like and enjoyed the courses at mindluster

Power query in excel Course Description

Power query in excel, in this course teaches you how to collect, clean, and transform data efficiently without complex formulas. You’ll learn how to import data from multiple sources such as Excel files, databases, and the web, then reshape and combine it using intuitive tools. The course covers essential topics like removing duplicates, splitting columns, merging tables, and automating data refreshes. You’ll also explore advanced techniques like conditional columns and custom transformations using the M language. By the end, you’ll master how to build repeatable workflows for preparing data, saving hours of manual work and improving accuracy in reports and analysis. Simon Sez IT

Focus on Learning, Not Ads

Experience the full power of Mindluster with Premium.
No distractions, just pure education.

Get Mindluster Premium

Cancel your subscription anytime

Course Intro