- Course
Automate Microsoft Excel with Power Query
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.
Intermediate
- Course
Automate Microsoft Excel with Power Query
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.
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
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.
Automate Microsoft Excel with Power Query
Intermediate
Table of contents
With over 20 years of experience on Microsoft infrastructure, data and collaboration software, Emilio Melo has a newly found passion and enthusiasm for the incredible potential of the cloud.
