Contents
Cal Poly Pomona

Computer Development & Training

MS 2003 Excel - Beginning

Dates / Times:

Wednesday, August 23, 2006; 9:00 a.m. - 4:00 p.m.

Registration Form

Instructor:

California Computer Schools, Inc.

This course is coordinated through Organizational Development & Training.

Pre-requisite:

Experience working in the Microsoft Windows environment.

Course Description / Curriculum

  • Moving with the keyboard and mouse
  • Methods for entering data in a spreadsheet
  • Making changes to spreadsheet data
  • Using Cancel/Undo/Redo
  • Methods for selecting data
  • Clearing Cells
  • Inserting cells, rows, and columns
  • Deleting cells, rows, and columns
  • Using Spell Check
  • Methods to move data (cut and paste)
  • Methods to copy data (copy and paste)
    • Aligning data in cells
    • Horizontal alignment
    • Vertical alignment
    • Rotating text
    • Wrapping text
  • Change column width or use Auto-Fit
  • Change row height or use Auto-Fit
  • Hiding and unhiding columns and rows
  • Save files and use Save As to copy a file
  • Closing files
  • Opening an existing file
  • Creating a new workbook
  • Writing Formulas
    • Edit formulas and fix common errors
    • Filling formulas
    • Mouse shortcut to fill formulas
    • How the AutoSum feature works
    • Use absolute references in formulas
  • Select and change number formats
  • Change viewing options
  • Freezing vertical/horizontal panes
  • Creating manual page breaks
  • Using Print Preview
  • Page Setup:
    • Orientation, scaling and paper size
    • Margins, centering text on page
    • Custom headers and footers
    • Print area and row/column headings
  • Deleting Files