Excel 2003 Basic

CW-052A Excel 2003 Basic

Synopsis: This class is for the student whose goal is to become proficient using Microsoft Excel to create simple worksheets and charts that will be used for internal reports and data tracking.

Prerequisite: A basic understanding of the Window operating system and the use of the keyboard and mouse.

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. Getting Started
    1. Spreadsheet terminology
    2. Exploring the Excel window
    3. Getting help
    4. Opening and navigating workbooks
    5. Closing workbooks
       
  2. Entering and editing data
    1. Creating workbooks
    2. Entering and editing labels and values
    3. Entering and editing formulas
    4. Saving and updating workbooks
       
  3. Modifying a worksheet
    1. Moving and copying data
    2. Moving and copying formulas
    3. Using absolute references
    4. Inserting and deleting ranges
       
  4. Using functions
    1. Entering functions
    2. Using AutoSum
    3. Using AVERAGE, MIN, and MAX
       
  5. Formatting worksheets
    1. Formatting text
    2. Formatting rows and columns
    3. Formatting numbers
    4. Using Format Painter and AutoFormat
       
  6. Printing
    1. Preparing to print.
    2. Page Setup options.
    3. Printing worksheets.
       
  7. Creating charts
    1. Chart basics.
    2. Modifying charts.
    3. Printing charts.
       
  8. Web features
    1. Saving workbooks as Web pages.
    2. Hyperlinks.
    3. Sending workbooks via e-mail.