Why Use Get & Transform (Power Query)?

If your raw data set is in another place, for example: another file, text file, the web etc. you can use Power Query to import and transform the data.

You can also use it for data in the same workbook.

If you have a messy data set and you find it difficult to create formulas or a pivot table to analyze the data, Power Query can help you transform the messy data to a clean tabular data set.

Remember: Your downloadable course notes cover the most important points. Make sure you keep them handy.

YOU DID IT! CONGRATULATIONS!

You have the knowledge to succeed!