Microsoft Office Specialist 2003 (MOS) GES 811 » 300 hours

Overview Description Objectives Outline Prerequisites PC Requirements / Materials Instructor Bio See a Demo

  1. Beginning Windows
    1. Format Text and Use Commands
    2. Beginning Hardware Troubleshooting
    3. File Management and Administration Features and Procedures
  2. Word
    1. Beginning
      1. Text Editing Functions
      2. Insert and Edit Images
      3. Format Fonts and Columns
    2. Intermediate
      1. Create and Format Tables
      2. Use Mail Merge
      3. Save as Web Page
    3. Advanced
      1. Create and Modify Forms
      2. Protect the Document
  3. Excel
    1. Beginning
      1. Insert and Delete Rows and Columns
      2. Apply Number Format (Currency and Percent)
      3. Use Functions: Average and IF
    2. Intermediate
      1. Conduct Sorts
      2. Conditional Formatting
      3. Merge and Center Cells
    3. Advanced
      1. Use References (Relative and Absolute)
      2. Copy, Move, and Link Worksheets
      3. Create PivotTables
  4. PowerPoint
    1. Beginning
      1. Create a Presentation From a Template or Wizard
      2. Work With Graphics and Text Boxes
      3. Animation Effects
    2. Advanced
      1. Sound Effects
      2. Import Slides From Other Programs
  5. Access
    1. Beginning
      1. Create Queries
      2. Use and Design Tables and Forms
      3. Write and Test Update Queries
    2. Intermediate
      1. Create Forms With Subforms
      2. Use Criteria and Parameters
      3. Sorting and Grouping
    3. Advanced
      1. Automate Data Entry
      2. Create Mail Merge
      3. Optimize a Database for Multiple Users
  6. Outlook
    1. Use Mail Features
    2. Work With Contacts
    3. Work With Attachments
    4. Archive Messages
    5. Handle Junk Mail