While I was preparing to work in the new (for me) Microsoft Office 365, I learned that Excel 365 already has the “built-in” Power Query add-in. It does not appear directly on the ribbon. It is located under the DATA tab.
Data Tab – entrance to Power Query in Microsoft Office 365. For previous versions of Excel, the Power Query add-in should be downloaded from the Microsoft website and installed.
The trick for me was that during the installation of the 64-bit version there was a message that the 64-bit version for MS Excel 2010 and MS Excel 2013 should be installed first. It was weird because my version is MS Excel 365.
And when I tried installing the 32-bit version, there was a message that you do not need to install the MS Excel 2016 version and that it is under the DATA tab. So this explains everything!
A pleasant surprise and few clicks less – if I knew this before.
For versions before MS Excel 2016, Power Query Add-inn should be installed from the link.
Then in Excel under FILE tab > OPTIONS > Add-Ins, we will find Microsoft Power Query for Excel
The next step will be Manage > COM Add-Ins > Go… We choose what we need and hit OK.
Now we have Power Query for Excel added to Excel.
Thank you, Magda