Pinterest Pixel

Install Power Query With Excel 2013

Power Query is a new add-in that was introduced in Excel 2013 by Microsoft and was that popular that... read more

John Michaloudis
Posted on

Steps To Follow

Overview

Install Power Query With Excel 2013 | MyExcelOnline Install Power Query With Excel 2013 | MyExcelOnline

Power Query is a new add-in that was introduced in Excel 2013 by Microsoft and was that popular that they made it backward compatible with Excel 2010.

Read the tutorial on how to install Power Query in Excel 2010 here

So what is Power Query?

Well you know when you get data from a file, a data dump/import or an external data source and it comes into Excel in an ugly, unworkable format?  I can hear you say YEEEES!

Well Power Query Excel 2013 accesses, cleans and transforms all that messy data and displays it in a way that Excel loves and can work with.  The best thing is that the next time you receive the same ugly file, all you need to do is press the Refresh button and your data will automatically be cleaned up and displayed the correct way!

So no more formulas, text to columns, trim spaces, vlookup, find & replace etc.

See also  Case Insensitive Filtering Using Power Query or Get & Transform

You have all that functionality in Power Query at the press of a menu command! Now your life has just become a lot…well, a hell of a lot easier 🙂

Apart from cleaning data, Power Query can append or merge two separate tables together (bye bye VLOOKUP!) as well as create extra columns in your data which can display your custom calculations!

You can use Power Query to perform transformations that would be very complex in VBA or SQL.  So goodbye VBA coding 🙂 🙂 🙂

So how do I get your hands on this super awesome add-in…I hear you say?

First, you need to have Microsoft Office 2013.  If you do not have this then you will need to upgrade to Office 365 using this link:

https://products.office.com/en-us/home

Install Power Query With Excel 2013 | MyExcelOnline
STEP 1: The first step is to check the Excel bit version that you have on your PC.

To check the bit version, you need to go and open any Excel workbook and go to File > Account > About Excel, and from the pop-up dialogue box, you will see the bit number, either 32-bit or 64-bit.  Once you know this, close out of Excel completely!

See also  Remove Rows With Errors Using Power Query

Install Power Query With Excel 2013

 

STEP 2: You will need to click on the following link and download the Power Query add-in from Microsoft’s website:

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

How To Install Power Query in Excel 2010

STEP 3: Press the Download button and you will need to select the download bit version based on the bit system your Excel 2013 version is running (from Step 1):

How To Install Power Query in Excel 2010

Press the NEXT button…

How To Install Power Query in Excel 2010

…and this will start the download of the add-in installer .msi file installer on your browser (if you do not see this, go to your browser’s Downloads folder).

STEP 4: Click on the .msi file to run the installer:

How To Install Power Query in Excel 2010

STEP 5:  This will bring up the Microsoft Power Query for Excel Setup:

How To Install Power Query in Excel 2010

Click the Next button and accept the terms of the Licence Agreement and press Next again:

How To Install Power Query in Excel 2010

You will be asked in which destination folder you want to install Power Query Excel 2013.

Click Next for the default folder or Change if you want to install it in another folder:

See also  Extract Length Using Power Query or Get & Transform

How To Install Power Query in Excel 2010

Click Next and select the Install button:

How To Install Power Query in Excel 2010

Click Yes if it asks you if you want to install Power Query on your computer.  The install for Power Query in Excel 2013 will now begin.

You will get the following message once your install has been completed successfully.  Press Finish!

How To Install Power Query in Excel 2010

STEP 6: Open a blank Excel workbook and on the ribbon menu you should now see the Power Query tab:

Install Power Query With Excel 2013

STEP 7: If you do not see the Power Query tab you will need to activate this from the back end of Excel.

You will need to go to File > Options > Add-Ins > and at the bottom, you will need to select the Manage drop-down and choose COM Add-ins, and hit the Go button:

Install Power Query With Excel 2013

This will open the COM Add-Ins dialogue box and you will need to check the box for Microsoft Power Query for Excel and press OK.

How To Install Power Query in Excel 2010

You will now see Power Query for Excel 2013 on your ribbon!

Further Learning:

See also  Consolidate Multiple Excel Sheets Using Power Query Append

HELPFUL RESOURCE:

Now that you have successfully installed Power Query on your desktop, we have a Free Power Query webinar that will show you its best features that will make you more efficient and stand out from the crowd… Click below to register for free now:

VLOOKUP Example: Vlookup with a Drop Down List

 

If you like this Excel tip, please share it
Install Power Query With Excel 2013 | MyExcelOnline Install Power Query With Excel 2013 | MyExcelOnline
Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...