77-728 Microsoft Excel Expert (Office 2016): Exam Guide and Study Roadmap
Exam 77-728 validates advanced ability to build, manage, customize, and distribute professional Excel 2016 workbooks for specialized business use. It is aimed at experienced Excel users, including accountants, financial analysts, data analysts, and commercial bankers, rather than beginners learning spreadsheet basics. This guide helps you decide whether your current skills match the expert objectives, how to sequence practice across the four assessed domains, and what to verify before scheduling an exam whose Microsoft pages contain conflicting retirement information.
What does Exam 77-728 validate?
Exam 77-728 is designed for candidates who can use Excel 2016 at an advanced level and guide other users toward appropriate feature choices. The target work is not limited to entering data or applying basic formatting; it includes specialized workbooks such as custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules.
Microsoft describes the exam as part of the requirements for Microsoft Office Specialist: Excel Expert (Office 2016) and Microsoft Office Specialist: 2016 Master. The exam page lists no related exams. That makes the exam objective set the central preparation reference: study the assessed skills outline rather than relying on a general Excel tutorial or a collection of isolated shortcuts.
A useful readiness test is whether you can start with a business requirement and select an effective Excel feature without being told the command name. For example, you should be able to decide how a workbook should be protected, how a calculation should handle changing inputs, or which chart and table structure communicates a financial or operational result clearly.
Who is the intended candidate?
The intended candidate already has a fundamental understanding of the Excel 2016 environment and is moving toward expert-level workbook work. Microsoft names accountants, financial analysts, data analysts, and commercial bankers as possible candidate roles, while also leaving room for other professionals who create and distribute specialized spreadsheets.
Do not treat a job title as a prerequisite. The practical question is whether your regular work includes multi-step calculations, structured data, reusable layouts, presentation-quality reporting, or workbook configuration. A candidate who has used Excel for years but mainly performs simple edits may still need substantial preparation because 77-728 tests purposeful feature selection and execution, not time spent using the application.
How does this differ from basic Excel certification?
The expert exam assumes more than the ability to create a workbook, manage ordinary worksheets, make straightforward charts, or use familiar formulas. Its objectives emphasize workbook settings, custom data formats and layouts, advanced formulas, and advanced charts and tables. Preparation should therefore begin with the expert skills outline, not with the broader beginner or intermediate feature list.
Microsoft’s Excel (Office 2016) certification page describes the related intermediate credential through tasks such as creating and editing a workbook with multiple sheets, using a graphic element to represent data visually, and creating common business workbooks. Those foundations still matter, but 77-728 expects you to extend them into specialized, controlled, and reusable solutions.
Which skills carry the most weight?
Advanced formulas are the largest assessed domain at 35–40% of the exam, followed by advanced charts and tables at 25–30%, custom data formats and layouts at 20–25%, and workbook options and settings at 10–15%. Use these official domain labels when allocating study time; do not prepare by treating every Excel feature as equally important.
The percentages describe domain ranges, not a guaranteed number of tasks or a pass-score calculation. Microsoft does not provide a task count or a domain-by-domain score interpretation in the supplied research. Use the ranges to prioritize practice, then cover every objective because a smaller domain can still expose a serious weakness.
Manage workbook options and settings — 10–15%
The Manage workbook options and settings domain represents 10–15% of the exam. Practice configuring a workbook to meet a project requirement, checking how settings affect usability, and making deliberate choices that improve productivity rather than changing options at random.
Build a short checklist for each practice workbook: inspect the working environment, identify settings that affect calculation or display, consider protection and accessibility needs, and confirm that the finished file behaves as intended. The point is not memorizing where every option is located; it is connecting a requirement to the correct configuration and verifying the result.
Apply custom data formats and layouts — 20–25%
The Apply custom data formats and layouts domain represents 20–25% of the exam. Study how values should appear in a professional workbook, how layout choices guide users through a model, and how custom presentation can preserve the underlying value while changing its display.
Use realistic exercises rather than decorative formatting drills. Create a budget, financial statement, invoice, or inventory schedule and decide how dates, amounts, percentages, labels, totals, and exceptions should appear. Check alignment, spacing, print-oriented structure, repeated headings, and consistency across sheets. A formatting change is successful only when the reader can interpret the workbook more reliably.
Create advanced formulas — 35–40%
The Create advanced formulas domain represents 35–40% of the exam and deserves the largest share of hands-on practice. Work from a stated calculation requirement, select the appropriate formula approach, control references carefully, and test the result with changed inputs and edge cases.
Organize formula practice by purpose: conditional business logic, lookups and retrieval, aggregation, error handling, date or financial calculations, and formulas that must remain stable when copied or extended. For every exercise, write down the expected result before entering the formula. Then alter an input, inspect precedent and dependent cells, and confirm that the workbook still communicates a correct result.
Avoid studying functions as an unconnected vocabulary list. MOS 2016 task instructions generally do not name the command, and function names may be replaced with descriptors. Train yourself to translate a requirement such as retrieving a matching record, calculating a payment schedule, or summarizing qualifying values into a formula design before looking for the feature.
Create advanced charts and tables — 25–30%
The Create advanced charts and tables domain represents 25–30% of the exam. Practice choosing a structure that fits the data, preparing the source range correctly, and adjusting the result so it is both accurate and usable in a professional report.
Build chart exercises around decisions rather than appearance. Compare trends over time, show category performance, represent financial measures with multiple axes when appropriate, and check whether scales, labels, legends, and series make the intended message clear. Microsoft specifically includes multiple-axis financial charts among expert workbook examples, so do not limit practice to one simple chart type.
For tables, practice converting and organizing structured data, maintaining consistent headers, extending calculations, and using table behavior in formulas and reports. Inspect what happens when a row is added, a filter is applied, or the source data changes. A polished table that breaks when expanded is not an expert solution.
How should you prepare for the performance-based format?
Prepare by completing workbook tasks in Excel 2016, not by memorizing command names or relying on exam dumps. MOS 2016 exams use a performance-based format with multiple projects, and task instructions generally describe the required outcome without naming the command. Your practice must therefore combine interpretation, execution, and verification.
For each exercise, use this sequence: read the business outcome, identify the affected worksheet or range, choose a feature based on its purpose, complete the task, and verify the visible and calculated result. If you cannot explain why a feature is appropriate, repeat the task from a blank or minimally prepared workbook instead of copying the previous procedure.
Practice switching between the ribbon, worksheet structure, formula bar, context menus, and other normal Excel controls. The goal is flexible application knowledge. A memorized click path can fail when the starting workbook, wording, or selected range changes.
Translate descriptive instructions into actions
When a task uses a descriptor instead of a function or command name, underline the requested outcome and the constraints. Words such as matching, qualifying, repeated, projected, protected, or displayed may indicate different solution paths. Decide what the workbook must do before deciding where the feature is located.
Keep a personal translation sheet during study. On one side, record a plain-language requirement; on the other, record the Excel feature or formula pattern that solved it, why it worked, and one condition under which it would fail. This builds recognition without pretending that a leaked task or memorized answer can predict the assessment.
Verify work instead of stopping after the first visible result
A workbook can look correct while containing a wrong reference, incomplete range, misleading axis, or formatting rule that fails on another value. Verification should be an explicit step: change source data, inspect formulas, add a record, filter a table, and review the final layout.
Use at least one positive and one negative test for calculations. For charts and tables, test a changed category or added row. For workbook settings, close and reopen the file when relevant to the behavior being checked. Record the defect and its cause; the correction is more valuable than simply repeating the finished task.
What is a practical study sequence?
Begin with a diagnostic workbook, then study in the order that combines domain weight with dependency: formulas first, charts and tables second, custom formats and layouts third, and workbook options and settings throughout. Finish with mixed projects that require several domains together. This order gives the largest domain early attention while allowing later tasks to use the formulas and data structures already practiced.
Microsoft’s exam page identifies self-paced and instructor-led preparation options, but the supplied research says learning paths and modules are not yet available for this certification and no current instructor-led courses are available for this exam. Plan around deliberate workbook practice, the official skills outline, and a suitable Excel 2016 installation rather than waiting for a Microsoft learning path.
Phase 1: establish a baseline
Create or select several ordinary Excel 2016 workbooks and attempt representative tasks without notes. Include a calculation model, a structured data sheet, a report sheet, and a workbook with multiple sheets. Mark each task as independent, slow, or unsuccessful, and separate knowledge gaps from interface-navigation mistakes.
Do not use the diagnostic as a pass prediction. Its purpose is to identify where your study time will produce the greatest improvement. A candidate who completes formulas quickly but cannot configure a reliable layout should not spend the next study session repeating formulas simply because they feel more comfortable.
Phase 2: build formula reliability
Spend the first major practice block on advanced formulas. Start with small ranges so that you can reason about each reference, then move to workbooks resembling financial statements, amortization tables, inventory schedules, and analytical summaries. Test copied formulas, blank inputs, unmatched values, boundary dates, and changed assumptions.
At the end of each session, rebuild one solution without looking at the original. Explain the formula in plain language and identify which cells are inputs, intermediate calculations, and outputs. This exposes whether you understand the model or only remember the sequence of clicks.
Phase 3: connect data structures to visual reporting
Next, combine tables, formulas, and charts in one project. Start with raw records, turn them into a dependable structure, calculate the required measures, and produce a chart that answers a defined question. Include a report that needs more than one series or axis, then review whether the visual choices support accurate interpretation.
Keep the source data, calculation area, and presentation area distinct where that makes the workbook easier to maintain. This is a practical recommendation rather than an official formatting rule, but it creates useful opportunities to test references, table expansion, chart sources, and layout consistency.
Phase 4: refine formats, layouts, and settings
Once the workbook works, make it professional and usable. Apply custom display formats, improve navigation and visual hierarchy, inspect worksheet and workbook options, and check that the result remains functional after edits. Practice customization as a response to a project requirement, not as a hunt for visually impressive effects.
Use several workbook scenarios: a professional-looking budget, a financial statement, a sales invoice, a data-entry log, and an inventory schedule. These examples are consistent with Microsoft’s stated workbook contexts and help you practice both presentation and operational use without depending on undisclosed exam content.
Phase 5: complete mixed projects under pressure
The final phase should resemble the structure Microsoft describes: several projects in a performance-based environment. Combine formulas, tables, charts, formatting, and settings in a single workbook, and set a strict working window for the project. Review errors afterward rather than restarting immediately, because diagnosis reveals which decision caused the delay or defect.
If a practice tool offers separate training and testing modes, use training mode while learning a weak skill and testing mode only after you can complete the underlying task independently. Certiport describes its CertPREP product as offering both modes and mapping its practice tests to certification objectives; confirm product availability, title selection, technical requirements, and regional terms directly before purchase.
How can you use practice tests without overfitting?
A practice test is useful when it measures whether you can perform a task and explains why a solution works. It is not useful as a substitute for Excel practice or as evidence that memorizing repeated prompts will cover the live assessment. Use results to select the next workbook exercise, not to build a list of answers.
Certiport’s listed CertPREP product supports one selected Microsoft Office Specialist title, offers Testing Mode and Training Mode, and requires a full installation of the corresponding Windows Microsoft software application for its in-app practice tests. The product page states that its single-title license allows up to 30 practice tests during a one year period and is valid in the United States only. Check the current product page for the exact offer before relying on it.
After each practice attempt, classify the problem: misunderstood requirement, chose the wrong feature, entered an incorrect formula, selected the wrong range, failed to verify, or lost time navigating. Then create a small corrective exercise. Repeating the same test without repairing the cause can produce familiarity with the practice interface rather than transferable skill.
Common practice mistakes
The most damaging mistake is treating the skills outline as a checklist of terms. Knowing that a feature exists does not prove that you can choose it under a descriptive instruction, apply it to the correct range, and confirm the outcome. A second mistake is practicing only attractive charts or formatting while avoiding formula debugging.
Do not use unauthorized exam content, leaked questions, or dumps as a preparation method. They cannot establish genuine workbook skill, may be inaccurate, and do not remove the need to interpret and complete performance tasks. Practice with legitimate software exercises, official objectives, and clearly licensed preparation resources instead.
What delivery and registration details should you confirm?
Microsoft’s supplied exam information says the assessment takes 50 minutes, is proctored, may include interactive components, and is offered through the listed exam languages on the exam page. Price is based on the country or region where the exam is proctored. Confirm the current appointment, delivery partner, language, accommodations, and fee before paying because those details can depend on location and can change.
Microsoft strongly recommends registering with a personal MSA account. An organizational work or school AAD account can create a serious records problem: Microsoft states that exam records may be lost and unrecoverable if you leave that organization. Check the Learn profile you intend to use before scheduling and make sure your legal name is correct.
For scheduling or delivery problems, the supplied credentials-support information directs candidates to the relevant exam delivery partner, including Certiport support. For legal-name updates, sign in to the intended Learn profile, open profile settings, and follow Microsoft’s update instructions. If the selected exam is unavailable in your native language, the support information says you may apply for extra exam time; request and confirm any accommodation before the appointment.
Resolve the retirement information before booking
The supplied Microsoft pages are inconsistent. The 77-728 exam page displays a retirement date of none, while the Microsoft Office Specialist: Excel (Office 2016) certification page states that the certification and related exam were retired on June 30, 2026 and replaced by Microsoft Office Specialist: Excel (Microsoft 365 Apps). Because this is a time-sensitive eligibility issue, verify the live Microsoft exam and certification pages before scheduling.
If the certification page’s retirement notice applies to your intended credential, completing the exam before the stated retirement date is important for having it applied toward that certification, as Microsoft’s exam page warns. Do not infer availability from an old search result, a third-party listing, or the presence of a booking link. Confirm the current status, eligible credential, and applicable requirements with Microsoft and the delivery provider.
Check language and account choices
The 77-728 exam page lists English, Simplified Chinese, Traditional Chinese, German, Spanish, French, Japanese, Korean, and Dutch. The broader Excel (Office 2016) certification page lists a different, broader language set for that certification context. Use the language list attached to the exact exam appointment you plan to book, not a copied list from a related page.
A personal MSA account is the safer registration choice according to Microsoft’s guidance because it keeps the certification record associated with you rather than with an employer or school directory. Confirm the profile, legal name, email access, and appointment details before completing registration.
Which resources should anchor your plan?
Start with Microsoft’s 77-728 exam page and its skills outline because they define the exam identity, candidate profile, format description, domains, languages, and scheduling context. Use the Microsoft Excel (Office 2016) certification page to check credential status and related retirement messaging. Add a practice product only after confirming that it supports the Excel Expert title and your software environment.
The supplied Microsoft pages report that no current training courses are available for this exam. That does not prevent preparation, but it means your plan should be self-directed and evidence-based: objective-by-objective practice, complete workbooks, timed mixed projects, and post-task verification. Keep a dated study log so that you can distinguish a real skill improvement from simple familiarity with one exercise.
Use support resources for administrative issues, not as a replacement for the exam outline. Credentials support can help with profile, accommodation, and certification questions, while the exam delivery partner handles appointment or delivery problems. For any conflicting retirement, price, language, or scheduling information, return to the current official page before making a decision.
A compact readiness checklist
You are closer to readiness when you can complete an unfamiliar workbook requirement without being given the command name, explain the purpose of your formula or chart choice, maintain correct references after changes, and verify the finished workbook. You should also be comfortable moving between multiple projects rather than depending on one repeated file.
Before scheduling, confirm each of the following: your Excel 2016 practice environment is available, every assessed domain has a completed project, formula errors have been diagnosed rather than ignored, chart and table sources expand correctly, custom formats remain understandable, workbook settings match the scenario, and the live Microsoft page confirms that the exam and credential are still applicable.
What should you do next?
Make the next action a diagnostic, not a purchase. Download or review the official skills outline, create one workbook that touches each domain, and record the tasks that require notes or repeated attempts. Then assign practice time first to Create advanced formulas, followed by Create advanced charts and tables, while integrating formats and workbook settings into every finished project.
After the diagnostic, build a small portfolio of practice workbooks: one calculation-heavy model, one structured data and chart report, one professionally formatted business template, and one mixed project. Reopen each file, change inputs, add data, and inspect the result. This creates the type of flexible performance the MOS 2016 format is intended to assess.
Finally, verify the live retirement status, delivery method, language, price, account, and appointment rules through the official Microsoft and exam-provider pages. Schedule only when the current information supports your intended credential and your diagnostic shows that you can solve descriptive, multi-step tasks without relying on memorized prompts.
Conclusion
Exam 77-728 calls for applied Excel 2016 expertise: interpreting requirements, building dependable formulas, structuring data, producing useful charts and tables, and configuring professional workbooks. The strongest preparation is objective-led practice in the application, followed by mixed projects and deliberate verification. Because the supplied Microsoft pages conflict on retirement status, make status confirmation the final administrative step before registration, and use the official exam page and skills outline as your primary evidence throughout preparation.
Related exams
- 77-420 exam — Excel 2013
- 77-427 exam — Excel 2013 Expert Part One
- 77-725 exam — Microsoft Word 2016 Core: Document Creation, Collaboration and Communication (MOS)
- MO-101 exam — Microsoft Word Expert (Word and Word 2019)
- 77-727 exam — Excel 2016: Core Data Analysis, Manipulation, and Presentation
- 77-731 exam — Outlook 2016: Core Communication, Collaboration and Email Skills
