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.20 (227 reviews)
Udemy
platform
English
language
Microsoft
category
Microsoft Excel Power Query - Master Power Query!
3,060
students
4.5 hours
content
Jul 2020
last update
$64.99
regular price

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

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

Why take this course?

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

Screenshots

Microsoft Excel Power Query - Master Power Query! - Screenshot_01Microsoft Excel Power Query - Master Power Query! - Screenshot_02Microsoft Excel Power Query - Master Power Query! - Screenshot_03Microsoft Excel Power Query - Master Power Query! - Screenshot_04

Reviews

Ava
July 8, 2023
This course is definitely a good match for me. It enhances my prior knowledge of and basic experience in using Power Query.
Angela
November 2, 2022
I really enjoyed learning so many short cuts that I had never seen and I have used Excel for 20 years!
Lynne
July 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.
Brian
July 11, 2016
I'm learning useful ways about how to fill holes/close holes (especially the multiple holes lesson). Well worth carefully reviewing lessons 18-20 to make sure that these concepts are fully understood.
David
June 27, 2016
I enjoyed the course very much. It was pack with useful information that I have already started to use. Hats off to both instructors, many thanks.
Aron
June 15, 2016
because he hasn't taught anything yet. I know this information. Also, because when he was filtering the last bit of data he made a mistake.
DOUGLAS
June 13, 2016
Both presenters were very articulate and right-on-point. I am looking forward to the rest of the course!
Matjaz
June 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)
John
June 6, 2016
Thisisanexcellentcoursethatisfullofpracticalideas.Theinstructorsareveryknowlegeableandareabletodelivertheirpresentationsinaconfidentandengagaingmanner.Iwouldwholeheartedrecommendthecourse.IhaveprogressedthiscourseandamamazedatthenewtechniquesthatIhavelearned.ItisafantasticlearningexperienceandIreconfirmmyratingandrecommendation.
Divisha
June 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.
John
May 31, 2016
Great information on how to use Power Query to quickly clean your data to a useful datbase with little or no effort. Each step of the process detailed to ensure accuracy. Well done Guys................
Kyle
May 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!
Jeff
May 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.
Bryan
May 28, 2016
I've been a fan of John's courses and his partnership with Oz turned out great! They make a great team and I'm excited to apply these Data Cleansing techniques to my everyday work. Every single dollar is worth it for this comprehensive course.
Stefan
May 28, 2016
4,5 stars instead of fully 5 stars - the remaining 0,5 star is for future improvments of this very usefull course. Great job done here ! Congratulations for both of you and thank you !

Charts

Price

Microsoft Excel Power Query - Master Power Query! - Price chart

Rating

Microsoft Excel Power Query - Master Power Query! - Ratings chart

Enrollment distribution

Microsoft Excel Power Query - Master Power Query! - Distribution chart

Related Topics

854808
udemy ID
5/20/2016
course created date
11/28/2019
course indexed date
Bot
course submited by