For any more recent Power Query capabilities, I recommend upgrading to Excel 2016, where the features are integrated into the Data tab. However, you can still download this version. If you are using earlier versions of Excel, then be aware that Microsoft is no longer updating the Microsoft Power Query add-in for Excel 2010/2013. Once installed, Power Query appears as a new tab in the ribbon labeled Power Query.

If you are using Excel 2010 or 2013, then Power Query is available as an add-in to download and install on your computer. Power Query For Excel 2010 Or Excel 2013. So, no matter what version of Excel you have (just about), you should be able to get your hands on Power query and get to work. In this tutorial, let’s work on how to find Power Query for Excel. Plus, it’s straightforward to use once you get it! We’ll show you how to find Power Query in Excel and how to start using it in this post. The user can reshape the data and load it into Excel or Power BI and Microsoft SQL server tools for further analysis. It is easy to use, allowing users to access multiple data types stored in numerous locations. This incredible tool allows you to easily connect to different data sources and manipulate and transform your data.

Power query is Microsoft’s Data Connectivity and Data Preparation technology.

Are you looking for a way to simplify your data analysis in Excel? If so, then you need to heck out Power Query.

How to get power query in excel 2016