PowerQuery: Transforming Your Work Processes in Microsoft Excel

If you can related to the following, Power Query will transform the way you work far more effectively than you have ever experienced:

• I regularly get data from multiple sources e.g. Excel files, CSV/Text files, external databases (SQL, Access etc.), and bring it into Excel and consolidate it into one table so I can analyse it.
• My data is spread over multiple Excel worksheets/workbooks and I have to consolidate it into one table so I can use it.
• The constant update of data received requires cleaning before I can use it - splitting text into multiple columns, remove columns/rows/duplicates, adding columns, Format text as dates or numbers, other random data cleaning tasks that drive me crazy and waste my time.
• I currently use Excel VBA/Macro to clean my data every week/month and it’s tedious.

What is Microsoft Excel Power Query?

Power Query, also known as Get & Transform, is a versatile tool in Microsoft Excel and Power BI programs. It empowers you to:

1. Import data from a wide variety of sources.
2. Transform that data to meet your specific needs. You can:
   • Remove columns.
   • Change data types.
   • Merge tables.
   • Perform other data shaping operations.
3. Load your transformed data into Excel or Power BI.
4. Create charts and reports based on your query.

In this training, you will learn:

• What is Power Query
• Get started with Power Query
• Consolidate/Appending Data
• Merging
• Data Cleaning