1. Data Tab
2. Sort & Filter Group

• Auto Filter

1. Data Tab
2. Sort & Filter Group
3. Filter

Filter

• Show All

1. Data Tab
2. Sort & Filter Group
3. Clear

Filter

• Advanced Filter

1. Data Tab
2. Sort & Filter Group
3. Advanced

1. Office Button
2. Excel Options
3. Customize
4. Click All Commands
5. Click Form to add to Quick Access Toolbar

1. Data Tab
2. Outline Group
3. Subtotal

1. Data Tab
2. Data Tools Group
3. Data Validation

1. Data Tab
2. Data Tools
3. Click What-If Analysis
4. Click Data Table

1. Data Tab
2. Data Tools
3. Click Text to Columns

1. Data Tab
2. Data Tools
3. Consolidate

• Hide Detail

1. Data Tab
2. Outline Group
3. Click Hide Detail

• Show Detail

1. Data Tab
2. Outline Group
3. Click Show Detail

• Group

1. Data Tab
2. Outline Group
3. Group

• Ungroup

1. Data Tab
2. Outline Group
3. Ungroup

• Auto Outline

1. Data Tab
2. Outline Group
3. Click Group

• Clear Outline

1. Data Tab
2. Outline Group
3. Click Ungroup
4. Click Clear Outline

• Settings

1. Data Tab
2. Outline Group

1. Insert Tab
2. Tables Group
3. Click Pivot Table

• Import Data

1. Data Tab
2. Get External Data Group
3. From Other Sources

• New Web Query

1. Data Tab
2. Get External Data Group
3. Click From Web

• New Database Query

1. Office Button
2. Excel Options
3. Customize
4. Click All Commands
5. Click New Database Query to add to Quick Access Toolbar

• Edit Query

1. Office Button
2. Excel Options
3. Customize
4. Click All Commands
5. Click Edit Query to add to Quick Access Toolbar

• Data Range Properties

1. Data Tab
2. Connections Group
3. Click Properties

• Create List

1. Insert Tab
2. Tables Group
3. Table

• Resize List

1. When Table is selected
2. On Design Tab
3. In Properties Group
4. Click Resize Table

• Total Row

1. When Table is selected
2. On Design Tab
3. Table Style Options Group
4. Total Row

• Convert to Range

1. When Table is Selected
2. On Design Tab
3. Tools Group
4. Convert to Range

• Publish List

1. When Table is Selected
2. Data Tab
3. External Data Group
4. Click Export
5. Click Export to List

• View List on Server

1. When Table is Selected
2. Data Tab
3. External Table Data Group
4. Click Open in Browser

• Unlink List

1. When Table is Selected
2. Data Tab
3. In External Table Data Group
4. Click Unlink

• Synchronize List

1. When Table is Selected
2. Data Tab
3. In External Table Data Group
4. Click Refresh

• Discard Changes and Refresh

1. When Table is Selected
2. Data Tab
3. In External Table Data Group
4. Click Refresh
5. Click Cancel Refresh

• Hide Border of Inactive Lists

1. Not available in 2007

• Import

1. Developer Tab
2. XML Group
3. Import

• Export

1. Developer Tab
2. XML Group
3. Export

• Refresh XML Data

1. Developer Tab
2. XML Group
3. Refresh Data

• XML Source

1. Developer Tab
2. XML Group
3. Click Source

• XML Map Properties

1. Developer Tab
2. XML Group
3. Click Map Properties

1. Data Tab
2. Connections Group
3. Refresh All