Excel 2003, Beginner's Course


(Session 1)

Parts of An Excel Screen

  • Title Bar
    • Application close button
    • Minimize, Maximize / Restore button
  • Menu Bar
    • Ask a Question Box
    • Window close button
  • Toolbars
  • Name Box, Formula Bar
  • Work Area
    • Select All button
    • Active cell indicator
    • Column, Row headings
    • Split Boxes
    • Scrollbars
  • Task Pane
    • Task Pane Selector
  • Tab Scroll buttons, Sheet Tabs
  • Status Bar
    • Indicators: AutoCalculate, etc

    Create, Open and Save Workbook

  • Create
    • Creating a new (empty) workbook
    • From existing workbook
    • Templates on Office online
    • Templates on my computer
  • Open
    • Opens the file normally
    • Open Read-Only
    • Open as Copy
    • Open and Repair
  • Saving and closing workbooks
    • Save normal
    • file-saving options
    • Save As
    • Setting the workbook summary information

    (Session 2)

    Entering and Editing Worksheet data

  • Type of Data
    • Numeric values
    • Text
    • Formulas
  • Selecting a range of input cells before entering data
  • List ranges
  • Selecting complete rows and columns
  • Selecting noncontiguous ranges
  • Selecting multi-sheet ranges (Group Mode)
  • Using Ctrl+Enter to place information into multiple cells simultaneously
  • Automatically moving the cell pointer after entering data
  • Using AutoFill to enter a series of values
  • Using AutoComplete to automate data entry
    • Pick from list
  • Forcing text to appear on a newline within a cell
  • Using AutoCorrect for shorthand data entry
  • Entering numbers with fractions
  • Simplifying data entry by using a form
  • Using the Office clipboard to paste
  • Copying by using drag-and-drop
  • Using Smart Tags when Inserting and Pasting
  • Copying a range to other sheets

  • Workshop