Installing Power Query
The Power Query add-on is installed by default in Excel 2016 and can be found in the Get & Transform section of the Data tab. However, for Excel 2010 and 2013, the add-on needs to be downloaded and installed. You can download the most recent version from the Microsoft site.

There are three things you should know about this download package:

1. It takes admin rights to install.
2. You need to get the correct version: 32bit (x86) or 64bit (x64). This MUST match

...