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