Power query

The Excel 2010 power query tab


This module introduces:

  1. the Excel 2010 Power Query tab
  2. the Excel 2016 Data tab item that replaces the Power Query tab
  3. 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:


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

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