Excel 2003, Amateur's Course

Moving Around Worksheet(s)

  • Navigating with your keyboard
    • Up/Down one screen
    • Left/Right one screen
    • Back to Cell A1
    • Move to last cell
    • End Mode
    • Move to Next/Previous Sheet
    • Display Goto dialog box
    • Viewing a worksheet in multiple windows

    Working with cells and Ranges

  • Using relative, absolute, and mixed cell reference
  • Changing the types of references
  • Adding Comments to Cells
  • Using Names to work with Ranges
  • Using names for constants
  • Using names for formulas

    • Configure Excel to Suit Your Working Needs

  • Split a window to see different parts of it
  • Open extra windows to view different parts of the same worksheet
  • Hide and redisplay windows
  • Zoom the display
  • Keep key rows and columns on screen

    • Set Options to Make Excel Easier to Use

  • Choose View Options to Customize Excel's Visual Appearance
  • Understand Calculation Options
  • Set Edit Options to Fine-tune Editing Maneuvers
  • Choose General Options
  • Choose Suitable Save Options
  • Configure AutoCorrect to save time and effort
    • Workshop