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 3 Workshop Lessons and Topics
Prerequisites: Taken Excel 2003 Fundamentals - Part 1 & 2 workshops or have the following skills: use basic workbook skills; work with ranges; create simple formulas; copy and move data; how to print; setting up a page and formatting numbers and text.

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


Lesson 10
Working with Columns and Rows

    Selecting Columns and Rows
    Changing the Width of Columns
    Changing the Height of Rows
    Adjusting Columns Automatically
    Hiding Columns and Rows
    Unhiding Columns and Rows
    Inserting a Column
    Insert a Row
    Deleting a Column
    Deleting a Row

 Lesson 11 - Formatting Cells
   Using the Merge and Center Button
   Changing the Vertical Alignment
   Splitting Cells
    Using the Borders Button
    Drawing Cell Borders
   Using the Fill Color Button
    Pasting Formats
   Using the Format Painter Button
   Copying Formats to Non-adjacent Cells
   Clearing Formats
    Inserting Selected Cells
    Inserting Cut or Copied Cells
   Deleting Selected Cells

Workshop Information Page

Lesson 12
Using Automatic Formatting and Styles
    Using Automatic Formatting Features
    Applying an AutoFormat
    Changing AutoFormat Options
    Extending List Formats and Formulas
    Creating a Style by Example
    Applying a Style
    Creating a New Style
    Editing an Existing Style
    Merging Styles

 Lesson 13 - Getting Help
    Using Microsoft Excel Help
    Working with the Help Task Pane
    Using a Type a Question for Help
    Controlling Online Content Settings
    Working with Online Help
    Displaying/Hiding the Office Assistant
    Finding an Answer
    Changing Office Assistant Options
 

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