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
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
Course Description
You’re Just Seconds Away From Leveraging Excel & Power Query That Will Make It Possible For YOU To:
Increase your Excel & Power Query SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!
Become more PRODUCTIVE at using Excel & Power Query which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!
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 ***
Instructor Details
- 4.4 Rating
264 Reviews
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.
More courses by MyExcelOnline John Michaloudis
Pivot Tables, Power Pivot Tables, Power Query & Power BI (2026)
4.4 (2,315 Reviews)
Provider: Udemy
Time: 18.4h
$15.99
Microsoft Excel Pivot Tables - Master Excel Pivot Tables! (2020)
4.4 (1,216 Reviews)
Provider: Udemy
Time: 2.5h
$13.99
Learn Microsoft Word, PowerPoint & Outlook In 90 Minutes! (2020)
4.3 (103 Reviews)
Provider: Udemy
Time: 1.6h
$39.99
More Excel courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$39.99
Microsoft Excel: Advanced Dashboard Design (Project-Based!) (2026)
4.9 (4,868 Reviews)
Provider: Udemy
Time: 6.4h
$99.99
Master NEW Excel Functions in Office 365 & Office 2021+
4.8 (5,262 Reviews)
Provider: Udemy
Time: 7.1h
$15.99
Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (2026)
4.8 (3,239 Reviews)
Provider: Udemy
Time: 8.6h
$119.99
Reviews
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.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 88 / 100










