Power Query is an amazing tool that offer self-service Business Intelligence (BI) for excel with consistent and intuitive experience of combining, discovering, and refining data across a comprehensive range of sources such as structural, relational and semi-structural data. This tool is help you to analyses the data in business intelligence and data analytics.
Learning the Power Query in Excel & Power BI will help you advanced in Business Intelligence domain. In today’s blog, I will explain you the complete systematic process to install power query in excel. So, I recommend you, please follow all the steps with us and at the end of this blog you have installed Power Query in Excel.
Here is a quick list of compatible versions:
- Built-in feature for Excel 2016 for Windows (Office 365 Subscription).
- Power Query is not yet available for the Mac versions of Excel.
- “Free” add-in for Excel 2010 and 2013 for Windows.
Step By Step Process to Install Power Query in Excel
For excel 2010, 2013 & 2016 you will need to download the power query add-in and install it.
The Steps you should follow,
Step 1: Close (exit) Excel completely.
Step 2: Click the following link to go to the download page.
http://www.microsoft.com/en-us/download/details.aspx?id=39379
Step 3: Click the Download button.
Step 4: Click the checkbox for the bit version you are using. Most likely, you will be using 32-bit.
Step 5: Click Next
Step 6: The add-in installation file will download. Click the file to run the installation.
Step 7: The Setup Wizard window will open. Follow the steps to install Power Query
Step 8: Once the installation is complete, open Excel. You should now see the Power Query tab in the Ribbon.
If you want to learn more, please subscribe our blog and get daily updates.
newbiesexcel 