DOD Civilian COOL Snapshot - Microsoft Office Specialist (MOS): Master on Microsoft Office 2013

Microsoft Office Specialist (MOS): Master on Microsoft Office 2013

Renewal Period: Lifetime

The Microsoft Office Specialist (MOS): Master on Microsoft Office 2013 credential is an advanced-level certification for candidates to demonstrate the deepest level of skills needed to proficiently use Office programs. Candidates must choose from one of three tracks: Word 2013, Excel 2013, or Traditional Office 2013 and pass the required exams for that track plus one elective exam. There are no education or experience requirements to sit for the exams.

More information can be found on the certifying agency's website.

Microsoft Office Specialist (MOS): Master on Microsoft Office 2013

The following DOD Civilian Occupations provide training and/or experience that contributes to attaining this credential:

The following Federal Occupations provide training and/or experience that contribute to attaining this credential:

	Federal Occupation	Related As
	0950 Paralegal Specialist Series	Other
	0986 Legal Assistance Series	Some
	1084 Visual Information Series	Other

The following civilian occupations are related to this credential:

Civilian Job	Bright Outlook	Registered Apprenticeship	Local Salary Info
Advertising and Promotions Managers			find local salary
Air Traffic Controllers		Apprenticeship	find local salary
Art Directors			find local salary
Audio and Video Equipment Technicians	Bright Outlook	Apprenticeship	find local salary
Audio-Visual and Multimedia Collections Specialists			find local salary
Broadcast Technicians		Apprenticeship	find local salary
Bus and Truck Mechanics and Diesel Engine Specialists	Bright Outlook	Apprenticeship	find local salary
Camera and Photographic Equipment Repairers		Apprenticeship	find local salary
Camera Operators, Television, Video, and Motion Picture		Apprenticeship	find local salary
Cartographers and Photogrammetrists	Bright Outlook	Apprenticeship	find local salary
Computer Operators		Apprenticeship	find local salary
Correctional Officers and Jailers		Apprenticeship	find local salary
Correspondence Clerks			find local salary
Court Reporters			find local salary
Data Entry Keyers		Apprenticeship	find local salary
Database Administrators	Bright Outlook	Apprenticeship	find local salary
Desktop Publishers		Apprenticeship	find local salary
Electrical and Electronics Repairers, Commercial and Industrial Equipment		Apprenticeship	find local salary
Electronic Home Entertainment Equipment Installers and Repairers		Apprenticeship	find local salary
Emergency Management Directors		Apprenticeship	find local salary
Equal Opportunity Representatives and Officers		Apprenticeship	find local salary
Executive Secretaries and Executive Administrative Assistants			find local salary
File Clerks			find local salary
Film and Video Editors	Bright Outlook	Apprenticeship	find local salary
Fine Artists, Including Painters, Sculptors, and Illustrators		Apprenticeship	find local salary
First-Line Supervisors of Mechanics, Installers, and Repairers			find local salary
First-Line Supervisors of Office and Administrative Support Workers	Bright Outlook		find local salary
General and Operations Managers	Bright Outlook		find local salary
Graphic Designers		Apprenticeship	find local salary
Hazardous Materials Removal Workers	Bright Outlook		find local salary
Heavy and Tractor-Trailer Truck Drivers	Bright Outlook	Apprenticeship	find local salary
Interviewers, Except Eligibility and Loan			find local salary
Legal Secretaries		Apprenticeship	find local salary
Mapping Technicians	Bright Outlook	Apprenticeship	find local salary
Market Research Analysts and Marketing Specialists	Bright Outlook		find local salary
Marketing Managers	Bright Outlook		find local salary
Mobile Heavy Equipment Mechanics, Except Engines		Apprenticeship	find local salary
Motion Picture Projectionists			find local salary
Multimedia Artists and Animators	Bright Outlook		find local salary
Music Directors			find local salary
Musicians, Instrumental			find local salary
Network and Computer Systems Administrators		Apprenticeship	find local salary
Office Clerks, General	Bright Outlook	Apprenticeship	find local salary
Paralegals and Legal Assistants	Bright Outlook	Apprenticeship	find local salary
Photographers		Apprenticeship	find local salary
Photographic Process Workers and Processing Machine Operators		Apprenticeship	find local salary
Producers	Bright Outlook	Apprenticeship	find local salary
Public Relations and Fundraising Managers	Bright Outlook		find local salary
Public Relations Specialists		Apprenticeship	find local salary
Radio Operators		Apprenticeship	find local salary
Security Managers			find local salary
Sound Engineering Technicians		Apprenticeship	find local salary
Surveyors	Bright Outlook		find local salary
Technical Directors/Managers	Bright Outlook		find local salary
Telecommunications Equipment Installers and Repairers, Except Line Installers		Apprenticeship	find local salary
Training and Development Specialists	Bright Outlook	Apprenticeship	find local salary
Vocational Education Teachers, Postsecondary			find local salary
Word Processors and Typists		Apprenticeship	find local salary

