Course Outline for Microsoft Office Excel 2003, Level 2

  • Getting Started with Excel
    • An Overview of Excel
    • Navigate in Excel
    • Select Data
    • Enter Data
    • Save a Workbook
    • Obtain Help
  • Modifying a Worksheet
    • Move and Copy Data Between Cells
    • Fill Cells with Series of Data
    • Edit Cell Data
    • Insert and Delete Cells, Columns, and Rows
    • Find, Replace, and Go To Cell Data
    • Spell Check a Worksheet
  • Performing Calculations
    • Create Basic Formulas
    • Calculate with Functions
    • Copy Formulas and Functions
    • Create an Absolute Reference
  • Formatting a Worksheet
    • Change Font Size and Type
    • Add Borders and Color to Cells
    • Change Column Width and Row Height
    • Merge Cells
    • Apply Number Formats
    • Create a Custom Number Format
    • Align Cell Contents
    • Find and Replace Formats
    • Apply an AutoFormat
    • Apply Styles
  • Developing a Workbook
    • Format Worksheet Tabs
    • Reposition Worksheets in a Workbook
    • Insert and Delete Worksheets
    • Copy and Paste Worksheets
    • Copy a Workbook
  • Printing Workbook Contents
    • Set a Print Title
    • Create a Header and a Footer
    • Set Page Margins
    • Change Page Orientation
    • Insert and Remove Page Breaks
    • Print a Range
  • Customizing Layout
    • Split a Worksheet
    • Arrange Worksheets
    • Freeze and Unfreeze Rows and Columns
    • Hide and Unhide Worksheets