Sort

Data tab, Sort & Filter group, Sort command

Filter

Data tab, Sort & Filter group, Filter command

Filter, AutoFilter

Home tab, Editing group, Sort & Filter, Filter command

Filter, Show All

Data tab, Sort & Filter group, Clear command

Home tab, Editing group, Sort & Filter, Clear command

Filter, Advanced Filter

Data tab, Sort & Filter group, Advanced command

Form

You must add a button to the ribbon or the Quick Access Toolbar for this command: File tab, Options, Customize Ribbon or Quick Access Toolbar, All Commands, Form

Subtotals

Data tab, Outline group, Subtotal command

Validation

Data tab, Data Tools group, Data Validation command

Table

Data tab, Data Tools group, What-If Analysis command, Data Table command

Text To Columns

Data tab, Data Tools group, Convert Text To Table command

Consolidate

Data tab, Data Tools group, Consolidate command

Group And Outline, Hide Detail

Data tab, Outline group, Hide Detail command

Group And Outline, Show Detail

Data tab, Outline group, Show Detail command

Group And Outline, Group

Data tab, Outline group, Group command

PivotTable Tools Options tab, Group group

Group And Outline, Ungroup

Data tab, Outline group, Ungroup command

PivotTable Tools Options tab, Group group, Ungroup command

Group And Outline, Auto Outline

Data tab, Outline group, Group command, Auto Outline command

Group And Outline, Clear Outline

Data tab, Outline group, Ungroup command, Clear Outline command

Group And Outline, Settings

Data tab, Outline group, dialog box launcher button

PivotTable And PivotChart Report

Insert tab, Tables group, PivotTable command, PivotTable/PivotChart command

Import External Data, Import Data

Data tab, Get External Data group

Import External Data, New Web Query

Data tab, Get External Data group, From Web command

Import External Data, New Database Query

Data tab, Get External Data group, From Other Sources command, From Microsoft Query command

Import External Data, Edit Query

You must add a button to the ribbon or the Quick Access Toolbar for this command: File tab, Options, Customize Ribbon or Quick Access Toolbar, All Commands, Edit Query

Import External Data, Data Range Properties

Data tab, Connections group, Properties command

Table Tools Design tab, External Table Data command, Properties command

Import External Data, Parameters

You must add a button to the ribbon or the Quick Access Toolbar for this command: File tab, Options, Customize Ribbon or Quick Access Toolbar, All Commands, Parameters

List, Create List

Insert tab, Tables group, Table command

List, Resize List

Table Tools Design tab, Properties command, Resize Table command

List, Total Row

Table Tools Design tab, Table Style Options group, Total Row check box

List, Convert To Range

Table Tools Design tab, Tools group, Convert To Range command

List, Publish List

Table Tools Design tab, External Table Data group, Export command, Export Table To SharePoint List command

List, View List On Server

Table Tools Design tab, External Table Data group, Open In Browser command

List, Unlink List

Table Tools Design tab, External Table Data group, Unlink command

List, Synchronize List

You must add a button to the ribbon or the Quick Access Toolbar for this command: File tab, Options, Customize Ribbon or Quick Access Toolbar, All Commands, Synchronize List

List, Discard Changes And Refresh

You must add a button to the ribbon or the Quick Access Toolbar for this command: File tab, Options, Customize Ribbon or Quick Access Toolbar, All Commands, Discard Changes And Refresh

List, Hide Border Of Inactive Lists

Removed

XML, Import

Developer tab, XML group, Import command

XML, Export

Developer tab, XML group, Export command

XML, Refresh XML Data

Developer tab, XML group, Refresh Data command

XML, XML Source

Developer tab, XML group, Source command

XML, XML Map Properties

Developer tab, XML group, Map Properties command

XML, Edit Query

Removed

XML, XML Expansion Packs

Developer tab, XML group, Expansion Packs command

Refresh Data

PivotChart Tools Analyze tab, Data group, Refresh command

PivotTable Tools Options tab, Data group, Refresh command

Table Tools Design tab, External Table Data group, Refresh command

Data tab, Connections group, Refresh All command, Refresh command

PivotChart Tools Analyze tab, Data group, Refresh command, Refresh command

PivotTable Tools Options tab, Data group, Refresh command, Refresh command

Table Tools Design tab, External Table Data group, Refresh command, Refresh command