In this post I will show you how to add power query to Excel ribbon.
First, open the Excel application. Choose blank workbook.
So new workbook will be created. then click on the file menu.
Then click on the options.
Then Excel options window will pop up. Click on Add-Ins
Then select “Microsoft Power Query for Excel” and click OK.
Power Query tab will added to the Excel ribbon.
If "Microsoft Power Query for Excel" is not listed in Add-Ins list then you can download it from Microsoft website.
Search google for the Power Query.
Go to the download page. And click on the download button.
Then select the apropriate file to download according to the bit version.
