Microsoft Corporation

Microsoft Office Specialist (MOS): Microsoft Excel 2016 Expert

Credential: Microsoft Office Specialist (MOS): Microsoft Excel 2016 Expert  GI Bill resource
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:    high

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:

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.

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 year, no arrears will be paid. 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).

In Demand

This certification is considered in demand. The U.S. Department of Labor sponsored CareerOneStop's analysis indicates the certification is frequently mentioned in online job postings.

Click for external link to CareerOneStop's Credentials Center.

COOL Bucks

See your installation Education Service Officer for credential exam information and coordinating instructions.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

COOL Summary

Click to go to the COOL Summary page for this MOC.

Some

Credential is related to some tasks associated with the duties of the military occupation (at least one critical task but less than 80%)

Most

Credential is directly related to most of the major duties associated with the military occupation (at least 80%)

Other

Credential is related to this military occupation, but is more advanced or specialized and therefore will likely require additional education, training, or experience

CA Eligible

This certification is eligible for CA.

Star

Star credentials are MOS enhancing, as designated by the Proponent. MOS enhancing credentials are directly related to an MOS or ASI, are taught either partially or completely as part of a Program of Instruction (POI), and improves the MOS technical proficiency.

Skill Level

The Skill Level reflects the level, based on MOS training and/or experience, the Soldier should be the most prepared to successfully earn the credential. See the Table Legend for details about each level.

Navy Bucks

Credential voucher or reimbursement for credential exam, re-certification, or maintenance fee has been approved for payment through the Navy's Credential Program Office. To get a voucher request form, click Menu at the top of any page, then click "2 Complete Voucher and Apply" under Credentialing Steps.

CG Bucks

Current Coast Guard policy states all credentials listed on CG COOL may be reimbursed assuming the enlisted service member meets the eligibility requirements as outlined in the Coast Guard Voluntary Credentialing Program Policy (COMDTINST 1540.1(series))

Early Career

1-3 years experience; Enlisted E1 through E4

Mid Career

4-10 years experience; Enlisted E5 through E6

Late Career

10+ years experience; Enlisted E7 through E9

Early Career

1-3 years experience; Enlisted “A” School through E5

Mid Career

4-10 years experience; Enlisted E6 through E7

Late Career

10+ years experience; Enlisted E8 through E9

Early Career

1-6 years experience; Officer O1 through O2

Mid Career

6-12 years experience; Officer O3 through O5

Late Career

12+ years experience; Officer O6 and Above

GI Bill®

Reimbursement for exam fees has been approved for payment through the GI Bill.

Note: GI Bill approval data is updated quarterly. For the latest information, visit the WEAMS Licenses/Certifications Search page. Make sure to select "Both" in the LAC Category Type drop-down before searching.

Click to go to the external link for GI Bill licensing and certification information.

ANAB (ANSI)

This credential has been accredited by ANAB (ANSI).

Click to go to the external ANAB web site.

ICAC

This credential has been accredited by ICAC.

Click to go to the external ICAC web site.

ABSNC

This credential has been accredited by ABSNC.

Click to go to the external ABSNC web site.

NCCA

This credentialing program has been accredited by NCCA.

Click to go to the external NCCA web site.

IAS

This credential has been accredited by IAS.

Click to go to the external IAS web site.

Low

May be difficult to attain: minimum education requirement is a Bachelor's degree, and/or minimum experience is 10 or more years.

Note: In some cases “years of experience” refers to time actively on duty or while holding a certain occupation or prior certification and not always in consecutive calendar years. Additional years required for certain preliminary stages may not be included in this classification. For requirements measured in hours, 1080 hours was considered a year. For days, 365 days was considered a year. Please review all prerequisites and requirements for eligibility, and additional information for details.

Medium

Moderate ease of attainment: minimum education requirement = Associate's and/or prerequisite and/or minimum experience = more than 2 years and less than 10 years of experience.

Note: In some cases “years of experience” refers to time actively on duty or while holding a certain occupation or prior certification and not always in consecutive calendar years. Additional years required for certain preliminary stages may not be included in this classification. For requirements measured in hours, 1080 hours was considered a year. For days, 365 days was considered a year. Please review all prerequisites and requirements for eligibility, and additional information for details.

High

Highly attainable: minimum education requirement = HS or less and/or minimum experience = 2 years or less experience and no additional requirements.

Note: In some cases “years of experience” refers to time actively on duty or while holding a certain occupation or prior certification and not always in consecutive calendar years. Additional years required for certain preliminary stages may not be included in this classification. For requirements measured in hours, 1080 hours was considered a year. For days, 365 days was considered a year. Please review all prerequisites and requirements for eligibility, and additional information for details.

MOS is Military Occupational Specialty
ASI is Additional Skill Identifier
WOMOS is Warrant Officer Military Occupational Specialty
AOC is Area Of Concentration Officer
Functional Area
Branch

Army e-learning

State-of-the art Computer Based Training available for free to the Army Workforce. Click for more information.

Click here for more information.

NKO e-learning

$$ELEARN_NKO_DESC$$

Bright Outlook – new job opportunities are very likely in the future for this job

Registered Apprenticeship

An apprenticeship program is registered with the U.S. Department of Labor. Go to the Apprenticeship Finder and enter career path or location to find apprenticeship opportunities.

This is an official U.S. Marine Corps website
Updated: April 30, 2021
Top