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

Upon successful completion of the Microsoft Office Specialist Online Training Program, you should be able to use the Microsoft Office 2003 suite of software effectively and knowledgeably. Each program and the skills you'll learn are listed below.

In the Microsoft Excel section, you'll learn to:

• Create a spreadsheet
• Create formulas with the Function Wizard or manually
• Audit equations and troubleshoot errors
• Analyze data by using Sort, Filter, Subtotal, and PivotTables
• Format spreadsheets, graphs, and lists for printing

In the Microsoft Word section, you'll learn to:

• Create a document
• Format fonts, paragraphs, bullets, and tables
• Use tables for online forms and Web page designs
• Automate mail merges
• Share documents with a workgroup

In the Microsoft PowerPoint section, you'll learn 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 slideshow for live presentations and kiosk demonstrations

In the Microsoft Outlook section, you'll learn to:

• Use e-mail and 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

In the Microsoft Access section, you'll learn 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