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 2 Workshop Lessons and Topics
Prerequisites: Taken Excel 2003 Fundamentals - Part 1 workshop or have the following skills: use basic workbook skills; work with ranges; and create simple formulas.

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


 Lesson 5 - Copying and Moving Data
    Copying/Cutting and Pasting Data
    Using the Paste Options Button
    Using the Paste List
    Using the Clipboard Task Pane
    Creating an Absolute Reference
    Filling Cells
    Using Drag-and-Drop Editing
    Using Undo and Redo

 Lesson 6 - Printing
    Previewing a Worksheet
    Printing the Current Worksheet
    Printing a Selected Range
    Printing a Page Range
    Printing Multiple Copies

 Lesson 7 - Using Page Setup
    Setting Margin and Centering Options
    Changing the Page Orientation
    Creating Headers and Footers
    Customizing Headers and Footers
    Changing Print Gridlines
    Repeating Row and Column Labels
    Scaling a Worksheet
    Using Page Break Preview
    Setting/Removing a Print Area

Workshop Information Page

 Lesson 8 - Formatting Numbers
    Using Number Formats
    Using the Currency Style
    Using the Percent Style
    Using the Comma Style
    Changing Decimal Places

 Lesson 9 - Formatting Text
    Formatting Cell Text
    Changing an Existing Font
    Modifying the Font Size
    Using the Bold and Italic 
    Underlining Text
    Changing the Font Color
    Rotating Text in a Cell
    Wrapping Text in a Cell
    Shrinking Text in a Cell
    Changing Cell Alignment
    Changing Text Indentation

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