Marine Corps COOL Snapshot - Microsoft Office Specialist (MOS): Microsoft Excel 2016 Expert

Microsoft Office Specialist (MOS): Microsoft Excel 2016 Expert

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

The following Marine Corps Enlisted MOSs provide training and/or experience that contributes to attaining this credential:

Enlisted Occupation	Occupation Type	Related As	COOL$
0111 Administrative Specialist	MOS	Most	COOL Bucks
0161 Postal Clerk	MOS	Some	COOL Bucks
0211 Counterintelligence/Human Intelligence (CI/HUMINT) Specialist	MOS	Some	COOL Bucks
0231 Intelligence Specialist	MOS	Some	COOL Bucks
0241 Imagery Analysis Specialist	MOS	Some	COOL Bucks
0261 Geospatial Intelligence Specialist	MOS	Some	COOL Bucks
0393 Light Armored Reconnaissance (LAR) Operations Chief	MOS	Some	COOL Bucks
0399 Infantry Operations Chief	MOS	Some	COOL Bucks
0844 Field Artillery Fire Control Marine	MOS	Other
0861 Fire Support Marine	MOS	Other
1711 Offensive Cyberspace Operator	MOS	Some	COOL Bucks
1721 Defensive Cyberspace Operator	MOS	Some	COOL Bucks
1799 Cyberspace Chief	MOS	Some	COOL Bucks
2621 Communications Intelligence / Electronic Warfare Operator	MOS	Some	COOL Bucks
2629 Signals Intelligence/ Electronic Warfare/Cyberspace Operations Technician	MOS	Other
2631 Signals Intelligence/Electronic Warfare Analyst	MOS	Other
2641 Cryptologic Language Analyst	MOS	Other
2651 Intelligence Surveillance Reconnaissance (ISR) Systems Engineer	MOS	Other
4421 Legal Services Specialist	MOS	Most	COOL Bucks
4512 Combat Graphics Specialist	MOS	Some	COOL Bucks
4571 Combat Videographer	MOS	Some	COOL Bucks
55XX Musician	MOS	Some	COOL Bucks
6042 Individual Material Readiness List (IMRL) Asset Manager	MOS	Some	COOL Bucks
6046 Aviation Maintenance Data Specialist	MOS	Some	COOL Bucks
7041 Aviation Operations Specialist	MOS	Some	COOL Bucks
7251 Air Traffic Controller-Trainee	MOS	Some	COOL Bucks
7257 Air Traffic Controller	MOS	Some	COOL Bucks
7291 Senior Air Traffic Controller	MOS	Some	COOL Bucks
Leader	MOS	Some	COOL Bucks
Marine Security Guard	Collateral Duty/Out of Billet MOS	Some	COOL Bucks

The following civilian occupations are related to this credential:

	Civilian Job	Job Family	Bright Outlook	Registered Apprenticeship	Local Salary Info
	Computer Operators	Office and Administrative Support		Apprenticeship	find local salary

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

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

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
- Microsoft Virtual Academy

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 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:

RECERTIFICATION

Microsoft Office Specialist (MOS): Microsoft Excel 2016 Expert

Renewal Period: Lifetime

The Microsoft Office Specialist (MOS): Microsoft Excel 2016 Expert 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.

Note: Marine Corps COOL will only pay recertification fees for the current billing cycle. Voucher requests for recertification fees must be submitted with proof of the current status of the certification (for example, a screen shot of your credentialing agency dashboard or a copy of a current fee receipt).