2-Day Excel Power Query Series 1 - Automating Data Preparation Course (Exclusive Course)

This course is created, owned, and trained by its original creator,  Mr. Alaster Leong. Learn from the original creator.

Important Note: 

Please check the following before registering:

• The guide to check Power Query availability here.

Power Query will change the way you use Excel.

Power Query is an Excel business intelligence tool that allows you to import data from a variety of sources to be cleaned, transformed and reshaped as needed  (ETL process). Available in Excel version 2016 and above (Power Query is not available on Mac operating systems), it can be utilised to solve any challenging data analysis problems instantly. Unfortunately, many Excel users have yet to discover its existence or are simply unsure about its functions, and therefore continue to do things in the traditional “labour intensive” manner, or in the “complex” way using complex formulas.

Using Excel Power Query allows you to enjoy:

• Quick processing and combination of data from different sources including Excel, text files, web data, online services, databases, and even documents stored in SharePoint folders.
• Replacement of complex formulas with a few simple clicks
• Efficient complex data transformation that usually requires a long time (e.g., unpivoting data).

Furthermore, your actions are recorded – so once you receive new data inputs, simply click ‘Refresh’!

And these are only just a few of many examples on how using Excel Power Query can improve your workflow and data analysis. Additionally, the knowledge and skills you learn through our Power Query training can also be applied to Power BI and Power Pivot.

Benefits of Excel Power Query

You may be wondering that these all sound great, but how exactly can you use this tool at work? Utilising Excel Power Query in your daily work can:

• Change the way you interact with data in Excel and shave off hours which can be used to explore your data, develop powerful insights, and make informed decisions.
• Effectively import and clean millions of rows of data into a data model for analysis.
• Reduce the amount of work that goes into converting, cleaning, formatting, deleting and changing the formats of your source data. This saves the working time required to update the data analysis worksheet.
• Easily create queries and data connections to multiple data sources and reports that will update when new data is added to the source.
• Help to automate tedious and repetitive tasks without writing a single programming code.
• Provide you with access to an array of powerful tools for transforming data all in one place.
• Save hours of time that would have been spent manually copying and pasting via the traditional method.
• Refresh your data quickly and easily with one click.
• Reduce time spent on manual tasks.
• Allow you to set up the query to be reused with a simple refresh.

You will find our Excel Power Query – Series 1 course a lot easier and fun than you may imagine. After your Power Query training, you will walk away with tools to solve real-world problems and make a positive impact in your work.

You might not know this, but in general, the more effort you put into learning something, the more rewarding it will get. However, with our Excel Power Query course, you will yield many rewards with just a little effort. Once again, this robust Excel tool will definitely blow you away with its data transformation capabilities.

Are you ready to undergo our in-depth Power Query training to learn a Smarter, Faster and Easier way to prepare your data? Take your Excel skills to the next level and change the way you interact with this software forever.