Microsoft Office Specialist 2007 GES 804 » 400 hours

Upon successful completion of the Microsoft Office Specialist 2007 section of this program, you should be able to use the Microsoft Office 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

This program teaches the exam objectives for the following certification tests:

• Exam 77-600: Windows Vista
• Exam 77-601: Microsoft Word 2007
• Exam 77-602: Microsoft Excel 2007
• Exam 77-603: Microsoft PowerPoint 2007
• Exam 77-604: Microsoft Outlook 2007
• Exam 77-605: Microsoft  Access 2007