Exams

Exam 77-728: Microsoft Excel Expert (Office 2016)

Expert-level candidates for the Excel 2016 exam have an advanced understanding of the Excel environment and have the ability to guide others to the proper use of the program’s features.

They create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They customize their Excel environments to meet project needs and to enhance productivity. Expert workbook examples include custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules. Candidate roles may include accountants, financial analysts, data analysts, commercial bankers, and others.

Microsoft Office Specialist (MOS) 2016 certification exams introduce a new performance-based format for improved testing of a candidate’s knowledge, skills, and abilities using the MOS 2016 programs:

  • MOS 2016 exam task instructions generally do not include the command name, as in previous versions. For example, function names are avoided and are replaced with descriptors. This means candidates must understand the purpose and common usage of the program functionality in order to successfully complete the tasks in each of the projects.
  • The MOS 2016 exam format incorporates multiple projects.

Part of the requirements for: Microsoft Office Specialist: Excel Expert (Office 2016) Microsoft Office Specialist: 2016 Master

Related exams: none

Go to Learn Profile

Schedule exam

  • 77-728: Microsoft Excel Expert (Office 2016)

    Languages: English, Chinese (Simplified), Chinese (Traditional), German, Spanish, French, Japanese, Korean, Dutch

    Retirement date: none

    Expert-level candidates for the Excel 2016 exam have an advanced understanding of the Excel environment and have the ability to guide others to the proper use of the program’s features.

    Price based on the country or region in which the exam is proctored.

    We strongly recommend that you register for an exam with a personal MSA account. If you register with an organizational (work/school) AAD account, your exam records will be lost if you leave your organization and they will be unrecoverable.
    for Microsoft Excel Expert (Office 2016)

    All objectives of the exam are covered in depth so you'll be ready for any question on the exam.

Skills measured

  • Manage workbook options and settings (10-15%)
  • Apply custom data formats and layouts (20-25%)
  • Create advanced formulas (35-40%)
  • Create advanced charts and tables (25-30%)

Download exam skills outline

Two ways to prepare

Items in this collection

  • Learning paths or modules are not yet available for this certification

There may be certifications and prerequisites related to "Exam 77-728: Microsoft Excel Expert (Office 2016)"

Exam resources

Exam Replay

Boost your odds of success with this great offer.

Your certifications

Review and manage your scheduled appointments, certificates, and transcripts.

* Pricing does not reflect any promotional offers or reduced pricing for Microsoft Certified Trainers and Microsoft Partner Network program members. Pricing is subject to change without notice. Pricing does not include applicable taxes. Please confirm exact pricing with the exam provider before registering to take an exam.

** Complete this exam before the retirement date to ensure it is applied toward your certification. After the retirement date, please refer to the related certification for exam requirements.