Microsoft Office Specialist 2007

Seattle Central Community College

Enroll Now!

Have More Questions?
Career Training Program
Program Code: GES804
Hours: 400
Fees: $1995.00 USD



The Microsoft Office Specialist Online Training Program (formerly the Microsoft Certified Application Specialist, or MCAS) is a performance-based certification program approved by Microsoft to assess and validate computer skills using the Microsoft Office 2007 suite of programs: Excel, Word, PowerPoint, Access, and Outlook, as well as Windows Vista. You'll learn basic through advanced skills for each program and the Vista operating system, and you'll be prepared for certification.

This online certificate program is offered in partnership with major colleges, universities, and other accredited education providers.


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

Contact Us