Microsoft Office Specialist (MOS): Master on Microsoft Office 2016
Credential: Microsoft Office Specialist (MOS): Master on Microsoft Office 2016
Credentialing Agency: Microsoft Corporation
Renewal Period: Lifetime
The Microsoft Office Specialist (MOS): Master on Microsoft Office 2016 credential is an advanced-level certification for candidates who demonstrate the deepest level of skills needed to proficiently use Office programs. Candidates must pass three core exams focusing on Word 2016, Excel 2016, and PowerPoint 2016 as well as one elective exam focusing on Access 2016 or Outlook 2016. 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 2016
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
Candidates must pass three core exams focusing on Word 2016, Excel 2016, and PowerPoint 2016 as well as one elective exam focusing on Access 2016 or Outlook 2016.
Written Exam 77-726 Microsoft Word 2016 Expert: Creating Documents for Effective Communication
-
Manage document options and settings
- Manage documents and templates
- Prepare documents for review
- Manage document changes
-
Design advanced documents
- Perform advanced editing and formatting
- Create styles
-
Create advanced references
- Create and manage indexes
- Create and manage references
- Manage forms, fields, and Mail Merge operations
-
Create custom Word elements
- Create and modify building blocks, macros, and controls
- Create custom style sets and templates
- Prepare a document for internationalization and accessibility
Written Exam 77-728 Microsoft Excel 2016 Expert: Interpreting Data for Insights
-
Manage workbook options and settings
- Manage workbooks
- Manage workbook review
-
Apply custom data formats and layouts
- Apply custom data formats and validation
- Apply advanced conditional formatting and filtering
- Create and modify custom workbook elements
- Prepare a workbook for internationalization
-
Create advanced formulas
- Apply functions in formulas
- Look up data by using functions
- Apply advanced date and time functions
- Perform data analysis and business intelligence
- Troubleshoot formulas
- Define named ranges and objects
-
Create advanced charts and tables
- Create advanced charts
- Create and manage PivotTables
- Create and manage PivotCharts
Written Exam 77-729 Microsoft PowerPoint 2016: Core Presentation Design and Delivery Skills
-
Create and manage presentations
- Create a presentation
- Insert and format slides
- Modify slides, handouts, and notes
- Order and group slides
- Change presentation options and views
- Configure a presentation for print
- Configure and present a slide show
-
Insert and format text, shapes, and images
- Insert and format text
- Insert and format shapes and text boxes
- Insert and format images
- Order and group objects
-
Insert tables, charts, SmartArt, and media
- Insert and format tables
- Insert and format charts
- Insert and format SmartArt graphics
- Insert and manage media
-
Apply transitions and animations
- Apply slide transitions
- Animate slide content
- Set timing for transitions and animations
-
Manage multiple presentations
- Merge content from multiple presentations
- Finalize presentations
Written Exam 77-730 Access 2016: Core Database Management, Manipulation, and Query Skills
-
Create and manage a database
- Create and modify databases
- Manage relationships and keys
- Navigate through a database
- Protect and maintain databases
- Print and export data
-
Build tables
- Create tables
- Manage tables
- Manage records in tables
- Create and modify fields
-
Create queries
- Create a query
- Modify a query
- Create calculated fields and grouping within queries
-
Create forms
- Create a form
- Configure form controls
- Format a form
-
Create reports
- Create a report
- Configure report controls
- Format a report
Written Exam 77-731 Outlook 2016: Core Communication, Collaboration and Email Skills
-
Manage the Outlook environment for productivity
- Customize settings
- Print and save information
- Perform search operations in Outlook
-
Manage messages
- Configure mail settings
- Create messages
- Format a message
- Organize and manage messages
-
Manage schedules
- Create and manage calendars
- Create appointments, meetings, and events
- Organize and manage appointments, meetings, and events
- Create and manage notes and tasks
-
Manage contacts and groups
- Create and manage contacts
- Create and manage contact groups
Exam Preparation Resources
There are a number of resources available to help you prepare for the Microsoft Office Specialist (MOS): Master on Microsoft Office 2016 examination:
-
Best Sources
- Measureup.com Microsoft practice tests
- Microsoft Certification Exam Overview
- Microsoft Certification Exam Policies and FAQ's
- Microsoft Exam 77-726 Exam Guide
- Microsoft Exam 77-728 Exam Guide
- Microsoft Exam 77-729 Exam Guide
- Microsoft Exam 77-730 Exam Guide
- Microsoft Exam 77-731 Exam Guide
- Microsoft Virtual Academy
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 2016
Renewal Period: Lifetime