Microsoft Office Specialist (MOS): Microsoft Excel 2016 Expert
Credential: Microsoft Office Specialist (MOS): Microsoft Excel 2016 Expert
Credentialing Agency: Microsoft Corporation
Renewal Period: Lifetime
The Microsoft Office Specialist (MOS): Microsoft Excel 2016 Expert credential is targeted towards individuals who wish to demonstrate advanced skills in key Microsoft Office programs. To earn the Microsoft Office Specialist: Microsoft Excel 2016 Expert certification, candidates must pass one, performance-based exam. While there are no experience or pre-requisite requirements for this certification, candidates should understand the purpose and common usage of the program functionality in order to demonstrate proficiency with the advanced features of Excel 2016.
More information can be found on the certifying agency's website.
Microsoft Office Specialist (MOS): Microsoft Excel 2016 Expert
MINIMUM REQUIREMENTS
Attainability:
Eligibility Requirements
- Credential Prerequisite
- Experience
- Education
- Training
- Membership
- Other
- Fee
Note: This credential may have multiple options for a Service member to meet eligibility requirements. Requirements listed here are based on the minimum degree required.
Exam Requirements (View Details)
- Exam
- Written Exam
- Oral Exam
- Practical Exam
- Performance Assessment
Exam Administration (View Details)
- In-person exam
- Remote proctored on-line exam
- Third-party test vendor
RECERTIFICATION SUMMARY
Renewal Period: Lifetime
Written Exam 77-728 Excel 2016 Expert: Interpreting Data for Insights
-
Manage workbook options and settings (10-15%)
- Manage workbooks
- Manage workbook review
-
Apply custom data formats and layouts (20-25%)
- 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 (35-40%)
- 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 (25-30%)
- Create advanced charts
- Create and manage PivotTables
- Create and manage PivotCharts
Exam Preparation Resources
There are a number of resources available to help you prepare for the Microsoft Office Specialist (MOS): Microsoft Excel 2016 Expert examination:
- Best Sources
- Related Courses
An additional resource is O'Reilly Learning Safari Books Online, a searchable digital library that provides online access to thousands of books, training videos and conference sessions. See the Educational Resources section on the Related Sites page here on COOL to learn how to get free access.
Testing Information
-
Exam Administration
Credential exams may be administered in-person at a testing site, proctored on-line remotely, or have options for both. If an exam is administered through a test vendor, the third-party test vendor box will be checked. The following test administration options apply to the Microsoft Office Specialist (MOS): Microsoft Excel 2016 Expert credential where checked:
- In-person exam
- Remote proctored on-line exam
- Third-party test vendor
For more information on the Microsoft Corporation testing process, visit the agency website.
-
Third-Party Test Vendor Information
Testing for this credential is handled by the following vendor:
Pearson VUE
The test centers are located in the U.S. They also have some test centers on military bases.
To find out more, use the following links on the Pearson VUE website:
- Search for Testing Program
- Learn About Testing for Military Communities
- Agency/Certification Specific Testing Information
- Contact Pearson VUE
RECERTIFICATION
Microsoft Office Specialist (MOS): Microsoft Excel 2016 Expert
Renewal Period: Lifetime