The Microsoft Office Specialist program is the only comprehensive, performance-based certification program approved by Microsoft to validate business computer skills using Windows Vista and Microsoft Office® 2007: Excel, Word, Power Point, and Outlook.
Certification can help you differentiate yourself in today's competitive job market, broaden your employment opportunities, and garner greater earning potential. Certification can help you advance in your current job. Mastering more skills increases your effectiveness and efficiency. Research indicates that certified professionals are more confident and productive with Microsoft programs.
Many employers consider certification in determining who to hire. Certification can be the difference in whether or not you get a job, or get a better job. Students who complete MOS or MCAS certification training earn more (about 12%) than employees who are not certified. In addition, 82% of the students who get certified report getting a bonus upon receiving their certification.
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 6 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 6 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 6 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 6 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.
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.
This course 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
Students who enroll in this program should have basic computer skills including how to turn on the computer, how to use an Internet browser and how to select commands from a menu or toolbar.
The audience for this course includes:
• Office workers, managers, entrepreneurs, teachers, and military personnel who want to start using advanced skills immediately.
• Job training and professional development (WIA), as well as retired and unemployed people looking to expand their job possibilities.
You will need the following Microsoft products already installed on your computer in order to take this course: Windows XP or Windows Vista, and Microsoft Word 2007.
Adobe Acrobat Reader (free version), Flash Player
You will need Internet access. If your internet service provider uses only dial-up, a minimum of 56K connection rate is recommended; however, high speed access (Cable or DSL) is preferred.
This course cannot be taken from a Mac computer.
Books included with this course: The Beginning Guide to Microsoft Word 2007, The Intermediate Guide to Microsoft Word 2007, The Advanced Guide to Microsoft Word 2007, The Beginning Guide to Microsoft Excel 2007, The Intermediate Guide to Microsoft Excel 2007, The Advanced Guide to Microsoft Excel 2007, The Complete Guide to Microsoft Outlook 2007, The Complete Guide to Microsoft PowerPoint 2007, The Beginning Guide to Microsoft Access 2007, The Intermediate Guide to Microsoft Access 2007, The Advanced Guide to Microsoft Access 2007, The Complete Guide to Windows Vista
This course includes: 180-day FREE trial of Microsoft Office 2007 Professional And: Microsoft Office 2007 and Windows Vista CourseNotes from Course Technology