Requisite: Excel 2003-Level 3 or equivalent experience

Fee:

$150

Unit 1: Advanced formulas, functions, and arrays
Topic A: Text functions
Topic B: Information functions
Topic C: Array formulas
Topic D: Label

Unit 2: Advanced editing and formatting
Topic A: The Paste Special command
Topic B: The Go To Special dialog box
Topic C: Advanced formatting features

Unit 3: Advanced graphics
Topic A: Creating a custom chart
Topic B: Working with pictures

Unit 4: Analyzing and sharing information
Topic A: Using add-ins
Topic B: Solver models and reports
Topic C: Statistical analysis tools
Topic D: Embedding and linking

Unit 5: Advanced customization
Topic A: Custom lists
Topic B: Changing default settings
Topic C: Automating Excel