Templates & Validating Data
Using Built-In Templates
User-Defined Templates
Validating Data
Using Pick Lists
Circling Invalid Data
Summary

Managing your Workbooks
Auditing a Worksheet
Correcting Worksheet Errors
Protecting Your Workbook
Using AutoRecover
Summary

Using Analyis Tools
What-If Analysis
Using the Goal Seeking Tool
Using the Solver
Using a Data Table
Multiple Formulas in a Data Table
Using Trendlines
Using PivotTables
Analysis ToolPak

Workbook versus links and workspaces

Working with Scenarios
Summary

Collaborating with Others
Consolidating Data
Looking at Workgroup Functions
Merging Workbooks
Linking Worksheets & Workbooks
Changing and Displaying Workbook Properties
Summary
Importing and Exporting Data
Save as Web Page
Importing Data
Using XML
Summary
Using Macros & Custom Forms
Customizing Toolbars
Using Macros in Excel
Using Digital Certificates
Creating Forms with Controls
Changing Excel Options
Summary