Exam 77-728: Microsoft Excel Expert (Office 2016) Study and Scheduling Guide
Exam 77-728 validates advanced Excel 2016 skills through practical, performance-based work rather than command-name recall. It is intended for professionals who create, manage, and distribute specialized spreadsheets, including accountants, financial analysts, data analysts, and commercial bankers. This guide helps you decide whether the legacy exam still fits your objective, identify the highest-value skills, build practice workbooks, and verify current retirement and scheduling information before committing to preparation.
Decide whether 77-728 is still the right exam
Check the current Microsoft certification record before scheduling. The exam page lists 77-728 as part of Microsoft Office Specialist: Excel Expert (Office 2016) and Microsoft Office Specialist: 2016 Master, while the related certification page states that the Excel (Office 2016) certification and related exam were retired on June 30, 2026 and replaced by Microsoft Office Specialist: Excel (Microsoft 365 Apps).
The supplied Microsoft pages are not fully consistent: the dedicated 77-728 page displays a retirement date of none, while the certification page gives a retirement date of June 30, 2026. Treat the dedicated scheduling page and the certification record as live checkpoints, not as interchangeable summaries. If the exam is no longer schedulable, use the replacement certification information rather than preparing for an unavailable assessment.
This distinction matters if your employer, school, or certification plan requires a particular Office version. A current Excel certification may demonstrate a different product target from a legacy Office 2016 exam. Confirm the credential name, exam code, and whether a completed 77-728 attempt will still count toward your intended certification before paying or booking.
What the exam validates
77-728 is designed for candidates with an advanced understanding of the Excel environment who can guide other users in using Excel features correctly. The practical target is not simply familiarity with formulas; it is the ability to produce professional workbooks for specialized business purposes and adapt the Excel environment to project requirements.
Microsoft’s examples of expert workbooks include custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules. Other workbook examples associated with the Excel certification include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.
These examples suggest a useful preparation standard: build workbooks that are structured, readable, reusable, and suitable for another person to operate. A technically correct formula in an unmanaged workbook is weaker practice than a formula supported by clear layout, sensible controls, appropriate formatting, and an output that communicates the result.
Who benefits most from the credential
The stated candidate roles include accountants, financial analysts, data analysts, commercial bankers, and comparable business users who work with specialized spreadsheets. The exam is also relevant to experienced Excel users who need a formal measure of advanced Office 2016 capability or who are completing requirements for the Excel Expert or 2016 Master credential.
Do not interpret the word expert as a guarantee that every advanced Excel feature is assessed. Use the official domains as the boundary for study, then use realistic workbooks to combine those skills. If your goal is primarily modern Microsoft 365 functionality, first investigate the replacement certification rather than assuming that 77-728 is the best current route.
Understand the performance-based format
MOS 2016 exams use a performance-based format with multiple projects. Task instructions generally do not name the command, and function names may be replaced by descriptions. You therefore need to recognize the intended result and choose the appropriate Excel feature, not merely remember where a named command appears on the ribbon.
For example, preparation should include translating a business request into an operation: identify a calculation requirement, determine the appropriate formula approach, place it in the correct range, and confirm that the result behaves correctly when inputs change. Do the same for chart, table, layout, and workbook-setting tasks.
This format changes how practice should be measured. A study session is incomplete if you can explain a function but cannot apply it in an unfamiliar workbook. Practice from the outcome backward: read a requirement, infer the feature, perform the work, inspect the output, and save a clean final file.
Avoid command-name dependence
A common mistake is learning a sequence such as “click this command, then choose that option” without understanding the task’s purpose. Because MOS 2016 instructions may use descriptors instead of command or function names, create prompts that describe the business result and force yourself to select the method.
Keep a personal translation list while studying. On one side, write a plain-language requirement such as returning a value from a related table or combining conditions. On the other, record the Excel feature or formula pattern that solves it. Review the reasoning, not just the label.
Use the blueprint to allocate study time
The official blueprint places the greatest emphasis on Create advanced formulas, followed by Create advanced charts and tables, Apply custom data formats and layouts, and Manage workbook options and settings. Start with advanced formulas, but reserve time for every domain because a narrow study plan leaves weaknesses in practical workbook construction.
Create advanced formulas represents 35–40% of the exam domain. Create advanced charts and tables represents 25–30% of the exam domain. Apply custom data formats and layouts represents 20–25% of the exam domain. Manage workbook options and settings represents 10–15% of the exam domain.
These ranges are domain weights, not a promise about a particular task sequence or score. Use them to prioritize repetitions: spend the largest practice block on formula design, then combine charts and tables with formatted business outputs. Give workbook settings a smaller but deliberate review rather than ignoring it.
Manage workbook options and settings: 10–15%
The Manage workbook options and settings domain represents 10–15% of the exam. Practice configuring a workbook for its intended users and project requirements, then check whether those choices improve navigation, consistency, and productivity rather than changing settings randomly.
Build a small template and review its workbook-level decisions. Ask whether sheets are organized logically, whether the working environment supports the task, and whether the file is ready to distribute. Because the official description emphasizes customization for project needs, connect each setting to a concrete use case and verify the effect in the workbook.
Apply custom data formats and layouts: 20–25%
The Apply custom data formats and layouts domain represents 20–25% of the exam. Practice making business data display correctly without changing its underlying value, and arrange worksheets so that users can distinguish inputs, calculations, assumptions, and outputs.
Use practical files such as an invoice, budget, or inventory schedule. Test dates, currency, percentages, identifiers, negative values, and blank or zero results. Then inspect print-oriented or presentation-oriented layout choices where relevant. A frequent error is treating appearance as decoration; in an expert workbook, formatting helps prevent misinterpretation and supports reliable use.
Create advanced formulas: 35–40%
The Create advanced formulas domain represents 35–40% of the exam. This should be your largest study area because it tests the reasoning needed to construct formulas from described requirements, combine functions appropriately, and maintain correct references as a workbook changes.
Work with related tables, conditional calculations, error-aware outputs, lookups, date or financial logic, and formulas copied across ranges. The exact feature list should come from the official skills outline available from Microsoft. For each exercise, explain what the formula is meant to return, identify its inputs, test boundary cases, and confirm that copying or changing source data does not silently break the result.
Do not study advanced formulas as isolated flashcards. Start with a small dataset, write the requirement in plain language, design the formula, and validate it against known results. Then alter the data structure or input values. This exposes reference errors and reveals whether you understand the formula’s purpose rather than merely reproducing a memorized pattern.
Create advanced charts and tables: 25–30%
The Create advanced charts and tables domain represents 25–30% of the exam. Practice selecting a suitable structure for the data, configuring the output accurately, and presenting information that a business user can interpret without rebuilding the workbook.
Create a financial chart with more than one relevant measure, an inventory table that supports filtering or review, and a team-performance output that separates categories clearly. Check source ranges, labels, scales, legends, and the relationship between the visual and the underlying data. Multiple-axis financial charts are among Microsoft’s examples of expert workbook outputs, so learn to use them carefully rather than adding axes simply because they are available.
Tables and charts should be tested after the source data changes. Add a record, revise a value, or change a category and inspect whether the table and visual remain accurate. This practice also connects the chart domain to formulas, layouts, and workbook settings, which is closer to the integrated nature of project-based tasks.
Build a preparation environment that resembles the target
Use a full installation of the corresponding Windows Microsoft software when practicing with CertPREP, because the Certiport product page states that its in-app practice tests require the corresponding Windows Microsoft application. More generally, practice in Excel 2016 or an environment that lets you deliberately work with the Office 2016 feature set, and confirm any version differences before relying on a result.
Avoid preparing only through videos or notes. Open Excel and create, modify, save, and reopen workbooks. Practice switching between sheets, selecting ranges precisely, editing formulas, changing layouts, and recovering from an incorrect choice. The objective is controlled execution in the application, not recognition of screenshots.
If you use a newer Excel version for part of your preparation, record which features are available in Office 2016 and which are not. Do not assume that a newer interface, function, or behavior represents the legacy exam target. Use the official exam page and skills outline to resolve version-specific uncertainty.
Choose practice tests for diagnosis, not prediction
CertPREP offers Testing Mode, which is timed and designed to resemble the certification exam, and Training Mode, which provides feedback and may offer step-by-step help. The product page says the single-title license permits up to 30 practice tests for one selected Microsoft Office Specialist title during a one-year period and is valid in the United States only.
Use Training Mode early to identify weak operations, then move to Testing Mode after you can complete tasks without guided help. Review every mistake by domain and cause: misunderstood requirement, wrong feature, inaccurate reference, formatting oversight, or slow navigation. Practice tests can expose gaps, but they do not provide live exam content or guarantee a result.
The product covers several MOS titles and becomes locked to the title selected after activation. If you choose a practice resource, confirm that you select Excel Expert rather than the standard Excel title and verify current product conditions, technical requirements, and regional eligibility before purchase.
Follow a four-stage study roadmap
A strong roadmap moves from blueprint analysis to isolated skill drills, then integrated workbook projects, and finally timed execution. Do not begin with repeated full simulations if you still make basic reference or layout errors; first repair the underlying skill, then test whether it holds under realistic constraints.
Stage one is diagnosis. Download or review the official skills outline, mark each objective as confident, uncertain, or untested, and create a small workbook that touches every domain. This baseline should reveal whether formulas, chart construction, formatting, or workbook management is the main risk.
Stage two is targeted practice. Work through advanced formulas first, then charts and tables, custom formatting and layouts, and workbook options and settings. For each topic, complete an exercise without instructions, compare the result with a defined expected outcome, and write down the failure mode rather than merely repeating the task.
Stage three is integration. Build a professional workbook from raw data through final presentation. Include calculations, an organized layout, custom formats, a table, a chart, and settings appropriate for another user. Reopen the file, change source values, and verify that the result remains coherent.
Stage four is exam readiness. Use timed projects only after the workflow is stable. Practice reading descriptive instructions, selecting the feature independently, saving changes correctly, and moving on when a task is consuming disproportionate time. Finish with a short review of recurring errors, not an attempt to memorize every possible task.
A practical weekly sequence
On the first study session, map the blueprint and perform a baseline workbook. On the next sessions, alternate formula drills with chart, table, and formatting work so that the highest-weight domain receives more repetitions without becoming disconnected from the other skills.
Dedicate a later session to workbook settings and template-style organization. Then build an integrated financial, inventory, or reporting workbook from a blank file. Reserve the final preparation sessions for timed practice, error review, and version-specific checks. Adjust the sequence if your baseline shows that a lower-weight domain is your largest personal weakness.
Define a readiness threshold
You are closer to readiness when you can complete a new requirement by identifying its intended result, selecting a feature without a command-name prompt, validating the output, and correcting an error without starting over. A high practice score is useful only when it reflects independent work and repeatable performance across all four domains.
Before scheduling, complete at least one integrated workbook without consulting step-by-step instructions, then audit it as if you were handing it to a colleague. Check formulas, source ranges, formats, chart interpretation, sheet organization, and saved output. If the audit reveals uncertainty, schedule more targeted practice instead of relying on exam dumps or memorized answer patterns.
Manage timing and project decisions
Microsoft’s certification page states that you have 50 minutes to complete the assessment. Because the MOS 2016 format incorporates multiple projects, allocate attention across projects and avoid spending the entire session perfecting one output while leaving later work unfinished.
Read the full task requirement before acting, especially when the instruction uses a descriptor rather than a command name. Identify the target worksheet, range, or object; perform the smallest reliable sequence; and inspect the result immediately. If a task becomes uncertain, note the issue mentally, complete what you can, and return only when doing so is worthwhile.
Use practice sessions to learn your own stopping rule. A polished chart with an incorrect source range is not finished, while a correctly structured result may be sufficient to move forward. Prioritize correctness, saved changes, and coverage of the project requirements over unnecessary visual embellishment.
Timing mistakes to eliminate
Slow navigation is often a symptom of weak decision-making rather than poor typing speed. Reduce it by practicing keyboard and ribbon routes, but first learn to recognize the requested outcome. Repeatedly opening unrelated menus, rebuilding formulas from scratch, and formatting before confirming the data structure all consume time without improving the score.
Another mistake is failing to validate after a change. A quick check of a formula result, table range, chart source, or displayed format can prevent a later chain of errors. Build that check into every practice task until it becomes part of the workflow.
Plan registration and account details carefully
The Microsoft exam page says price is based on the country or region where the exam is proctored and lists US$100 for the exam. Confirm the current amount with the exam provider before registering. The page also strongly recommends using a personal Microsoft account because exam records associated with an organizational work or school AAD account may be lost and unrecoverable if you leave that organization.
The exam page lists English, Chinese (Simplified), Chinese (Traditional), German, Spanish, French, Japanese, Korean, and Dutch for 77-728. Scheduling availability can depend on the provider and region, so verify the language shown during the actual appointment process rather than assuming every listed language is available at every location.
The Microsoft certification page identifies Certiport as the scheduling route for students or educators. Follow the current scheduling link from Microsoft, check the exam code carefully, and retain confirmation details. Do not rely on a third-party page that does not clearly identify the exact 77-728 exam.
Retirement and replacement checks
Because the supplied Microsoft pages conflict about retirement status, make the retirement check your first registration step. The certification page says the Office 2016 credential was replaced by Microsoft Office Specialist: Excel (Microsoft 365 Apps), while the dedicated exam page shows no retirement date in the supplied snapshot. A booking screen or current Microsoft certification record should decide whether 77-728 remains actionable.
If your deadline is tied to June 30, 2026, do not assume that scheduling alone is enough; the supplied Microsoft information says the exam should be completed before the retirement date to ensure it is applied toward the certification. Confirm the applicable requirement directly on the current official page before making a time-sensitive plan.
Account and support actions
Use a personal Microsoft account for the Learn profile you intend to keep. If you need to correct your legal name, Microsoft support instructions say to sign in to the intended Learn Profile, open profile settings, and follow the legal-name update process. Resolve identity issues before the appointment rather than waiting until registration or delivery.
For scheduling or delivery problems, the support page directs candidates to the relevant exam delivery partner, including Pearson VUE or Certiport. Credentials support is available by email rather than phone according to the supplied support information. Candidates who need accommodations or additional time because an exam is not available in their native language should review the official request process before booking.
Avoid preparation traps that do not build skill
Exam dumps, leaked questions, and answer memorization are poor substitutes for the performance skills described by Microsoft. They cannot teach you how to interpret a new requirement, select a feature when its name is omitted, or maintain a workbook when a source value changes. Use legitimate skills outlines, application practice, and authorized practice products instead.
Do not confuse the standard Excel certification with the expert exam. The standard certification describes fundamental Excel 2016 work such as creating multi-sheet workbooks, using visual graphics, and managing common workbook elements. 77-728 targets advanced workbooks, including custom templates, financial charts, amortization tables, and inventory schedules.
Do not study only the largest domain. Advanced formulas receive 35–40% of the exam domain, but the other three domains still assess practical work. An ignored chart, layout, or workbook-setting weakness can undermine an otherwise strong formula result, especially in a project that combines several operations.
Use the official resources as your final checklist
Begin with the dedicated 77-728 exam page for the current exam identity, blueprint, languages, account guidance, scheduling route, and retirement display. Use the Excel Office 2016 certification page to understand the credential context and replacement information. Recheck both pages immediately before registration because legacy certification details can change.
Use the official skills outline linked from Microsoft as the study boundary. The available certification page says that the outline summarizes the topics covered and is intended to focus preparation. If no current Microsoft learning path or instructor-led course is available for this exam, compensate with structured application practice rather than treating the absence of a course as evidence that preparation is unnecessary.
Use CertPREP only as an optional practice aid after checking its title, Windows software requirement, regional validity, license conditions, and current price. Treat its feedback as diagnostic. The final authority for exam status, requirements, scheduling, and credential application remains the current official Microsoft and exam-delivery information.
Take these next actions
First, open the current 77-728 page and the Office 2016 certification page together, resolve the retirement discrepancy, and confirm that the exam still supports your intended credential. Next, download the skills outline and score yourself across the four domains. Only then should you decide whether to schedule, switch to the replacement Excel certification, or begin a focused study cycle.
If 77-728 is still appropriate, create a diagnostic workbook containing a formula-driven report, a formatted business table, a chart, and a reusable layout. Practice interpreting descriptive tasks, not just named commands. Track errors by domain, repeat the weakest operations independently, and finish with timed multi-project practice using the official 50-minute assessment duration as your planning reference.
Finally, register with the correct exam code and a personal Microsoft account, verify the provider, language, region-based price, and any accommodation needs, and keep your confirmation information. This sequence reduces the two most expensive mistakes: preparing for the wrong credential and booking a legacy exam without confirming its current status.
Conclusion
Exam 77-728 is best approached as an application assessment for advanced Excel 2016 workbook construction. Prioritize advanced formulas, but prepare integrated projects that also require charts, tables, custom layouts, and workbook management. Before scheduling, resolve the official retirement-status conflict and verify the current credential path, provider, language, price, and account requirements. That final check determines whether focused 77-728 preparation is sensible or whether the Microsoft 365 Apps replacement is the better next step.
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
