95% off Excel with Excel Data Cleansing & Power Query (Coupon)

Excel with Excel Data Cleansing & Power Query - Udemy Coupon

Get Discount


Bonus: download a free guide that reveals 11 tricks for getting the biggest discounts on Udemy courses, including this course.

Coupon & course info

Course Name: Excel with Excel Data Cleansing & Power Query

Subtitle: Microsoft Excel Data Cleansing Using Power Query, Get & Transform, Functions & Analysis for Excel 2007, 2010, 2013, 2016

Instructor: Taught by John Michaloudis, Founder of MyExcelOnline | 25,000+ Excel Students

Category: Office Productivity

Subcategory: Microsoft

Provided by: Udemy

Price: $190 (before discount)

Free coupon code: See above (no charge for coupon)

Review info & popularity

As of September 8, 2016…

Students: 2443 students enrolled

Ratings: 50 reviews

Rank: ranked #15d in Udemy Office Productivity Courses

Brief course description

This is the ultimate Microsoft Excel Data Cleansing course which has over 70 short and precise tutorials. This course was created by the No1 ranked Excel course author (John Michaloudis) and an Excel MVP & Author (Oz du Soleil)!

The course covers all of Excel´s must-know features for cleaning up and transforming messy data that gets downloaded from an external source. You will learn Excel features such as the Text, Logical and Lookup Functions & Formulas, Text to Columns, Find & Remove Duplicates, Paste Special, Conditional Formatting, Find & Replace, Go to Special, Sort & Filter, Excel Tables, Power Query (get & Transform in Excel 2016) and many more Excel tips & keyboard shortcuts!

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 tool that is available in Microsoft Excel.

(Read more about this course on the official course page.)

John Michaloudis bio

Hello fellow Excel lovers/beginners/experts/users! My name is John and I am a long time lover of Excel.; Excel and data have been my life for the past 15 years, and I’m driven by the impact that data has on peoples’ lives. I’ve seen where crap data has resulted in termination warning letters going to the wrong people, a business’ marketing efforts completely stopped, a nonprofit’s inability to apply for grants for their literacy program, a small manufacturing company guessing about inventory levels.

(Learn more about this instructor on the official course page.)

Recommended courses

If you like this course, you might also be interested in:


1. Microsoft Excel 2016 Master Class: Beginner to Advanced

Quickly learn how use Excel 2016 the right way and make your life easier and more productive in our complete course!

Taught by Bruce Myron, Productivity Specialist


2. Excel with Top Microsoft Excel Hacks

Learn these Hidden Excel Gems to Become an Excel Master

Taught by Kyle Pew, Microsoft Certified Trainer – OfficeNewb


3. Microsoft Word 2016: Beginner and Intermediate Training

Microsoft Word 2016 at Its Best (with Exercises in Every Lecture) – Boost Your Office Productivity in No Time

Taught by 365 Careers, Creating opportunities for Business & Finance students


4. SAP Materials Management Course – Your Guide to SAP ERP

Get into SAP with this SAP Material Management (SAP MM) Fundamentals Course

Taught by Dhruv Bais, Master Programmer and Machine Learning Robot


5. SAP Production Planning

Hatch as a Beginner in SAP PP by Learning the Basics of Material Production

Taught by Dhruv Bais, Master Programmer and Machine Learning Robot

Final details for this Udemy course

Languages: English

Skill level: All Levels

Lectures: 74 lessons

Duration: 5 hours of video

What you get: Use Text, Lookup & Logical Formulas & Functions to pull data out & reorganize it to your desired outcome

Target audience: New users, beginners, intermediates and advanced Excel users

Requirements: Compatible with Microsoft Excel 2007, 2010, 2013 or 2016

Access: Lifetime access

Peace of mind: 30 day money back guarantee

Availability: available online, as well as on iOS and Android

Download options: check course to see if you can download lessons