Excel Intermediate Course

Unit 1: Managing workbooks and worksheets

• Topic A: Viewing and printing large worksheets
• Topic B: Printing large worksheets
• Topic C: Working with multiple worksheets
• Topic D: Linking worksheets with 3-D formulas
• Topic E: Using multiple workbooks
• Topic F: Linking workbooks

Unit 2: Advanced formatting

• Topic A: Using special number formats
• Topic B: Working with themes
• Topic C: Other advanced formatting

Unit 3: Outlining and subtotals

• Topic A: Outlining and consolidating data
• Topic B: Creating subtotals

Unit 4: Cell and range names

• Topic A: Creating and using names
• Topic B: Managing names

Unit 5: Data structure and tables

• Topic A: Sorting and filtering data
• Topic B: Working with tables

Unit 6: Web and sharing features

• Topic A: Saving workbooks as Web pages
• Topic B: Using hyperlinks

Unit 7: Documenting and auditing

• Topic A: Auditing features
• Topic B: Comments in cells and workbooks
• Topic C: Protection
• Topic D: Workgroup collaboration