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
Use data consolidation

Formatting Numbers
Create and apply custom number formats
Use conditional formats

Working with Ranges
Use named ranges in formulas
Use Lookup and Reference functions

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

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

Summarizing Data
Use subtotals with lists and ranges
Define and apply filters
Add group and outline criteria to ranges
Use data validation
Retrieve external data and create queries
Create Extensible Markup Language (XML) Web queries

Analyzing Data
Create a Microsoft PivotTable®, Microsoft PivotChart®, and PivotTable/PivotChart Reports
Forecast values with what-if analysis
Create and display scenarios

Workgroup Collaboration
Modify passwords, protections, and properties
Create a shared workbook
Track, accept and reject changes to workbooks
Merge workbooks