Skip to content
UdemyExcelPaid courseAll LevelsCertificate

Microsoft Excel Power Query - Master Power Query! (Udemy.com)

Master Microsoft Excel Power Query, Get & Transform in Excel Power Query 2010-2019 and Excel Power Query for Office 365

Created by: MyExcelOnline John Michaloudis

Last updated July 2020

icon
What you will learn

  • Become more PRODUCTIVE at using Excel Power Query which will SAVE YOU HOURS per day & ELIMINATE STRESS at work!
  • We teach you how to use Excel Power Quey with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!
  • Increase your Excel & Power Query SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!
  • Use Text, Lookup & Logical Formulas & Functions to pull data out & reorganize it to your desired outcome
  • Learn the various Data Analytical tools within Excel to easily find & clean your data such as: Text to Columns, Remove Duplicates, Find & Replace, Go to Special, Text to Columns, Sort & Filter plus much more
  • Use Conditional Formatting to find hidden and hard to find data
  • Discover the power of Excel Tables to give color and analytical power to your boring lists

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.4 out of 5higher than 25% of them
  • Reviews264#275 of 356 by number of reviews
  • Length4.4 hoursshorter than 61% of them
  • Last updatedJuly 2020earlier than 74% of them

icon
Course Description

You’re Just Seconds Away From Leveraging Excel & Power Query That Will Make It Possible For YOU To:

  1. Increase your Excel & Power Query SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!

  2. Become more PRODUCTIVE at using Excel & Power Query which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!

  3. Use Excel Power Query with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!

----------------------------------------

This is the Ultimate Microsoft Excel Data Cleansing course which has over 60 short and precise tutorials. This course was created by the No1 ranked Excel course creator (John Michaloudis) and an Excel Book Author (Bryan Hong)!

No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single analytical & data cleansing tool that is available in Microsoft Excel. 

The course is designed for Excel 2007, 2010, 2013, 2016 or 2019 and Office 365. There are 21 different chapters so you can work on your weaknesses and enhance your strengths. Each chapter was designed to improve your Excel skills with extra time saving Tips and real life examples.

In no time you will be able to clean lots of data and report it in a quick and interactive way, learn how to work with various transformation Formulas, create consolidated monthly reports with the press of a button, WOW your boss with stunning Excel visuals and get noticed by top management & prospective employers! 

The course is just over 4 hours long so you can become an awesome analyst and advanced Excel user within 1 day!
----------------------------------------

The course covers all of Excel's must-know features for importing, cleaning up and transforming messy data that gets downloaded from an external data source or an Excel file.

In the first part of the course you will learn the various "Data Cleansing" techniques using Power Query or Get & Transform - as its name changed in Excel 2019 and Office 365.  We will show you how to:

  • Clean & transform lots of data quickly

  • Import data from various external sources, folders & Excel workbooks

  • Consolidate data with ease

  • Sort & Filter data

  • Merge data

  • Join data

  • Data shaping & flat files

  • Auto cleanup your data

  • M Functions

----------------------------------------

In the second part of the course you will learn "Data Cleansing" techniques using various Excel features such as:

  • Text Function

  • Logical and Lookup Functions

  • Text to Columns

  • Find & Remove Duplicates

  • Conditional Formatting

  • Find & Replace

  • Go to Special

  • Sort & Filter

----------------------------------------

Look, if you are really serious about GETTING BETTER at excel and ADVANCING your Microsoft Excel level & skills...

…saving HOURS each day, DAYS each week and WEEKS each year and eliminating STRESS at work...

...If you want to improve your PROFESSIONAL DEVELOPMENT to achieve greater opportunities like PROMOTIONS, a HIGHER salary and KNOWLEDGE that you can take to another job…

...All whilst impressing your boss and STANDING OUT from your colleagues and peers...

...THEN THIS COURSE IS FOR YOU!

Now you have the opportunity to join your fellow professionals who are taking this course and enhancing their Microsoft Excel skills!

To enroll, click the ENROLL NOW button  (risk-free for 30 days or your money back), because every hour you delay only delays your personal and professional progress...

----------------------------------------

>> Get LIFETIME Course access including downloadable Excel workbooks, Quizzes, 1-on-1 instructor SUPPORT and  a 100% money-back guarantee! *** 

>> Watch our PROMO VIDEO above and a few of our FREE VIDEO TUTORIALS to see for yourself just how beneficial this course is and how you too can become better at Excel ***

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

MyExcelOnline John Michaloudis

Hello fellow Excel lovers/beginners/experts/users!  My name is John and I am the Chief Inspirational Officer at MyExcelOnline.

