77-428 Microsoft Excel Expert 2013 Exam Guide
Exam 77-428 belongs to the Microsoft Office Specialist Excel Expert 2013 track and was paired with 77-427 in Microsoft’s Office 2013 roadmap. It is relevant to candidates working from a legacy Excel 2013 certification plan, not automatically to someone seeking the current Microsoft 365 Apps credential. The key decision is whether you need to pursue a historical 77-428 objective or prepare for Microsoft’s current Excel Expert pathway. This guide helps you verify that choice, organize practice around advanced workbook work, and avoid relying on unsupported exam claims or question dumps.
What does 77-428 represent?
Microsoft’s official Office 2013 roadmap places 77-427 and 77-428 under the Microsoft Office Specialist Office 2013 Expert certifications. A separate roadmap states that passing both exams earned the MOS Expert Excel 2013 track. That makes 77-428 a historical Excel Expert 2013 exam identifier rather than evidence of the current Excel Expert assessment. Source: https://download.microsoft.com/download/3/A/0/3A0241D1-B22F-2D5F1A9FA493/ITA_CertificationRoadmap.pdf is not used because the supplied official URL is the source listed below.
The supplied official roadmap URL for the Office 2013 certification structure is https://download.microsoft.com/download/3/A/0/3A0241D8-0FAE-41D1-B22F-2D5F1A9FA493/ITA_CertificationRoadmap.pdf. The second roadmap is https://download.microsoft.com/download/4/2/D/42D11FBC-C082-4134-929C-7E1412143BE8/ITA-Roadmap_Poster.pdf. Together, they support the historical relationship between the two Excel exams, but they do not establish that 77-428 remains schedulable today.
The credential decision comes first
Before buying a book, practice file, or training course, identify the credential your employer, school, or personal plan actually requires. If the requirement explicitly names Excel 2013 or 77-428, preserve that requirement and confirm availability with the relevant testing channel. If it asks for current Excel Expert certification, compare it with the current Microsoft page instead of assuming the old exam number is interchangeable.
Do not confuse 77-428 with MO-211
Microsoft’s current Excel Expert page identifies MO-211 as the modern Microsoft Excel Expert exam for Microsoft 365 Apps. It describes advanced workbook creation, management, distribution, and environment customization. Those statements describe MO-211, not a verified 77-428 blueprint. Treat the current page as a possible alternative path and not as a substitute skills outline for the legacy exam.
Who should consider a legacy 77-428 plan?
A 77-428 study plan makes sense only when the candidate has a documented reason to target the Excel 2013 track and can verify that the exam can still be registered. It may suit someone completing an older MOS pathway, maintaining a historical qualification requirement, or studying from an existing Office 2013 program. It is a poor default choice for a new candidate seeking a current Excel credential without a version-specific requirement.
Excel 2013 is listed by Microsoft under the Fixed Lifecycle Policy. The lifecycle page records mainstream support ending on 4/11/2018 and extended support ending on 4/12/2023. Those lifecycle facts do not by themselves prove that an examination is retired or unavailable, so use the registration workflow or the responsible testing provider for that decision.
Questions to answer before studying
Write down the exact credential name requested by the hiring manager, school, or certification plan. Then answer three practical questions: does the request specifically say Excel 2013, does it specifically name 77-428, and can an authorized provider currently display a registration route? A “yes” to the first two still warrants an availability check because historical product support and exam scheduling are separate matters.
When the current exam is the better route
If your goal is a current Microsoft Excel Expert credential rather than a historical Office 2013 record, review MO-211 first. Microsoft describes that credential as advanced level, with Excel as the product and Business User as the role. Do not report the current credential’s renewal, language, timing, or retake details as properties of 77-428.
What skills can be verified from official evidence?
The supplied official material verifies the historical exam’s product family and certification relationship, but it does not provide a 77-428 skills outline or domain percentages. Therefore, this guide does not assign invented weights, question counts, scores, or task lists to 77-428. A reliable candidate should obtain the version-specific skills outline or provider information before treating any detailed objective list as official.
Microsoft’s current MO-211 page lists four assessed areas: manage workbook options and settings; manage and format data; create advanced formulas and macros; and manage advanced charts and tables. Because the page names MO-211 rather than 77-428, these areas are useful only as a comparison point when deciding whether the current exam matches your intended credential.
Why blueprint percentages matter
A percentage is useful only when it remains attached to the exact exam domain named by the official blueprint. No verified 77-428 percentages are supplied here, so there is no defensible basis for saying one legacy domain is larger than another or for calculating how much study time each should receive. If you find a purported 77-428 percentage elsewhere, check its version and source before using it.
Use the current skills list diagnostically, not as proof
The MO-211 domains can help a candidate audit broad Excel capability: workbook configuration, data handling, advanced formulas and macros, and charts and tables. They cannot establish the tasks, interface, or scoring model of 77-428. Keep two columns in your notes—“verified for target exam” and “comparison only”—so modern material does not silently become a false legacy syllabus.
Advanced workbook practice is the right type of preparation
Microsoft’s current Excel Expert page gives examples of expert workbooks such as custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules. These are examples for the modern credential, not confirmed 77-428 tasks. They nevertheless illustrate a sound practice principle: build complete, purpose-driven workbooks instead of memorizing isolated commands.
How should you prepare without a reliable legacy blueprint?
Start with evidence, then move to hands-on production. Confirm the target version and registration route, gather any legitimate skills outline or approved training material, and convert each objective into a workbook task. Practice should end with a finished file that can be checked for structure, formulas, formatting, chart behavior, and usability—not merely a page of remembered menu paths.
Microsoft’s exam-preparation guidance says MOS exam detail pages include a downloadable “Skills measured” outline. It also describes Microsoft Learn modules, exam-prep videos where available, and Practice Assessments for some exams. Since the supplied evidence does not show a 77-428 detail page or a 77-428 assessment, use these resources only when they explicitly identify the correct exam or version.
Build a version-controlled study folder
Create separate folders for source material, exercises, completed workbooks, error reviews, and final checks. Name every workbook with the Excel version and objective source. This simple control prevents a modern Microsoft 365 tutorial from being mistaken for Office 2013 evidence and gives you a record of which skills you have actually demonstrated.
Turn objectives into observable tasks
For each verified objective, write a task in the form “starting workbook,” “required change,” and “acceptance check.” For example, the acceptance check might confirm that a workbook opens with the intended settings, that a formula returns the expected result when an input changes, or that a chart communicates the requested series. Avoid vague goals such as “learn advanced Excel.”
Practice recovery as well as construction
Expert-level preparation should include correcting a deliberately flawed workbook. Trace a wrong reference, repair inconsistent formatting, locate a broken chart series, and restore a usable layout. This is a recommendation, not a claim about the unseen 77-428 test experience. It strengthens transferable execution because candidates must understand why a workbook works, not only how to create it once.
A practical six-stage study roadmap
Use the roadmap as a sequence of decisions rather than a promise about exam content. Do not schedule until the target version, availability, and evidence base are clear. Then move from baseline diagnosis to controlled drills, integrated workbook projects, timed review, and final administrative checks. If no authorized route can be confirmed, stop at preparation and reassess the credential choice.
The stages below are practical recommendations. They are not an official 77-428 schedule, weighting model, or forecast of test questions.
Stage 1: verify the target
Record the requested exam number, product version, credential outcome, and provider. Check the official Office 2013 roadmap and the current Excel Expert page. Use Microsoft’s registration instructions to understand where a schedule button would normally appear, but do not infer availability from the existence of an old roadmap or a third-party listing.
Stage 2: establish a baseline
Using the Excel version relevant to the requirement, create a small workbook from scratch and document where you hesitate. Test workbook organization, data cleanup, formula construction, table handling, chart creation, and settings that are explicitly present in your verified objectives. The baseline should reveal actions that require instructions, not just concepts you can define.
Stage 3: repair foundational gaps
Study one weak skill at a time. Read the relevant official material or version-appropriate documentation, reproduce the procedure in a blank workbook, and then repeat it without notes. Keep an error log with the failed action, cause, correction, and a new exercise. Repeating the same tutorial is less valuable than changing the data and rebuilding the result.
Stage 4: combine skills in realistic files
Build a workbook with a clear business purpose, such as a budget model, stock register, or reporting template. Combine data organization, formulas, formatting, tables, charts, and workbook controls only when the design calls for them. The goal is not visual decoration; it is a file whose calculations, navigation, and output remain coherent after edits.
Stage 5: add independent review
Close your notes and rebuild selected tasks from a blank file or a clean starting file. Ask a reviewer to check whether the workbook is understandable and whether changes in source data produce sensible outputs. If you are studying alone, use a checklist and compare the result against objective-based acceptance checks rather than against a remembered sequence of clicks.
Stage 6: make the scheduling decision
Schedule only after you have confirmed that the provider accepts the intended exam and that your account information is correct. If the provider cannot show 77-428, do not substitute MO-211 merely because both concern Excel Expert work. Return to the credential owner and decide whether the modern exam satisfies the original requirement.
How should a weekly practice session work?
A productive session has three parts: recall, construction, and review. Begin by reproducing a small task without instructions, spend the main block building or repairing a workbook, and finish by recording errors and one corrective exercise. This structure exposes procedural weaknesses while preserving enough repetition to make advanced operations reliable.
The exact number of weekly sessions should reflect your starting skill, available Excel version, and verified objectives. Microsoft’s current page describes approximately 150 hours of instruction and hands-on experience for the modern Excel Expert candidate; that figure belongs to the current credential and should not be presented as a 77-428 requirement.
Use deliberate variation
Change the data shape, labels, ranges, and business context after learning a procedure. A candidate who can perform a task only on one prepared workbook may be following visual memory rather than understanding the feature. Variation also makes it easier to identify whether a formula, table, or chart is robust when the source changes.
Review the finished file, not just the action
After completing a task, inspect the workbook as another user would. Check whether labels are clear, formulas reference the intended cells, tables expand appropriately, charts show the correct series, and settings support the intended use. Keep a before-and-after copy so you can identify which change introduced an error.
Which study resources are safe to use?
Prefer resources that identify the exact Excel release and exam objective. Microsoft’s preparation page points candidates to skills outlines, Microsoft Learn modules, instructor-led training, exam-prep videos where available, and Practice Assessments for some exams. For a legacy target, the decisive test is version and exam identity: a resource that says only “Excel Expert” is not enough.
A Microsoft Q&A page specifically discusses downloadable files associated with a MOS 2013 Study Guide for exams 77-427 and 77-428. The page records a historical discussion about practice files and links to a third-party download. Treat that discussion as a resource-location record, not as an official exam blueprint, current availability statement, or guarantee that the files remain accessible.
How to assess a book or course
Check its publication version, named exam numbers, objective coverage, exercise files, and update status. Reject material that promises leaked questions, exact scoring predictions, or a guaranteed pass. A legitimate course should teach the software and provide tasks you can perform and verify; it should not encourage memorization of confidential or unauthorized content.
Use practice assessments carefully
Microsoft says some Practice Assessments are available through Microsoft Learn and may be offered in multiple languages. Availability and language support can vary by exam, and the supplied evidence does not confirm a 77-428 Practice Assessment. Use one only when the assessment clearly identifies your target; otherwise, use it as general Excel practice and label it accordingly.
The exam sandbox has a limited purpose
Microsoft’s preparation guidance describes an exam sandbox as a way to experience the look and feel of an exam. Use that type of resource to reduce interface unfamiliarity if it is available for your target. Do not treat a sandbox as evidence of 77-428 objectives, scoring, task selection, or current delivery status.
What mistakes most often weaken preparation?
The largest risk is preparing for the wrong exam. Candidates also lose time by trusting an undated skills list, practicing only definitions, mixing Excel versions without tracking the difference, or treating a third-party question bank as authoritative. Replace each habit with a source check, a version label, an observable workbook task, and a written review of errors.
These recommendations address study quality rather than reported 77-428 test-day behavior. The supplied official sources do not provide verified 77-428 question formats, task counts, passing scores, or domain weights.
Mistake: assuming an old listing proves availability
A search result, book title, or archived roadmap can confirm that 77-428 existed, but it cannot confirm that a provider still offers it. Follow the official registration path and look for an authorized provider option. If the route is absent, pause before paying for preparation aimed at a credential you may not be able to take.
Mistake: importing current MO-211 facts into 77-428
The modern page’s 50 minutes, language list, retake information, advanced-level description, and assessed areas are facts about MO-211 as presented in the supplied evidence. They are not automatically facts about 77-428. Keep modern and historical notes separate, especially when writing a résumé, training plan, or reimbursement request.
Mistake: studying commands without a workbook objective
Memorizing where a feature appears does not show that you can choose it appropriately or preserve a workbook’s logic. Every practice item should state the intended outcome and include a check. If a task has no meaningful acceptance check, rewrite it before spending study time on it.
Mistake: relying on dumps
Exam dumps and purported leaked questions are not a dependable preparation method and may expose candidates to unauthorized content. They encourage brittle recall instead of accurate Excel work. Build and inspect your own files, use authorized learning resources, and never assume memorization guarantees a passing result.
How do you schedule the exam when the route is confirmed?
Microsoft’s registration guidance says to begin from the certification overview or an exam-details page, select the certification, and use the “Schedule exam” area to choose a provider. For MOS exams, Microsoft states that candidates should select Certiport; the page also explains that students, academic-institution members, and MOS candidates should use that route. Apply the provider instruction shown for your situation at the time of registration.
The registration page says certification exams can be scheduled no more than 90 days in advance and that provider options may differ. It also explains that an online option may not appear for every provider or exam. These are scheduling rules from Microsoft’s current guidance, so verify the live registration page before making a time-sensitive plan.
Certiport or Pearson VUE?
Microsoft’s general rule distinguishes the providers: candidates taking a certification independently or through a training program select Pearson VUE, while students, academic-institution members, and people taking a MOS exam select Certiport. Because 77-428 is identified as a MOS exam in the supplied evidence, start by checking Certiport’s route, while still following the live instructions associated with the exam listing.
Online or test center
Microsoft explains that many exams may offer an online or local test-center choice, but an online option is not guaranteed. If online delivery is displayed, the registration guidance says you are responsible for a system pre-check and for meeting security requirements. If a test center is offered, it may be preferable when you want a pre-configured environment or cannot meet online requirements.
Account and identification checks
Microsoft recommends registering with a personal Microsoft account because records associated with an organizational account may be lost if you leave that organization. The registration instructions also require the legal name in the Learn profile to match legal identification. Check those details before scheduling rather than trying to repair them immediately before an appointment.
Request accommodations early
If you need an accommodation, request it before scheduling so the provider has time to review the request and confirm that the testing environment supports your needs. Microsoft lists support for assistive devices, read-aloud needs, fidgeting, and extra time among possible accommodation situations. Confirm the actual process with the provider before selecting an appointment.
What should you do in the final review?
The final review should verify readiness and administration separately. For skills, rebuild representative workbook tasks without step-by-step help and investigate every unresolved error. For administration, confirm the target exam number, provider, account identity, accommodation approval if applicable, and the current appointment details. If any item is uncertain, resolve it through the official registration channel rather than guessing.
Do not use final-week study to chase alleged question recalls. Instead, review your error log, test formulas and workbook settings under changed inputs, and practice explaining why each design choice produces the required result. This approach keeps preparation tied to demonstrable Excel capability.
A readiness checklist
You are better positioned to schedule when you can identify the exact credential outcome, locate authoritative objectives for the target version, complete representative tasks without a tutorial, repair errors systematically, and explain the difference between 77-428 and MO-211. These are practical readiness indicators, not an official Microsoft pass standard.
A decision rule for changing paths
Change to the current MO-211 path only when the credential owner accepts the modern Microsoft 365 Apps certification or when your original goal was simply a current Excel Expert credential. Keep the historical plan when the requirement explicitly names Office 2013 or 77-428 and an authorized provider confirms a valid route. Document the decision so your study materials match it.
What should you do next?
First, verify whether the requirement is specifically 77-428 or instead the current MO-211 credential. Second, check the authorized scheduling route and the exact product version. Third, obtain a version-matched skills outline or approved course material. Only then should you build a practice calendar around workbook tasks, error review, and a final registration check.
The official evidence supports the historical 77-428 and 77-427 pairing, the Office 2013 MOS Expert pathway, Microsoft’s current Excel Expert alternative, and general preparation and scheduling procedures. It does not support a fabricated 77-428 blueprint, score, duration, price, language list, or current availability claim. Keeping those boundaries clear is part of making a sound certification decision.
Immediate action list
1. Ask the credential owner whether Excel 2013 is mandatory. 2. Compare the requested outcome with Microsoft’s current MO-211 page. 3. Check the official schedule workflow and provider. 4. Separate historical and modern study files. 5. Practice complete workbooks and log errors. 6. Schedule only after the exam identity and registration route are confirmed.
Conclusion
Exam 77-428 should be approached as a historical Excel 2013 target requiring verification, not as a modern exam whose details can be filled in from the MO-211 page. Confirm the credential requirement and provider first, then study from version-matched objectives through repeated workbook construction and repair. If the requirement is current rather than historical, reassess MO-211 before investing further. That sequence prevents the most expensive preparation error: becoming proficient in the wrong exam.
Related exams
- 77-420 exam — Excel 2013
- 77-725 exam — Microsoft Word 2016 Core: Document Creation, Collaboration and Communication (MOS)
- 77-427 exam — Excel 2013 Expert Part One
- 77-727 exam — Excel 2016: Core Data Analysis, Manipulation, and Presentation
- 77-728 exam — Excel 2016 Expert: Interpreting Data for Insights
- 77-731 exam — Outlook 2016: Core Communication, Collaboration and Email Skills