MINIMUM REQUIREMENTS

Eligibility Requirements

Credential Prerequisite
Experience
Education
Training
Membership
Other
Fee

Note: This credential may have multiple options for becoming eligible. Listed are the minimum requirements based on the minimum degree required.

Exam Requirements (View Details)

Exam
Written Exam
Oral Exam
Practical Exam
Performance Assessment

RECERTIFICATION SUMMARY

Renewal Period: Lifetime

Continuing Education
Exam
Continuing Education OR Exam
Fee
Other

AGENCY CONTACT INFORMATION

Microsoft Corporation

One Microsoft Way
Redmond, WA 98052-6399

Phone: (800) 636-7544

Contact Page

Candidates must select one of the following three tracks (Word 2013, Excel 2013, or Traditional Office 2013), pass all of the exams for that track, and then pass one of the elective exams if required.

Word 2013 required exams: 77-425, 77-426, and 77-420 plus one elective exam

Excel 2013 required exams: 77-427, 77-428, and 77-418 plus one elective exam

Office 2103 required exams: 77-425, 77-426, 77-427, and 77-428

Show Written Exam Requirements / Hide Written Exam Requirements

Written Exam 77-425 Microsoft Word 2013 Expert Part One

Manage and share documents (25-30%)
- Prepare documents for review
Design advanced documents (25-30%)
- Apply advanced formatting
- Apply advanced styles
Create advanced references (25-30%)
- Manage forms, fields, and mail merge operations
Create custom Word elements (20-25%)
- Create and modify building blocks
- Create custom style sets and templates

Written Exam 77-426 Microsoft Word 2013 Expert Part Two

Manage and share documents (25-30%)
- Manage multiple documents
- Manage document changes
Design advanced documents (25-30%)
- Apply advanced ordering and grouping
Create advanced references (25-30%)
- Create and manage indexes
- Create and manage reference tables
Create custom Word elements (20-25%)
- Prepare a document for internationalization and accessibility

Written Exam 77-420 Microsoft Office Excel 2013

Create and manage worksheets and workbooks
- Create worksheets and workbooks
- Navigate through worksheets and workbooks
- Format worksheets and workbooks
- Customize options and views for worksheets and workbooks
- Configure worksheets and workbooks to print or save
Create cells and ranges
- Insert data in cells and ranges
- Format cells and ranges
- Order and group cells and ranges
Create tables
- Create a table
- Modify a table
- Filter and sort a table
Apply formulas and functions
- Utilize cell ranges and references in formulas and functions
- Summarize data with functions
- Utilize conditional logic in functions
- Format and modify text with functions
Create charts and objects
- Create a chart
- Format a chart
- Insert and format an object

Written Exam 77-427 Microsoft Office Excel 2013 Expert Part One

Manage and share workbooks
- Manage workbook changes
Apply custom formats and layouts
- Apply advanced conditional formatting and filtering
- Prepare a workbook for internationalization and accessibility
Create advanced formulas
- Look up data with functions
- Apply advanced date and time functions
Create advanced charts and tables
- Create advanced chart elements
- Create and manage PivotTables

Written Exam 77-428 Microsoft Office Excel 2013 Expert Part Two

Manage and share workbooks
- Manage multiple workbooks
Apply custom formats and layouts
- Apply custom data formats
- Apply custom styles and templates
Create advanced formulas
- Apply functions in formulas
- Create scenarios
Create advanced charts and tables
- Create and manage PivotCharts

Written Exam 77-418 Microsoft Office Word 2013

Create and manage documents
- Create a document
- Navigate through a document
- Format a document
- Customize options and views for documents
- Configure documents to print or save
Format text, paragraphs, and sections
- Insert text and paragraphs
- Format text and paragraphs
- Order and group text and paragraphs
Create tables and lists
- Create a table
- Modify a table
- Create and modify a list
Apply references
- Create endnotes, footnotes, and citations
- Create captions
Insert and format objects
- Insert and format building blocks
- Insert and format shapes and SmartArt
- Insert and format images

Written Exam 77-422 Microsoft Office PowerPoint 2013

