The Excel 2010 power query tab

This module introduces:

the Excel 2010 Power Query tab
the Excel 2016 Data tab item that replaces the Power Query tab
a list on other ribbon tabs from Excel 2010 (and Excel 2016)

Power query

Power Query was introduced in Excel 2010 as a COM add-in.

Its availability depended upon:

System requirements: Microsoft Office 2010 Professional Plus with Software Assurance. For Excel 2013 see https://www.microsoft.com/en-au/download/details.aspx?id=39379 [Accessed 16 February 2017]
Download the add-in from https://www.microsoft.com/en-au/download/details.aspx?id=39379 [Accessed 16 February 2017]
After installation the Power Query tab is added to the ribbon (figure 1a)

media/xlf-2010-powerquery-tab.png — **Fig 1a: Excel 2010 Power Query tab** with seven groups - 1. Get External Data; 2. Excel Data; 3. Combine; 4. Workbook Queries; 5. Settings; 6. Power BI; and 7. Help

In Excel 2016, the Power Query tab has been integrated into Excel and is available in the Get & Transform group on the Data tab (figure 1b). It is no longer an add-in.

media/xlf-2016-data-tab.png — **Fig 1b: Excel 2016 Data tab** with Get & Transform > New Query list extended. The 4 items at the bottom correspond to the 2010 Settings, and Power BI groups (shown in green)

Other Excel 2010 (and Excel 2016) ribbon tabs

The following list of ribbon tabs is provided for comparison purposes. Click the image for a full scale view.

media/xlf-2010-home-tab.png — **Fig 2: Home tab** (Windows 10) with eight groups - 1. Clipboard; 2. Font; 3. Alignment; 4. Number; 5. Styles; 6. Cells; and 7. Editing

media/xlf-2010-insert-tab.png — **Fig 3a: Insert tab** with eight groups - 1. Tables; 2. Illustrations; 3. Charts; 4. Sparklines; 5. Filter; 6. Links; 7. Text and 8. Symbols

media/xlf-2016-insert-tab.png — **Fig 3b: Excel 2016 Insert tab** with ten groups - 1. Tables; 2. Illustrations; 3. Add-ins; 4. Charts; 4. Sparklines; 5. Tours; 6. Sparklines; 7. Filter; 8. Links; 9. Text and 10. Symbols

media/xlf-2016-draw-tab.png — **Fig 4: Excel 2016 Draw tab** - available in Excel 2016 (Office 365 subscription). Five groups: 1. Tools; 2. Pens; 3. Ink Art; 4. Convert; and 5. Replay

media/xlf-2010-pagelayout-tab.png — **Fig 5: Page Layout tab** with five groups - 1. Themes; 2. Page Setup;; 3. Scale to Fit; 4. Sheet Options; and 5. Arrange

media/xlf-2010-formulas-tab.png — **Fig 6: Formulas tab** with four groups - 1. Function Library; 2. Defined names; 3. Formula Auditing; and 4. Calculation

media/xlf-2010-data-tab.png — **Fig 7: Data tab** with six groups - 1. Get External Data; 2. Connections; 3. Sort & Filter; 4. Data Tools; 5. Outline; and 6. Analysis (the Add-ins for the Analysis Toolpak, and Solver are active)

media/xlf-2010-review-tab.png — **Fig 8a: Review tab** with four groups - 1. Proofing; 2. Language; 3. Comments; and 4. Changes

media/xlf-2016-review-tab.png — **Fig 8b: Excel 2016 Review tab** with six groups. 1. Proofing; 2. Accessibility; 3. Insights; 4. Language; 5. Comments; and 6. Changes

media/xlf-2010-view-tab.png — **Fig 9: View tab** with five groups - 1. Workbook Views; 2. Show; 3. Zoom; 4. Window; and 5. Macros

media/xlf-2010-developer-tab.png — **Fig 10a: Developer tab** with five groups - 1. Code; 2. Add-ins; 3. Controls; 4. XML; and 5. Modify

media/xlf-2016-developer-tab.png — **Fig 10b: Excel 2016 Developer tab** with four groups - 1. Code; 2. Add-ins; 3. Controls; and 4. XML

This example was developed in Excel 2010 (32 bit) on Windows 7 (64 bit) (except for figure 2), and Excel 2016 (64 bit) Office 365 ProPlus on Windows 10
Revised: Saturday 25th of February 2023 - 10:12 AM, [Australian Eastern Time (AET)]