Course Description
This course teaches intermediate-level features and functions of Excel 2003. Participants will learn how to work with large worksheets, use 3-D formulas, customize Excel's toolbars and menus, apply special cell formatting, sort and filter lists, create combination charts and trendlines, use Excel's auditing features, and work with templates.

Course Contents
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

Customization
Outlines for each program can be tailored to suit your specific training needs.

Suggested course hours Length
6 hours

Delivery Options
Three to six-hour workshops with structured agendas and outcomes
Open house style: employees come and go as work schedules permit
We will bring laptops for your convenience at no extra charge.

Cost
$100 per instructor hour plus a one-time $100 administrative fee per program.
Participant materials are extra.