Lesson 1: Using multiple worksheets and workbooks

• Linking worksheets by using 3-D formulas
• Linking workbooks
• Managing workbooks

Lesson 2: Advanced formatting

• Borders and shading
• Using special number formats
• Working with dates
• Working with styles
• Other advanced formatting

Lesson 3: Outlining and subtotals

• Outlining and consolidating data
• Creating subtotals

Lesson 4: Cell names

• Creating and using names
• Using names in multiple worksheets

Lesson 5: Lists and tables

• Examining lists
• Sorting and filtering lists
• Advanced filtering
• Working with tables

Lesson 6: Advanced charting

• Chart formatting options
• Combination charts
• Graphic elements

Lesson 7: Documenting and auditing

• Auditing features
• Comments in cells and workbooks
• Protection
• Workgroup collaboration

Lesson 8: Templates and settings

• Application settings
• Built-in templates
• Creating and managing templates

Optional Topic: Web features

• Saving workbooks as Web pages
• Using hyperlinks
• Sending workbooks via e-mail