I hold a bachelors degree in Commerce (Major in Accounting) from La Trobe University in Melbourne, Australia and speak English, Greek and Spanish (and Excel)

My journey in to Excel began after I graduated and have since helped many of my colleagues around the world understand this underutilized but powerful tool. Now its my turn to teach YOU the power of Excel with these high quality and easy to understand tutorials.

My aim is to get you to become comfortable & confident in Excel and use its power to make your job a lot easier & save you time, create interactive reports that will reach top management and ultimately make you stand out from your colleagues and get that promotion or pay rise that you deserve.

I have taught over 50,000 students on Udemy alone plus over 100,000 people on my website - MyExcelOnline.  I have an active Excel blog where I post free Excel tutorials as well as an Excel podcast where I interview fellow Excel experts & share their insights.

icon
More courses by MyExcelOnline John Michaloudis

$15.99

$13.99

$59.99

$39.99

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

icon
Reviews

4.4

264 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Krishan Kumar on 9/23/2025

I wanted to learn Power query but in this particular section, excel text functions are explained while earlier sections were nice to i was learning power querry

By Lynne on 7/26/2022

It's great before Chapter 12 except some duplicated point and a short frozen period in one lesson. But the class begins from Chapter 12 are all about Very basic and SIMPLE formula or skills of Excel instead of Power Query, which makes me feel cheated since the Class Title only mentioned Power Query and what I paid should be only for Power Query. It's weird that basic Excel formula appears in a Power Query lesson.

By Arnold Schwartz on 11/27/2019

This course is excellent. Both Mr. Hong and Michaloudis provide very well explained content dealing with the Get and Transform subject matter. The video quality and sound are excellent, the pace is very good and the two different instructors approach makes for a good learning experience. I appreciate the care that both instructors took to be real clear with the examples and explanations provided.

By Clint Nisbet on 12/13/2017

Amazing data cleansing techniques and tips which is an essential for any Excel user. This introduction to Power Query has showed me it's incredible features which will undoubtedly improve your productivity and end results. Thanks to OZ & John. Clint

By Les Bewick on 11/3/2016

The software and tuition is good, i truely need to use this in respect with my work as a production controller, I Thought OZ is amazing and really like presentations. Early stages of course stripping out data / making sense of information is good to watch it unfolds and as the lectures continued finally starts to sink, it highlights all of real world scenarios people find themselves in and never realised there are methods to filter out and sort the data, the later half was more useful but also agree to get to that stage the fundamentals at beginning are necessary to enable a true reflection of the tasks to present accurate information as an end result of constantly changing data sets. i am not an accountant and will never be. I am looking to continue with other models already subscribe to with UDEMY, I am tried to build in knowledge i have and the same time like you courses so far great. I will used this module to help me build inventory database of kitchen parts instead of biscuit bom, the projections given were a good way of projecting run out times based on pack quantities. My real would scnarios is sales Demandat top level Bom exploded with Sub category of parts and unit of measure to make a complete units of products develope ordering system and maintaining dynamically brian is great very easy to understand, i'm new to power query and may find this very useful Thank you Oz , will i get a certificate

By Matjaž Mohorič on 6/8/2016

Great course with fantastic teacher - Worth every dollar ! - many advanced tips about txt parsing that i found first time here, (and i am not beginner ) - great audio and video quality - realy deep and step by steep lectures - charismatic teacher bouns: you will get exclusive tip for making coffe and some advices to keep you out of Hell (real one)

By Anonymized User on 6/5/2016

Thisisanexcellentcoursethatisfullofpracticalideas.Theinstructorsareveryknowlegeableandareabletodelivertheirpresentationsinaconfidentandengagaingmanner.Iwouldwholeheartedrecommendthecourse.IhaveprogressedthiscourseandamamazedatthenewtechniquesthatIhavelearned.ItisafantasticlearningexperienceandIreconfirmmyratingandrecommendation.

By Divisha Joe on 6/2/2016

I am familiar with both John and Oz. They are fantastic at what they do. I have learned heaps from them and look forward to exploring the rest of the course. Love how they use real world examples. Feels like on the job training - what better way to learn.

By Kyle Pew • 2,000,000+ Students on 5/30/2016

Great Microsoft Excel course! I've been using Excel for years and now only about 20% through this course I have picked up some great tips on working with Excel functions that will save me time in cleaning up my data. Thanks!

By Paul Radelat on 5/28/2016

Each video covers 1 aspect of what you need to know so it's easy to grasp and easy to digest. A lot of good useful infomriaotn tha tyou can use in the real world. The instructors do a great job of teaching.

Showing all 10 reviews on CourseDuck

Read all 264 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 88 / 100