Power Query is a powerful data connectivity and data transformation tool that is available in Microsoft Excel. It allows you to connect to a wide range of data sources, such as spreadsheets, databases, and cloud services, and to easily manipulate, shape, and transform the data to meet your needs.
You learn to install and use Power Query in Excel.
Download
It is an extra tool which can be installed in the same way we add onther Add-ins. We can download the add_in from the following link, and choose a desired language, then press download.
You will have to choose the version as per your Excel installation (32 bit or 64 bit). Wait for it to download, and then install it.
Open Microsoft Excel, and click File.
Click Options.
Click on Add-ins, Browse manager to COM Add-ins, and then press Go.
Check the Microsoft Power Query for Excel, and then press Ok.
Get data
Now, click on Power Query, then choose any options in the Get External Data.
Note: This tutorial article uses online search that is also in the Get External Data.
Write something relevant to search, and click on search.
Note: You could now click on the result, and choose the kind of data you would like to display. This is just one example of how to use the Power Query, as there are a lot of other ways to use it.
