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

Created by: MyExcelOnline John Michaloudis
Chief Inspirational Officer at MyExcelOnline

Created by: Bryan Hong
Author, Data Analysis Ninja

What Will I 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

Requirements

• 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

Target audience

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