Unit
1: Working with large worksheets
Topic A: Viewing options
Topic B: Hiding, displaying, and outlining data
Topic C: Printing large worksheets
Unit
2: Using multiple worksheets and workbooks
Topic A: Using multiple worksheets
Topic B: Linking worksheets by using 3-D formulas
Topic C: Consolidating data
Topic D: Linking workbooks
Topic E: Managing workbooks
Unit
3: Customizing Excel
Topic A: Using the Options dialog box
Topic B: Customizing toolbars and menus
Unit
4: Advanced formatting
Topic A: Borders and shading
Topic B: Using special number formats
Topic C: Working with dates
Topic D: Working with styles
Topic E: Other advanced formatting
Unit
5: List management
Topic A: Examining lists
Topic B: Sorting and filtering lists
Topic C: Advanced filtering
Unit
6: Advanced charting
Topic A: Chart formatting options
Topic B: Using combination charts
Topic C: Using graphic elements
Unit
7: Documenting and auditing
Topic A: Auditing features
Topic B: Comments and text boxes
Topic C: Protection
Topic D: Workgroup collaboration
Unit
8: Using templates
Topic A: Built-in templates
Topic B: Creating and managing templates
Appendix
A: Web discussions
Topic A: Creating and responding to Web discussions
|
