You’re just seconds away from leveraging Excel and power query that will make it possible for you to:

• Increase your Excel and power query skills and knowledge within hours which will get you noticed by top management and prospective employers
• Become more productive at using Excel and power query which will save your hours each day and eliminate stress at work
• Use Excel power query with confidence that will lead to greater opportunities like a higher salary and promotions

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

The course is just over 2 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.

What will you learn in this course?

In the first part of the course, you will learn the various data cleansing techniques using power query or get and transform as its name changed in Excel 2019 and Office 365.  We will show you how to:

• Clean and transform lots of data quickly
• Import data from various external sources, folders and Excel workbooks
• Consolidate data with ease
• Sort and filter data
• Merge data
• Join data
• Data shaping and flat files
• Auto clean up your data
• M functions

Who should take this course?

This course is for excel Beginners, intermediates, or advanced users. 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.