Here is an article that explains the features available for each subscription level. Power Query is available with all levels of Office 365 subscriptions. If you are using Excel 2016, go to the Data tab on the ribbon and press the New Query button to create a query and open the Power Query editor. It has been renamed and is now on the Data tab of the Ribbon in the Get & Transform section. Power Query is included with Excel 2016 (Office 365). The bit version (32-bit or 64-bit) will be listed in the first row of the pop-up window. The Excel version will be listed under the Subscription Product section.Click the Account option on the left side menu.
Here's how to determine your version and 32 or 64 bit in Excel 2013:
If your Excel looks like the screenshot above, then you are in luck! ? Again, you will need the Professional Plus version of Excel 2010.
To me, Power Query is worth the upgrade to Office 365 alone, and there are a lot of other cool new features too. Unfortunately, if you don't have these versions you will need to upgrade to use Power Query. Power Query is not compatible with any Mac versions of Excel yet.
Microsoft Office 2010 Professional Plus with Software Assuranceīoth 32-bit and 64-bit are supported.The following Office versions for Windows are supported:
The download page for Power Query lists which version of Excel are compatible with Power Query. This page will help you determine if you have the right version of Excel, and provide installation instructions. Power Query is not yet available for the Mac versions of Excel.Built-in feature for Excel 2016 for Windows (Office 365 Subscription).“Free” add-in for Excel 20 for Windows.Here is a quick list of compatible versions: Checkout my overview of Power Query to learn more about it. It includes Classic Menu for Word, Excel, PowerPoint, Access and Outlook 2007.Power Query is an amazing data tool for Excel! It is built by Microsoft to help you import, transform, and automate your data processes. It includes Classic Menu for Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, InfoPath, Visio and Project 2010, 2013, 2016, 2019 and 365. Supports all languages, and all new commands of 2007, 2010, 2013, 2016, 2019 and 365 have been added into the classic interface. You can use Office 2007/2010/2013/2016 immediately without any training. Go back to the Excel 2010 window, you will find the Developer Tab is added besides Home Tab. Click the OK button to finish customizing.įigure 4: Add Developer Tab into Excel 2010 Ribbon.At the right, select the Main Tabs from Customize The Ribbon drop down box.Click the Customize Ribbon at the left.Click the Options at the left to enter into Excel Option window.Here is the way to add Developer Tab into Excel 2010/2013/2016/2019 Ribbon: There are some differences to add Developer Tab into Ribbon between Excel 2010/2013/2016/2019 and Excel 2007. Get Design Mode in Excel 2010/2013/2016/2019 Ribbon if you do not have Classic Menu for Office Then you will view the Design Mode button there.įigure 3: Design Mode button in Excel 2007 Ribbon.Go back to the Excel 2007 window, you will find the Developer Tab is added at the far right of Ribbon. Under Top Option for Working with Excel, check the Show Developer tab in the Ribbon option.įigure 2: Add Developer Tab into Excel 2007 Ribbon.Click the Excel Option button at the bottom, then you will enter the Excel Option window.If you want to find Design Mode in Excel 2007 Ribbon, you need to add Developer tab into Excel 2007 firstly: Seek for the Design Mode on Ribbon if you do not have Classic Menu for Office Get Design Mode in Excel 2007 Ribbon if you do not have Classic Menu for Office Then you will view the Design Mode command.įigure 1: get Design Mode from Classic Menu.Click the Tools drop down menu under Menus tab.With Classic Menu for Office, you can easily find out the Design Mode command stays in the same place as where it is in Excel 2003: It is quite easy to find out the Design Mode if you have Classic Menu for Office Classic Menu for Office Home and Business.Classic Menu for Office 2007 Applications.