Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

Learn how to install Power Query with this step-by-step tutorial for Excel 2010 or 2013. If you have Excel 2016 then Power Query is already built-in and located on the Data tab of the ribbon.

The first step is to determine what bit version of Excel you have, 32-bit or 64-bit. This can be found on the File menu under Help (2010) or Account (2013).

Once you know the bit version you can install Power Query from the following link.

http://www.microsoft.com/en-us/download/details.aspx?id=39379

Next, completely close Excel. You might need to close other Office apps like Outlook or Power Point.

Run the Power Query installer.

Once it finishes, open up Excel. You should see the Power Query tab in the Ribbon.

Here is a link to an article with step-by-step instructions.

http://www.excelcampus.com/install-power-query/

Checkout my article on an overview of Power Query to learn more.

https://www.excelcampus.com/powerquery/power-query-overview/
00:00 Introduction
00:37 Determine Excel Bit Version
01:19 Download Power Query
02:58 Power Query Tab