Excel 2003 Intermediate

CW-052B Excel 2003 Intermediate

Synopsis: Designed for the student who understands the basics of creating simple worksheets and charts, this course introduces skills for using large or multiple worksheets, advanced charting and formatting, management of files, auditing features and templates.

Prerequisite: Successful completion of Excel 2003 Basic class or equivalent experience.

Length of Course: Self-paced, average 12-18 hours per course

Required Text: Clackamas Community College custom courseware will be provided at the first class.

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