77-420 Excel 2013 Core Exam Guide: Skills, Study Plan, and Scheduling Decisions
Exam 77-420 validates practical Excel 2013 ability through project-based work in the application rather than isolated knowledge checks. It serves students, office professionals, and other candidates who need to demonstrate core worksheet and workbook skills. This guide helps you decide whether the legacy Excel 2013 credential fits your goal, identify the skills to practise, confirm current registration options, and build a focused preparation plan without relying on memorized exam content.
What does 77-420 validate?
77-420 is Certiport’s Excel 2013 Core exam in the Microsoft Office Specialist 2013 lineup. The assessment is designed around creating and editing a workbook with multiple sheets for different purposes, so preparation should emphasize completing connected spreadsheet work accurately rather than memorizing menu descriptions.
Certiport describes MOS 2013 testing as project-based and performance-based. Its Excel 2013 description says candidates create and edit a multi-sheet workbook, with examples such as professional-looking budgets, team performance charts, sales invoices, and exercise logs. These examples indicate the practical context of the assessment, not a promise that the same scenarios will appear in a live exam.
The certification is most relevant when an employer, school, training program, or personal plan specifically calls for Excel 2013 or MOS 2013 evidence. Excel 2013 follows Microsoft’s Fixed Lifecycle Policy, with mainstream support ending on 4/11/2018 and extended support ending on 4/12/2023. That support history makes version alignment an important decision before investing in preparation. ([Microsoft Learn](https://learn.microsoft.com/en-us/lifecycle/products/excel-2013))
Who should consider this exam?
Candidates who work with Excel 2013 and need a formal core-level skills credential are the clearest audience for 77-420. It can also suit learners completing a MOS 2013 pathway or professionals whose organization still specifies this version in a training or hiring requirement.
The exam is not automatically the right choice for someone seeking a current Excel credential. Because the product is no longer within Microsoft’s extended support period, first confirm that the requesting organization accepts the 2013 certification and that the exam can still be scheduled through an authorized channel. Do not substitute an assumption about a newer exam’s equivalence for written confirmation.
Candidates should also distinguish the core exam from the Excel 2013 Expert pathway. Certiport states that becoming a Microsoft Office Excel 2013 Expert requires passing both Excel 2013 Expert Part One and Excel 2013 Expert Part Two. Passing 77-420 alone should therefore not be presented as the complete Excel 2013 Expert certification. ([Certiport](https://www.certiport.com/Portal/desktopdefault.aspx?page=common%2Fpagelibrary%2Fmos-excel-2013.html))
Which skills are measured?
The official objective document organizes 77-420 around workbook and worksheet management, cells and ranges, and tables, while Certiport’s broader Excel 2013 summary also identifies formulas and functions plus charts and objects. Use the objective document as the study checklist, then practise combining those skills in complete workbooks.
The official outline names “Create and Manage Worksheets and Workbooks” as objective domain 1.0. It covers creating blank or template-based workbooks, importing files, opening non-native files in Excel, and adding, copying, or moving worksheets. Navigation work includes searching for data, inserting hyperlinks, changing worksheet order, using Go To, and using the Name Box.
The outline also includes worksheet and workbook presentation and control tasks: page setup, rows and columns, themes, watermarks, headers and footers, and data validation. It lists Excel options and views such as the Quick Access Toolbar, Ribbon, macro security, workbook views, simple macros, formula display, freeze panes, shortcut keys, and split windows.
For output and file handling, the objectives include setting print areas, using alternate file formats, applying print scaling, repeating headers and footers, checking compatibility, and saving to remote locations. These are easy to neglect when studying only formulas, but they can affect whether a finished workbook is usable.
The objective document names “Create Cells and Ranges” as objective domain 2.0. Tasks include entering, finding, replacing, copying, pasting, autofilling, and deleting cell data. Cell and range formatting includes merging, alignment, fonts, Format Painter, text wrapping, number formats, highlighting, cell styles, and WordArt.
The same domain includes organizing data with conditional formatting, sparklines, transposition, named ranges, outlines, collapsed groups, and subtotals. Practise each function on a small dataset first, then repeat it in a workbook where the result must remain readable and logically connected to the surrounding content.
“Create Tables” is objective domain 3.0. The listed work includes creating tables, changing styles, applying banding, adding total rows, filtering, sorting by multiple columns, and removing duplicates. Table practice should include checking the selected range and confirming that headers, filters, and totals apply to the intended data.
Certiport summarizes the Excel 2013 core skill set as creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions, and creating charts and objects. The supplied objective facts do not provide a percentage weighting for these areas, so this guide does not assign or compare unsupported blueprint percentages. ([Certiport objective document](https://www.certiport.com/Portal/Common/DocumentLibrary/77-420_MOS_Excel_2013-OD.pdf); [Certiport Excel 2013 information](https://www.certiport.com/Portal/desktopdefault.aspx?page=common%2Fpagelibrary%2Fmos-excel-2013.html))
How should you practise the project-based format?
Practise by building complete workbooks from instructions, not by clicking through disconnected feature demonstrations. Start with a blank or template-based workbook, create several sheets, enter and organize data, format the presentation, add tables or calculations, and finish by checking the saved and printable result.
A useful practice project might contain an input sheet, a summary sheet, and a presentation sheet. On the input sheet, enter and clean data, use a table, sort and filter it, and remove an intentional duplicate. On the summary sheet, use named ranges, subtotals, conditional formatting, or a sparkline. On the presentation sheet, apply page setup, headers or footers, scaling, and a chart or other object.
The point is not to reproduce a supposed live question. It is to rehearse the decisions that project instructions require: which range is selected, whether a feature belongs at worksheet or workbook level, whether formatting changes the displayed value or only its appearance, and whether the final file still works after saving.
After each project, inspect the workbook as a user would. Move through the sheets, use Go To or the Name Box, test a hyperlink, review formulas if applicable, check filters and totals, and look at print-related settings. This exposes errors that a feature-by-feature drill may hide.
What should you learn first?
Begin with workbook structure and cell manipulation, then add tables and data organization, and finish with presentation, views, output, formulas, and charts. This order follows the dependencies in real Excel work: you cannot reliably format, summarize, or chart data until the workbook and source ranges are sound.
First, create and manage workbooks and worksheets. Practise importing a file, opening a non-native file, adding and moving sheets, changing sheet order, and navigating with search, Go To, and the Name Box. Add hyperlinks and become comfortable locating the relevant worksheet before editing.
Next, work through cells and ranges. Enter, find, replace, copy, paste, autofill, and delete data deliberately. Then repeat the same operations while preserving the correct relative or absolute references where formulas are involved. The objective evidence supports these operations; the exact formulas or functions required by a particular exam task are not specified in the supplied facts, so use the official outline to define your final checklist.
After basic editing feels automatic, study table behavior. Create a table from a clean range, change its style, control banding, enable a total row, filter records, sort across multiple columns, and remove duplicates. Pay attention to whether you are modifying the table itself or merely applying formatting to nearby cells.
Then cover organization and presentation. Practise conditional formatting, sparklines, transposition, named ranges, outlines, collapsed groups, subtotals, themes, row and column settings, data validation, headers and footers, watermarks, and page setup. Finish with views, formula display, freeze panes, split windows, simple macros, macro security, print areas, scaling, compatibility, alternate formats, and remote save locations.
Finally, integrate formulas, functions, charts, and objects into a multi-sheet project. Certiport identifies these as part of the Excel 2013 core skill set, but the supplied research does not enumerate a complete formula or chart sub-list. Avoid treating an unofficial topic list as an official requirement unless you verify it against the current objective material.
How can you turn the objectives into a study schedule?
Use a diagnostic-first roadmap: measure what you can perform in Excel 2013, map each failure to an objective, learn the feature, and then retest it inside a complete workbook. A short, consistent cycle is more useful than reading the outline repeatedly without opening Excel.
Phase 1: establish the environment. Use the Excel version that matches the credential requirement when possible. Create a practice folder and several disposable workbooks. Record whether each task was completed without help, completed only after searching, or not completed. This separates knowledge gaps from navigation or speed problems.
Phase 2: build the foundation. Work through domain 1.0 and domain 2.0 in the official outline. Create workbooks and sheets, navigate efficiently, manipulate cells and ranges, and apply formatting. Do not move on merely because you recognize a command; require yourself to complete the operation from a written instruction and verify the result.
Phase 3: organize data. Concentrate on domain 3.0 and the listed organization features. Use one dataset repeatedly so you can compare the effects of tables, filters, multi-column sorting, duplicate removal, subtotals, outlines, named ranges, conditional formatting, and sparklines. Keep an untouched copy so you can repeat a task without guessing what the original data looked like.
Phase 4: finish the workbook. Add formulas, functions, charts, or objects; configure views and options; and prepare the file for printing or saving. Test page setup, print area, scaling, repeating headers and footers, compatibility, and alternate formats. Practise saving a copy rather than overwriting your source file during drills.
Phase 5: simulate an end-to-end assignment. Give yourself a written business-style brief, work without a tutorial, and review the result only after completing the sequence. Mark every hesitation, correction, and accidental change. Your next study session should target those observations, not just the features you enjoy using.
Phase 6: make a readiness decision. Schedule only after you can complete several varied projects with reliable navigation and verification. If you still depend on step-by-step prompts for basic workbook, cell, range, or table operations, continue practising. If the problem is version access or registration, resolve that separately rather than treating it as a study weakness.
Which practice materials are worth using?
Prioritize the official objective document, an Excel 2013 installation or compatible approved practice environment, and exercises that require you to produce a finished workbook. Certiport describes a learn-practise-certify pathway involving instructional materials, preparation tools, practice exams, and performance-based exams; use those categories to structure resources rather than collecting unrelated tutorials.
The objective document should remain the authority for scope. Turn every listed action into a check box and write a small task for it. For example, instead of noting “learn data validation,” create a worksheet where an entry rule must be applied, test an allowed and disallowed value, and then reopen the workbook to confirm the rule remains.
Microsoft Q&A contains a discussion about practice files for Joan Lambert’s MOS Excel 2013 Study Guide. The discussion shows users working through a redirected download path, but it does not establish a permanent, official availability guarantee. Treat any third-party or older download link as something to verify, and never let an unavailable file block practice you can create yourself. ([Microsoft Q&A](https://learn.microsoft.com/en-us/answers/questions/4979023/mos-excel-2013-study-guide-joan-lambert-practice-f))
Practice exams can help with instruction-following and workflow, but they should be used to identify weak skills rather than memorize answer patterns. Do not use dumps, leaked questions, or copied answer sets as a substitute for performing the work. They cannot establish that you understand the workbook you are creating, and relying on them undermines the purpose of a performance-based assessment.
What mistakes commonly waste preparation time?
The most damaging mistake is studying Excel as a vocabulary test. 77-420 is described as project-based and live in the application, so knowing that a feature exists is not enough. Practise selecting the correct object, applying the requested change, and verifying that the finished workbook behaves as intended.
Another mistake is neglecting workbook navigation. Candidates who only practise entering values may lose time locating sheets, ranges, or records. Deliberately use search, Go To, the Name Box, worksheet reordering, and hyperlinks during practice so navigation becomes part of the workflow rather than an emergency technique.
Do not confuse visual formatting with data structure. A range that looks like a table is not necessarily an Excel table, and a bold total is not necessarily a total row. Practise creating the actual table, enabling the appropriate table features, and checking filters, banding, totals, and duplicate removal separately.
Avoid changing data before preserving a clean copy. Sorting, transposing, removing duplicates, and applying subtotals can alter the working view or data arrangement. Keep an original file and use a deliberate save-as process during study. This is a practical recommendation, not an official test-day rule.
Do not leave printing and saving until the final minutes of preparation. The outline includes print areas, scaling, repeating headers and footers, compatibility, alternate file formats, and remote save locations. These tasks require settings and verification, not just a single visible edit.
Macros and security settings also deserve controlled practice. The objectives mention simple macros and macro security, but experimenting in an important personal workbook is poor practice. Use disposable files, understand when a file format matters, and confirm the workbook’s state after closing and reopening it.
Finally, do not assume a pass on 77-420 automatically qualifies you for a different Excel certification. A Microsoft Q&A question asks whether a 77-420 pass can be used for MO-201, but the supplied discussion does not provide an official equivalency decision. Confirm progression or renewal rules with the relevant certification authority before booking another exam. ([Microsoft Q&A](https://learn.microsoft.com/en-us/answers/questions/1195481/have-passed-77-420-exam-for-excel-can-i-use-this-t))
How should you handle registration and delivery questions?
Confirm availability, delivery method, location, and version with Certiport before making a study or scheduling commitment. The official material identifies Certiport as the MOS delivery and registration channel and provides a testing-center route, but the supplied research does not establish current appointment availability, pricing, duration, score requirements, or a universal remote-delivery option.
A Microsoft Q&A discussion records a candidate asking whether 77-420 could be registered through Pearson VUE because no nearby proctoring location was available. The page does not supply a definitive official answer to that question. Therefore, do not assume Pearson VUE is an alternative, and do not infer that an absence of local locations means remote delivery is available.
Use Certiport’s MOS pages to locate the relevant exam information and testing-center resources, then ask the authorized center or Certiport support about the current status. Verify the exam identifier as 77-420, the Excel 2013 version, available language or delivery choices, identification requirements, rescheduling rules, and any local technical conditions before paying or reserving a seat. Those details can change and are not established by the supplied facts. ([Certiport MOS 2013](https://www.certiport.com/portal/Common/PageLibrary/mos2013.html); [Microsoft Q&A registration discussion](https://learn.microsoft.com/en-us/answers/questions/407605/registering-for-exam-77-420-issue))
The Certiport release table supplied in the research lists 77-420: Excel 2013 Core across the displayed language columns as live. That table is historical MOS 2013 information rather than a guarantee that a candidate can obtain an appointment today. Check the live registration path directly, especially because Excel 2013 reached the end of extended support on 4/12/2023.
What should you do before scheduling?
Make scheduling the final step of a verification process: confirm the credential is accepted, confirm a current registration route, confirm access to the correct Excel version for practice, and complete an end-to-end workbook without guided instructions. This prevents a strong general Excel background from masking a version, scope, or logistics problem.
Use this final checklist:
- Confirm that the requesting employer, school, or program specifically accepts MOS Excel 2013 or 77-420.
- Read the official objective document and mark every listed task as ready, developing, or untested.
- Practise workbook creation, sheet management, navigation, cells and ranges, tables, formulas and functions, charts and objects, views, formatting, printing, and saving as an integrated workflow.
- Verify the current Certiport registration route and authorized testing-center information.
- Ask the provider to confirm any details not stated in the official material, including appointment format, current languages, identification, rescheduling, and technical requirements.
- Keep your practice focused on performing tasks in Excel rather than memorizing reconstructed questions.
If any item remains unresolved, treat it as a decision to investigate, not as a reason to guess. A candidate can be technically prepared and still choose the wrong version or registration path.
What is the best next action?
Download or open the official 77-420 objective document, create a skills checklist, and perform a baseline workbook exercise today. The baseline should include multiple worksheets, cell and range edits, a table, at least one organization feature, and a final review of presentation and output settings. Use the result to choose your first study block.
After the baseline, spend the next sessions on the weakest objective areas and end each session with a small integrated task. When your errors become specific—such as selecting the wrong range, misplacing a worksheet, or forgetting an output setting—write the correction as a repeatable procedure and practise it again from a clean file.
At the same time, check whether 77-420 is still the credential your organization or program requires. Certiport’s official pages explain the MOS 2013 pathway and the Excel 2013 core assessment, while Microsoft’s lifecycle page establishes that Excel 2013 is an older product. Use both facts to make a deliberate version decision rather than treating an old exam code as automatically current.
Conclusion
77-420 preparation should produce a dependable Excel 2013 workflow: build the workbook, manage sheets and ranges, organize data, apply the required features, and verify the saved result. The official objectives provide the scope, while integrated practice exposes the navigation and checking habits that isolated tutorials miss. Before scheduling, confirm that the credential remains acceptable for your goal and obtain current delivery details from Certiport or an authorized testing center.
Related exams
- 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
- MB-910 exam — Microsoft Dynamics 365 Fundamentals Customer Engagement Apps (CRM)
- MO-101 exam — Microsoft Word Expert (Word and Word 2019)
