Microsoft Office Specialist 2007

You'll learn basic through advanced skills for each program and the Vista operating system, and you'll be prepared for certification.
Temecula, CA P.O. Box 760,, Temecula, CA 92593
(951) 9723600

Course at a Glance

Mode of learning : Online - Instructor Lead(LVC)

Domain / Subject : Business & Management

Function : General

Trainer name : Clair Dickinson, Elizabeth Ann Nofs

Duration : 400 Hours

Difficulty : Medium

Microsoft Office Specialist 2007

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 can only be taken on a PC. It is not compatible with a Mac. It is compatible with the Windows XP and later operating systems and IE 7 and later browsers. You need a high-speed Internet connection and e-mail account. You should also have the following full-retail version Microsoft Office Products already installed: Word, Excel, PowerPoint, Outlook, and Access. It is recommended that you use the latest version of Internet Explorer in place of other Web browsers. Adobe Flash Player and Adobe Acrobat Reader are required for this program. Individual lessons from each manual can be downloaded as PDFs within the program.


To enroll in this program, you should have basic computer skills and be comfortable using an Internet browser and selecting commands from a menu or toolbar. This program is for you if you're an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft skills immediately. This program is also suitable for you if you're looking to learn about this software and expand your job possibilities.  

Course Syllabus

  • Getting Started: Beginning Word
  • Mice and Men: Beginning Word
  • WYSIWYG: Beginning Word
  • Save it for a Rainy Day: Beginning Excel
  • Open for Business: Beginning Excel
  • Be My Neighbor: Intermediate Word
  • Charlotte's Web Site: Intermediate Word
  • The Paperless Office: Outlook
  • What Time Is It? Intermediate Excel
  • Sound Advice: Intermediate Excel
  • Get Smart: Advanced Word and Excel
  • The Good, The Bad, and the Really Ugly: Advanced Word and Excel
  • Reach for the Stars: Beginning PowerPoint
  • Show Me: Advanced PowerPoint
  • The Opening Scene: Beginning Access
  • The Director's Cut: Intermediate Access
  • The Indie Scene: Advanced Access


Write Your Own Review

Write your review here (required)

Is the price of course overrated?
would you recommend this course to others?
Is duration of the course sufficient enough?
Did you like the faculties?
What would you prefer in future classroom or online learning?

Disclaimer: The contents of the course & Institute are obtained from the institute’s website by automated scraping or manual updates. For the latest information, please refer the institute website directly. For any discrepancies in the content, contact us at