Importing and Exporting Data
Import data to Excel
Export data from Excel
Publish worksheets and workbooks to the Web

Managing Workbooks
Create, edit, and apply templates
Create workspaces
Consolidate data

Auditing a Worksheet
Check and review data
Find cells referred to in a specific formula
Find formulas that refer to a specific cell
Find errors

Formatting Numbers
Create and apply custom number formats
Use conditional formats

Using Macros
Create and record macros
Edit macros
Run macros
Working with Ranges
Use named ranges in formulas
Use Lookup and Reference functions

Customizing Excel
Customize toolbars and menus
Create, edit, and run macro

Auditing Worksheets
Audit formulas
Locate and resolve errors
Identify dependencies in formulas