Data is everywhere and Excel has been increasingly capable of leveraging external data into your spreadsheets. This course will teach you how to use the Power Query feature to obtain, treat, and load data into Excel.

What you'll learn
Gone are the days when Excel was limited to manually typed data. In this course, Automate Microsoft Excel with Power Query, you'll gain the ability to extract, transform, and load data into Excel, using the Power Query feature. First, you'll explore options to load data from various data sources. Next, you'll discover how to effectively transform this data according to your needs. Finally, you'll learn how to load this data into Excel. When you're finished with this course, you'll have the skills and knowledge of Power Query needed to obtain and transform data into Excel.