Create and manage presentations
- Create a presentation
- Format a presentation using slide masters
- Customize presentation options and views
- Configure presentations to print or save
- Configure and present slideshows
Insert and format shapes and slides
- Insert and format slides
- Insert and format shapes
- Order and group shapes and slides
Create slide content
- Insert and format text
- Insert and format tables
- Insert and format charts
- Insert and format SmartArt
- Insert and format images
- Insert and format media
Apply transitions and animations
- Apply transitions between slides
- Animate slide content
- Set timing for transitions and animations
Manage multiple presentations
- Merge content from multiple presentations
- Track changes and resolve differences
- Protect and share presentations

Written Exam 77-424 Microsoft Office Access 2013

Create and manage a database (20-25%)
- Create a new database
- Manage relationships and keys
- Navigate through a database
- Protect and maintain a database
- Print and export a database
Build tables (25-30%)
- Create a table
- Format a table
- Manage records
- Create and modify fields
Create queries (15-20%)
- Create a query
- Modify a query
- Utilize calculated fields and grouping within a query
Create forms (15-20%)
- Create a form
- Set form controls
- Format a form
Create reports (15-20%)
- Create a report
- Set report controls
- Format a report

Written Exam 77-423 Microsoft Office Outlook 2013

Manage the Outlook environment (25-30%)
- Customize Outlook settings
- Automate Outlook
- Print and save information in Outlook
- Search in Outlook
Manage messages (25-30%)
- Create a message
- Format a message
- Organize and manage messages
Manage schedules (30-35%)
- Create and manage calendars
- Create appointments, meetings, and events
- Organize and manage appointments, meetings, and events
- Create and manage notes, tasks, and journals
Manage contacts and groups (15-20%)
- Create and manage contacts
- Create and manage groups

Written Exam 77-419 Microsoft SharePoint 2013

Create and format content (25-30%)
- Navigate the SharePoint hierarchy
- Manage lists and libraries
- Manage list items
- Manage document sets
Manage SharePoint sites (30-35%)
- Manage pages
- Perform administrative tasks on sites and workspaces
- Manage Web Parts on a page
- Manage content types
- Manage users and groups
Participate in user communities (15-20%)
- Configure My Site
- Collaborate through My Site
- Add tags and notes to content
Configure and consume site search results (15-20%)
- Perform search administration at the site level
- View search results
- Perform advanced searches

Written Exam 77-421 Microsoft Office OneNote 2013

Manage the OneNote environment (25-30%)
- Manage page layout
- Configure OneNote Backstage
- Create a OneNote notebook
- Personalize OneNote
Share and collaborate wtih other users (15-20%)
- Share OneNote notebooks
- Share OneNote content via email
- Collaborate with other users in OneNote
Organize and find notes (20-25%)
- Organize notebooks
- Search for content in OneNote
- Save and manage OneNote history and backups
- Configure Quick Filing
- Create and manage tags
Edit and link content in OneNote (25-30%)
- Apply links and linked notes
- Insert files in OneNote
- Edit text in OneNote
- Insert and modify visual elements

Exam Preparation Resources

There are a number of resources available to help you prepare for the Microsoft Office Specialist (MOS): Master on Microsoft Office 2013 examination:

Best Sources

Testing Information

Testing for this credential is handled by Certiport. The test centers are located in the U.S.

To find out more, use the following links on the Certiport website:

For more information on the Microsoft Corporation testing process, visit the agency website.

RECERTIFICATION

Microsoft Office Specialist (MOS): Master on Microsoft Office 2013

Renewal Period: Lifetime

The Microsoft Office Specialist (MOS): Master on Microsoft Office 2013 credential has the following recertification information:

This certification has no recertification requirements and cannot be renewed. Once Microsoft determines that a certification no longer reflects the latest technology or is no longer relevant in the marketplace, it will be retired and will eventually transition to a Legacy status for certification holders. For the most current certification status, refer to the Retired certifications page.

Microsoft Office Specialist (MOS): Master on Microsoft Office 2013

Microsoft Office Specialist (MOS): Master on Microsoft Office 2013

Microsoft Office Specialist (MOS): Master on Microsoft Office 2013

In Demand

COOL Bucks

COOL Summary

COOL Summary

COOL Summary

Some

Most

Other

Promotion Points

Star

Skill Level

Proponent Funded

Navy Bucks

CG Bucks

Early Career

Mid Career

Late Career

Early Career

Mid Career

Late Career

LaDR

GI Bill®

ANSI

ICAC

ABSNC

NCCA

IAS

Low

Medium

High

Army e-learning

NKO e-learning

GI Bill^®