Locations of Excel 2003 commands in Excel 2007 : Data

Excel 2003 Location	Excel 2007 Location
Sort	Office Button | Excel Options | Customize | All Commands | Sort
Filter | AutoFilter	Data | Sort & Filter | Filter
Filter | AutoFilter	Home | Editing | Sort & Filter | Filter
Filter | Show All	Data | Sort & Filter | Clear
Filter | Show All	Home | Editing | Sort & Filter | Clear
Filter | Advanced Filter	Data | Sort & Filter | Advanced
Form	Office Button | Excel Options | Customize | All Commands | Form
Subtotals	Data | Outline | Subtotal
Validation	Data | Data Tools | Data Validation
Table	Data | Data Tools | What-If Analysis | Data Table
Text to Columns	Data | Data Tools | Convert Text to Table
Consolidate	Data | Data Tools | Consolidate
Group and Outline | Hide Detail	Data | Outline | Hide Detail
Group and Outline | Show Detail	Data | Outline | Show Detail
Group and Outline | Group	Data | Outline | Group
Group and Outline | Group	PivotTable Tools | Options | Group
Group and Outline | Ungroup	Data | Outline | Ungroup
Group and Outline | Ungroup	PivotTable Tools | Options | Ungroup
Group and Outline | Auto Outline	Data | Outline | Group | Auto Outline
Group and Outline | Clear Outline	Data | Outline | Ungroup | Clear Outline
Group and Outline | Settings	Data | Outline | Group and Outline Settings
PivotTable and PivotChart Report	Insert | Tables | PivotTable | PivotTable/PivotChart
Import External Data | Import Data	Data | Get External Data
Import External Data | New Web Query	Data | Get External Data | From Web
Import External Data | New Database Query	Data | Get External Data | From Other Sources | From Microsoft Query
Import External Data | Edit Query	Office Button | Excel Options | Customize | All Commands | Edit Query
Import External Data | Data Range Properties	Data | Connections | Properties
Import External Data | Data Range Properties	Table Tools | Design | External Table Data | Properties
Import External Data | Parameters	Office Button | Excel Options | Customize | All Commands | Parameters
List | Create List	Insert | Tables | Table
List | Resize List	Table Tools | Design | Properties | Resize Table
List | Total Row	Table Tools | Design | Table Style Options | Total Row
List | Convert to Range	Table Tools | Design | Tools | Convert to Range
List | Publish List	Table Tools | Design | External Table Data | Export | Export Table to SharePoint List
List | View List on Server	Table Tools | Design | External Table Data | Open in Browser
List | Unlink List	Table Tools | Design | External Table Data | Unlink
List | Synchronize List	Office Button | Excel Options | Customize | All Commands | Synchronize List
List | Discard Changes and Refresh	Office Button | Excel Options | Customize | All Commands | Discard Changes and Refresh
List | Hide Border of Inactive Lists	Removed from product
XML | Import	Developer | XML | Import
XML | Export	Developer | XML | Export
XML | Refresh XML Data	Developer | XML | Refresh Data
XML | XML Source	Developer | XML | Source
XML | XML Map Properties	Developer | XML | Map Properties
XML | Edit Query	Removed from product
XML | XML Expansion Packs	Developer | XML | Expansion Packs
Refresh Data	PivotChart Tools | Analyze | Data | Refresh
Refresh Data	PivotTable Tools | Options | Data | Refresh
Refresh Data	Table Tools | Design | External Table Data | Refresh
Refresh Data	Data | Connections | Refresh | Refresh
Refresh Data	PivotChart Tools | Analyze | Data | Refresh | Refresh
Refresh Data	PivotTable Tools | Options | Data | Refresh | Refresh
Refresh Data	Table Tools | Design | External Table Data | Refresh | Refresh

Source: Microsoft (http://www.microsoft.com/)