• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
EngineerExcel

EngineerExcel

FREE EBOOK
  • About
  • Course
  • Free Training
  • Resources
  • Login

Installing the Power Query Add In for Excel 2010/2013


Power Query is a powerful data gathering tool included in all installations of Excel 2016.

But what do you do if you’re not using Excel 2016?

If you’re a user of Office 2010 Professional Plus or Office 2013, you can install a free Add In from Microsoft to gain this capability.

[Note: Want to learn even more about advanced Excel techniques? Watch my free training just for engineers. In the three-part video series I'll show you how to easily solve engineering challenges in Excel. Click here to get started.]

Power Query Add In for Excel 2010

If you’re using Excel 2010, you’ll first need to determine whether you have Office “Professional Plus” 2010.

To check, navigate to File>Help.

If the line beneath “Product Activated” on the right side of the screen says “Microsoft Office Professional Plus 2010”, you’re in luck.

Next, check the line underneath “About Microsoft Excel” to determine if you have 32- or 64-bit Excel.

Remember which version you have, and head to the section “Installing the Power Query Add-In” below.

Power Query Add In for Excel 2013

Power Query is compatible with all versions of Excel 2013, so you’ll only need to check whether you have 32- or 64-bit Excel.

To determine which installation of Excel 2013 you have, navigate to File>Account and click “About Excel” in the lower right.

The top line of the window that opens will tell you whether you have 32- or 64-bit Excel.

[Note: Want to learn even more about advanced Excel techniques? Watch my free training just for engineers. In the three-part video series I'll show you how to easily solve engineering challenges in Excel. Click here to get started.]

Remember which version you have, and continue below.

Installing the Power Query Add-In

Before you go any further, exit Excel completely so the install can proceed.

Next, go to the Microsoft Download Center to get the add-in.

On that page, choose your language and press “Download”

You’ll be taken to another page that prompts you to choose whether you have 32- or 64-bit Excel. Choose the appropriate one and click Next.

Once the .msi file is finished downloading, run it to install the Power Query add in.

Power Query will be installed as a new Tab in your ribbon and you’ll be able to enjoy all of the great capabilities of this add-in.

[Note: Want to learn even more about advanced Excel techniques? Watch my free training just for engineers. In the three-part video series I'll show you how to easily solve engineering challenges in Excel. Click here to get started.]

Primary Sidebar

Featured Posts

Cell Filling Shortcuts in Excel

Mass Moment of Inertia Calculator in Excel, Pt. 1

Finding an Equation Root Graphically in Excel

Using Scenario Manager to Track Design Iterations in Excel

How to Look Up Data in 3D Excel Tables

About Me: Charlie Young, P.E.

I’m a licensed professional engineer with a degree in Mechanical Engineering and over a decade of practical experience building engineering applications in Excel. My goal is to help you learn how to turn Excel into a powerful engineering tool.

If you’re interested in learning more, click the button below to receive an update whenever I have a new tip to share. I’ll also send you a copy of my free eBook “10 Smarter Ways to Use Excel for Engineering”.


Subscribe Now

Footer

SOCIAL

Keep up with EngineerExcel:
  • Email
  • RSS
  • YouTube
EngineerExcel

Free Course

Navigation

  • Home
  • About
  • Free Course
  • Excel Tips
  • Resources
  • Coupon
  • Login

Support

  • Support
  • Terms
  • Privacy

Copyright © 2021 EngineerExcel.com · Log in