MOS

Link : http://www.microsoft.com/australia/learning/mcp/officespecialist/requirements.mspx

MOS : Microsoft Office Specialist Certification Requirements
To earn the Microsoft Office Specialist (certification for Microsoft Office or Microsoft Project) , you must pass one or more certification exams.

The exams provide a valid and reliable measure of technical proficiency and expertise by evaluating
1. your overall comprehension of Office or Microsoft Project programs
2. your ability to use their advanced features,
3. your ability to integrate the Office programs with other software programs.

Preparation guides for taking Office Specialist exams can be found on the Microsoft Office Specialist Certification TrackBuros Institute for Assessment Consultation and Outreach.

Certification Tracks

The Office Specialist program offers certification tracks for a number of Microsoft Office editions. Select the appropriate Office track below to learn about the exam requirements for each track.

•	Office 2003 Editions
•	Office XP
•	Office 2000

Office 2003 Editions Track.

Specialist Certification:
Candidates must successfully complete any one of the Specialist exams.
Word 2003 / Excel 2003 / PowerPoint 2003 / Access 2003 / Outlook 2003

Expert Certification :
Candidates must successfully complete any one of the Expert exams
Word 2003 Expert / Excel 2003 Expert / PowerPoint 2003 Expert / Access 2003Expert / Outlook 2003 Expert

Master Certification :
Candidates must successfully complete three required exams and one elective exam. Required : Word 2003 Expert / Excel 2003 Expert / PowerPoint 2003 Expert
Elective : Access 2003Expert / Outlook 2003 Expert

Preparation Guide for Microsoft Office Specialist: Excel 2003 Skill Standards This exam measures your ability to productively use Microsoft Office Excel 2003. Before taking the exam, you should be proficient in the following program skills: Creating Data and Content • Enter and edit cell content • Navigate to specific cell content • Locate, select, and insert supporting information • Insert, position, and size graphics Analyzing Data • Filter lists using AutoFilter • Sort lists • Insert and modify formulas • Use statistical, date and time, financial, and logical functions • Create, modify, and position diagrams and charts based on worksheet data Formatting Data and Content • Apply and modify cell formats • Apply and modify cell styles • Modify row and column formats • Format worksheets Collaborating • Insert, view, and edit comments Managing Workbooks • Create new workbooks from templates • Insert, delete, and move cells • Create and modify hyperlinks • Organize worksheets • Preview data in other views • Customize Window layout • Setup pages for printing • Print data • Organize workbooks using file folders • Save data in appropriate formats for different uses