Microsoft Excel Intermediate

Unit 1:  Managing Workbooks and Worksheets

Topic A:  Viewing 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         

Unit 8:  Application Settings and Templates

Topic A:  Application settings

Topic B:  Working with templates