Working with Templates
Create a Workbook from an Excel Template
Create a Template
Create a Graphic
Create a Workbook from a User-Defined Template

Sorting and Filtering Data
Sort Data
Add Subtotals to a Worksheet
Filter Lists
Create and Apply Custom Filters

Importing and Exporting Data
Import Data from the Web
Import Data from an External Source
Export Data
Save a Worksheet as a Web Page
Publish a Worksheet to the Web

Working with Advanced Formulas
Share Data Among Worksheets
Create a Name for a Range of Cells
Use Functions to Create Advanced Formulas
Trace Cell Precedents
Trace Cell Dependents
Locate Errors in Formulas

Analyzing Data
Create a PivotTable Report
Create a PivotChart Report
Create Scenarios
Use Solver
Use Goal Seek

Collaborating
Insert and Edit a Hyperlink
Add and Edit Comments in a Worksheet
Create Discussion Comments
Respond to Discussion Comment