Microsoft Excel Power Query - Master Power Query!
What you'll 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
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
Data shaping & flat files
Auto cleanup your data
In the second part of the course you will learn "Data Cleansing" techniques using various Excel features such as:
Logical and Lookup Functions
Text to Columns
Find & Remove Duplicates
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 ***
Who this course is 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!
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...
Hi! I'm an IT Software Developer for more than 10 years and have the following certifications:
Microsoft Certified Professional Developer (MCPD): Web Developer
Microsoft Certified Technology Specialist (MCTS): Windows Applications
Microsoft Certified Systems Engineer (MCSE)
Microsoft Certified Systems Administrator (MCSA)
I focus on teaching in online courses as I found my passion to reach out to students just like you. Courses I'm focused on range from SQL, Excel Formulas, Power Query, Power BI, Excel Charts, Macros and much more. My passion lies in helping my students in whatever means possible.