Classbaze

Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Microsoft Excel Power Query – Master Power Query!

Master Microsoft Excel Power Query, Get & Transform in Excel Power Query 2010-2019 and Excel Power Query for Office 365
4.3
☆☆☆☆☆ 4.3/5
(149 reviews)
2,796 students
Created by
MyExcelOnline John Michaloudis

8.6

Classbaze Grade®

7.8

Freshness

7.9

Popularity

9.4

Material

Detailed Analysis »

Master Microsoft Excel Power Query
Go to course »
Platform: Udemy
Price: check current price
Video: 4h 25m
Language: English
Next start: On Demand

Best Excel classes:

Skillshare_logo_2020
Best Excel classes on Skillshare »
Coursera Logo
Best Excel classes on Coursera »
Pluralsight Logo
BestExcel classes on PluralSight »
Udemy logo
Best Excel classes on Udemy »
linkedin
Best Excel classes on LinkedIn (Free trial) »

Classbaze Rating

Classbaze Grade®

8.6 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness

7.8 / 10
This course was last updated on 7/2020.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Popularity

7.9 / 10
We analyzed factors such as the rating (4.3/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Material

9.4 / 10
Video Score: 8.2 / 10
The course includes 4h 25m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
The average video length is 4 hours 36 minutes of 923 Excel courses on Udemy.
Detail Score: 10.0 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.9 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

3 articles.
61 resources.
0 exercise.
0 test.

In this page

About this course

  The course will teach you this
  What you need to START the course
  Who can start this course?
General questions
  Coupons & Discounts
  Guarantees & money back
  Financial aid
Teacher
Classbaze hand picked recommendations

About the course

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 ***

What can you learn from this course?

✓ 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
✓ Learn the various techniques within Power Query/Get & Transform to shape your data & consolidate reports without the need to use Formulas or Macros
✓ Understand in what situations you need to use Excel Formulas v Excel Analytical Tools

What you need to start the course?

• Compatible with Microsoft Excel 2010, 2013, 2016, 2019 and Office 365
• This course is for Excel Beginners, Intermediates or Advanced Users
• No prior Power Query knowledge is required

Who is this course is made for?

• People who are in: Accounting, Finance, Management, Auditing, Admin & Support, Sales, IT, Consulting, Banking, Marketing, Business Owners, Engineering, Project Management, Students, Teachers plus MORE!
• People who want to change career and apply for a new job
• If you want to leverage Excel to stand out from the crowd, save hours each day, eliminate stress & get a promotion or pay-rise, then you are invited to join this course!

Are there coupons or discounts for Microsoft Excel Power Query - Master Power Query! ? What is the current price?

The course costs $14.99. And currently there is a 82% discount on the original price of the course, which was $84.99. So you save $70 if you enroll the course now.
The average price is $17.3 of 923 Excel courses. So this course is 13% cheaper than the average Excel course on Udemy.

Will I be refunded if I'm not satisfied with the Microsoft Excel Power Query - Master Power Query! course?

YES, Microsoft Excel Power Query – Master Power Query! has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any financial aid for this course?

Currently we could not find a scholarship for the Microsoft Excel Power Query - Master Power Query! course, but there is a $70 discount from the original price ($84.99). So the current price is just $14.99.

Who will teach this course? Can I trust MyExcelOnline John Michaloudis?

MyExcelOnline John Michaloudis has created 12 courses that got 5,760 reviews which are generally positive. MyExcelOnline John Michaloudis has taught 94,872 students and received a 4.4 average review out of 5,760 reviews. Depending on the information available, we think that MyExcelOnline John Michaloudis is an instructor that you can trust.

Learn everything about

MyExcelOnline John Michaloudis

Chief Inspirational Officer at MyExcelOnline
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.
I am currently living in the North of Spain (Basque Country) and I´m married and have one cheeky boy & a newly born baby girl! You could describe me as a football lover, wine & beer drinker, food indulger and occasional gym goer. 
Join one of my courses and get ready to change your life…
Browse all courses by on Classbaze.
MyExcelOnline John Michaloudis's full profile and courses »
Go to class »

8.6

Classbaze Grade®

7.8

Freshness

7.9

Popularity

9.4

Material

Detailed Analysis »

Master Microsoft Excel Power Query
Go to course »
Platform: Udemy
Price: check current price
Video: 4h 25m
Language: English
Next start: On Demand

Classbaze recommendations for you

Other courses by ​MyExcelOnline John Michaloudis

Go to class »