• • 
•  
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

Microsoft Office Specialist 2003 (MOS)

GES 811 -- 120 hours

Course Objectives

Microsoft Excel
Description: The Complete Guide to Excel teaches users how to create spreadsheets from simple checkbooks to price sheets, market forecast and scenarios.

Objectives: On completion, users will be able to:
• Create a spreadsheet.
• Create formulas with the Function Wizard or manually.
• Audit equations and troubleshoot errors.
• Analyze data by Sort, Filter, Subtotal, and PivotTables.
• Format spreadsheets, graphs and lists for printing

Length: There are three levels of Excel: Beginning, Intermediate and Advanced. Each lesson has 3 or 4 modules. Each module can be completed in 30 minutes or less.

Microsoft Word
Description: The Complete Guide to Word teaches users how to create documents from simple letterheads and envelopes to custom web pages.

Objectives: On completion, users will be able to:
• Create a document.
• Format fonts, paragraphs, bullets and tables
• Use tables for on-line forms and webpage designs.
• Automate mail merges
• Share documents with a workgroup.

Length: There are three levels of Word: Beginning, Intermediate and Advanced. Each lesson has 3 or 4 modules. Each module can be completed in 30 minutes or less.

Microsoft PowerPoint
Description: The Complete Guide to PowerPoint offers examples of colorful, animated slideshows.

Objectives: On completion, users will be able to:
• Create a slideshow.
• Format fonts, paragraphs, bullets and text boxes
• Use custom animation, slide transitions and effects.
• Use graphics, sound and on-screen navigation.
• Prepare a slide show for live presentations and kiosk demonstrations.

Length: There are two levels of PowerPoint: Beginning and Advanced. Each lesson has 3 or 4 modules. A module can be completed in 30 minutes or less.

Microsoft Outlook
Description: The Complete Guide to Outlook teaches users how to set up and use email, an electronic calendar, contacts, tasks, and journal entries effectively. Security, administration and backups are also demonstrated.

Objectives: On completion, users will be able to:
• Use email, Contacts, and work with attachments safely.
• Organize the Inbox and filter junk mail.
• Schedule meetings, recurring appointments, and tasks
• Analyze Outlook data in Microsoft Excel or Access.

Length: There are three levels of Outlook: Email, Calendar, and Administration. Each lesson has 3 or 4 modules. A module can be completed in 30 minutes or less.

Microsoft Access
Description: The Complete Guide to Access teaches users how to create database tables, forms, queries and reports. The focus is on optimizing the databases for efficient data entry and generating comprehensive reports.

Course Objectives: On completion, users will be able to:
• Create tables, forms and reports.
• Use queries to find, filter, update and calculate.
• Create forms that handle data automatically
• Optimize the database for easy navigation, and data input.

Length: There are three levels of Access: Beginning, Intermediate and Advanced. Each lesson has 5 modules. Each module can be completed in 30 minutes or less.