Skip Navigation
  Tops, Training in Office and Productivity Skills George Mason Logo
image for the corner of the table. Layout image only image for the corner of the table. Layout image only
   
image for the corner of the table. Layout image only   image for the corner of the table. Layout image only
image for the corner of the table. Layout image only

Excel 2003 Fundamentals - Part 1 Workshop Lessons and Topics
Prerequisites: Ability to work comfortably in a Windows environment, must have mouse skills, and an understanding of files and folders. Must have a basic knowledge of the Microsoft Office features, such as Cut/Copy/Paste and opening, closing, and saving files, etc.

Manual used in this workshop is "Excel 2003 Fundamentals".


 Lesson 1 - Exploring Excel
    Working with Excel
    Starting Excel
    Using the Interface
    Working with Worksheets
    Using Menu Commands
    Displaying and Hiding Toolbars
    Displaying Hidden Toolbar Buttons
    Moving and Resizing Toolbars
    Changing Menu and Toolbar Options
    Using the Task Pane
    Exiting Excel

 Lesson 2 - Using Basic Workbook Skills
    Selecting a Cell using the Keyboard
    Scrolling with the Mouse
    Using the Go To dialog box
    Entering Text into Cells
    Entering Numbers into Cells
    Saving a New Workbook
    Closing a Workbook
    Creating a New Workbook
    Using a Template
    Opening and Exiting Workbook
    Using Data Entry Shortcuts
    Editing Cell Entries
    Checking Worksheet Spelling
    Creating a New Folder
    Renaming an Existing Workbook

 Workshop Information Page

 Lesson 3 - Working with Ranges
    Working with Ranges
    Selecting Ranges with the Keyboard
    Selecting Ranges with the Mouse
    Selecting Non-Adjacent Ranges
    Entering Values into a Range
    Using the AutoFill Feature

 Lesson 4 - Creating Simple Formulas
    Using Formulas
    Entering Formulas
    Using Functions
    Using the AutoSum Button
    Using the AutoSum List
    Entering Basic Functions
    Inserting Functions in Formulas
    Editing Functions
    Using the AutoCalculate Feature
    Using Range Borders to Modify Formulas
    Checking Errors
image for the corner of the table. Layout image only
   
image for the corner of the table. Layout image only image for the corner of the table. Layout image only
image for the corner of the table. Layout image only  
image for the corner of the table. Layout image only
image for the corner of the table. Layout image only image for the corner of the table. Layout image only

Voice (703) 993-3426 | Fax (703) 993-4747 | Johnson Center 311 | 4400 University Drive, MS 5C4 | Fairfax, VA 22030