Administrative Professional with Microsoft Office Specialist 2007 Training GES 801 » 480 hours

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

  1. Administrative Professional
    1. The Dynamic Workplace
      1. The Workplace—Constantly Changing
      2. Workplace Team and Environment
      3. The Virtual Workplace
    2. Workforce Behaviors
      1. Your Professional Image
      2. Anger, Stress, and Time Management
      3. Ethical Theories and Behaviors
    3. Communication Essentials
      1. Written Communications
      2. Verbal Communication and Presentations
      3. Customer Service
    4. Technology Basics
      1. Technology Update
      2. Workplace Mail and Copying
      3. Telecommunications—Technology and Etiquette
    5. Records and Financial Management
      1. Managing Records
      2. Personal Finance
    6. Meetings and Travel
      1. Event Planning
      2. Travel Arrangements
    7. Career Advancement
      1. Job Search and Advancement
      2. Leadership
  2. Microsoft Certified Application Specialist Units
    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. Editing Functions
        2. Insert and Resize Pictures
        3. Time-stamp Documents
      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. Worksheets
        2. Absolute and Relative References
        3. Auditing Tool Bar
      3. Advanced
        1. Pivot tables
        2. Online Form With Drop-down Lists
        3. VLookup Function
    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
        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. Create a Distribution List
      3. Work With Attachments
      4. Archive Messages
      5. Handle Junk Mail