Power Query is an amazing data tool for Excel! It is built by Microsoft to help you import, transform, and automate your data processes. Checkout my overview of Power Query to learn more about it.
Bạn đang xem: Install excel 2010 power pivot
Here is a quick list of compatible versions:“Free” add-in for Excel 2010 and 2013 for Windows.Power Query is not yet available for the Mac versions of Excel.
This page will help you determine if you have the right version of Excel, and provide installation instructions.
Video Guide to Installing Power Query
What Version Do I Need?
The download page for Power Query lists which version of Excel are compatible with Power Query.
The following Office versions for Windows are supported:Microsoft Office 2016 – All VersionsMicrosoft Office 2013 – All VersionsMicrosoft Office 2010 Professional Plus with Software Assurance
Both 32-bit and 64-bit are supported. Power Query is not compatible with any Mac versions of Excel yet.
Unfortunately, if you don"t have these versions you will need to upgrade to use Power Query. To me, Power Query is worth the upgrade to Office 365 alone, and there are a lot of other cool new features too.
How Do I Check My Version of Excel?
Here"s how to determine your version and 32 or 64 bit in Excel 2010:Click the File button.Click the Help option on the left side menu.The Excel version will be listed under the Product Activated section.The bit version (32-bit or 64-bit) will be listed under the About Microsoft Excel section.
If your Excel looks like the screenshot above, then you are in luck!