Microsoft Office Specialist (MOS)

Key Topics to Master:

• Manage documents, 20 to 25 percent: navigation, formatting for output, saving and sharing, inspecting for issues
• Insert and format text, paragraphs and sections, 20 to 25 percent: styles, find and replace, columns, section breaks
• Manage tables and lists, 15 to 20 percent: creating tables, modifying rows and columns, sorting, numbered and bulleted lists
• Insert and format graphic elements, 15 to 20 percent: shapes, pictures, SmartArt, text boxes, wrapping and alt text
• Create and manage references, 5 to 10 percent: footnotes, endnotes, citations, bibliography, tables of contents
• Manage document collaboration, 5 to 10 percent: comments, tracked changes, restricting editing

Key Topics to Master:

• Manage data cells and ranges, 20 to 25 percent on MO-200: fill, formatting, conditional formatting, named ranges
• Perform operations by using formulas and functions, 20 to 25 percent on MO-200: relative and absolute references, SUM, AVERAGE, COUNT family, IF, text functions
• Manage charts, 20 to 25 percent on MO-200: creating charts, chart elements, chart formatting, alt text
• Manage tables and table data, 15 to 20 percent on MO-200: converting ranges to tables, table styles, filtering and sorting, total rows
• Manage worksheets and workbooks, 10 to 15 percent on MO-200: importing data, navigation, page setup, headers and footers, inspecting for issues
• MO-210 covers the same five groups, and Microsoft lists them on the certification page as Manage worksheets and workbooks, Manage data cells and ranges, Manage tables and table data, Perform operations by using formulas and functions, and Manage charts

Key Topics to Master:

• Manage presentations (no published percentage): slide masters, handout and notes masters, presentation views and options, print settings, configuring and presenting slide shows, preparing presentations for collaboration
• Manage slides (no published percentage): inserting slides and layouts, importing Word outlines, Summary Zoom slides, hiding slides, individual slide backgrounds, headers and footers, sections and slide order
• Insert and format text, shapes and images (no published percentage): text formatting and columns, bulleted and numbered lists, hyperlinks and Zoom links, image sizing and cropping, shapes and text boxes, ordering and grouping objects
• Insert tables, charts, SmartArt, 3D models and media (no published percentage): tables, charts, SmartArt, 3D models, audio and video, screen recordings, media playback options
• Apply transitions and animations (no published percentage): basic and 3D transitions, transition effect options and duration, animating text, graphics and 3D models, animation paths and reordering
• Adding alt text to graphic elements sits inside the insert-and-format group rather than forming an accessibility group of its own

Key Topics to Master:

• Use advanced editing and formatting features, 25 to 30 percent: find and replace with wildcards and special characters, finding and replacing formatting and styles, paste options, hyphenation and line numbers, paragraph pagination, creating and copying styles
• Create custom document elements, 25 to 30 percent: QuickParts and building blocks, custom colour, font, theme and style sets, marking index entries and building indexes, figure and table captions, tables of figures
• Manage document options and settings, 20 to 25 percent: modifying templates, document versions, comparing and combining documents, linking external content, enabling macros, Quick Access toolbar, restricting editing and password protection, language options
• Use advanced Word features, 20 to 25 percent: custom fields and field properties, standard content controls, recording, naming, editing and copying macros, mail merge recipient lists, merged fields and merged output
• The two heaviest groups on this exam are advanced editing and formatting and custom document elements, at 25 to 30 percent each

Key Topics to Master:

• Create advanced formulas and macros, 30 to 35 percent on MO-201: nested logical functions including IF, IFS, SWITCH and the SUMIF/COUNTIF/AVERAGEIF families, VLOOKUP, HLOOKUP, MATCH and INDEX, date and time functions, Goal Seek and Scenario Manager, PMT, formula troubleshooting, simple macros
• Manage advanced charts and tables, 25 to 30 percent on MO-201: dual axis charts, Box and Whisker, Combo, Funnel, Histogram, Map, Sunburst and Waterfall charts, PivotTables, slicers, calculated fields, PivotCharts
• Manage and format data, 20 to 25 percent on MO-201: Flash Fill and advanced Fill Series, custom number formats, data validation, grouping and outlining, subtotals, removing duplicates, advanced conditional formatting rules
• Manage workbook options and settings, 15 to 20 percent on MO-201: copying macros between workbooks, referencing other workbooks, workbook versions, restricting editing, worksheet and structure protection, calculation options, language options
• On the Microsoft 365 Apps exam MO-211 the same four groups carry different weights, so check the skills outline for the exam number you actually booked
• Excel for Accounting and Excel for Business Finance are separate 23 to 27 question certifications on the same 50-minute clock

Key Topics to Master:

• Outlook (Office 2019): message management, calendars and meetings, contacts and groups, tasks, rules and folders, search
• Access Expert (Office 2019): database design, tables and relationships, queries, forms, reports, import and export
• Neither exam counts toward the Microsoft 365 Apps Associate credential except MO-400 Outlook (Office 2019), which Microsoft does list among the accepted Associate exams
• Access Expert appears in Certiport's published exam length table but not in Microsoft's Associate or Expert requirement lists

• 1Choose one exam, not a suite. Word Associate MO-110, Excel Associate MO-210 and PowerPoint Associate MO-310 are the three Microsoft 365 Apps Associate options.
• 2Download the exam's skills outline from its Microsoft Learn page and copy every objective into a checklist with a confidence column.
• 3Check the language list on that same page before you book: MO-210 runs in 15 languages, MO-110 only in English and Japanese.
• 4Confirm which product version your practice machine runs, because Microsoft 365 Apps and Office 2019 are separate exam tracks with separate exam codes.
• 5Locate a Certiport Authorized Testing Center and check its scheduling lead time.

• 1Work only the largest published group for your exam. On Word Associate that is Manage documents or Insert and format text, paragraphs and sections at 20 to 25 percent each; on Excel Expert it is Create advanced formulas and macros at 30 to 35 percent. PowerPoint has no published percentages, so weight it by the number of objectives in each group instead.
• 2For each objective, build a file from scratch rather than reading about the feature. The exam grades document state, so the muscle memory is the study.
• 3Log every task you had to search a menu for. Those are the ones that cost minutes on a 50-minute clock.
• 4Use the free Microsoft 365 Apps certification preparation materials in Microsoft Learn's educator centre, which include practice projects for MO-210.
• 5Do not touch a practice exam yet.

• 1Cover the next two groups by published weight and repeat the build-from-scratch drill.
• 2For Excel, force yourself through absolute and relative references, the COUNT family and IF variants without autocomplete hints.
• 3For Word, cover styles, section breaks and multilevel lists, which sit inside the two 20 to 25 percent groups on MO-100.
• 4For PowerPoint, cover slide masters and layouts, which sit in Manage presentations, the group with the most listed objectives on an exam Microsoft weights no further.
• 5Start timing individual tasks with a stopwatch and record which ones run over 90 seconds.

• 1Cover the 5 to 15 percent groups. On Word these are Create and manage references and Manage document collaboration, at 5 to 10 percent each; together they can be 20 percent of the exam.
• 2Learn accessibility tasks explicitly: alt text on images, charts and SmartArt appears across Word, Excel and PowerPoint objectives.
• 3Learn the inspect-for-issues workflow, which appears in Manage documents on Word and Manage worksheets and workbooks on Excel.
• 4Practise import and export tasks, which are easy to get almost right and score zero.
• 5Re-drill anything from week 2 that you have not touched since.

• 1Take a CertPREP practice test, which Certiport supplies and GMetrix powers, in testing mode with the 50-minute clock running.
• 2Score it against 700 on the 1 to 1000 scale, then map every miss to an objective on your checklist.
• 3Rebuild every failed task from a blank file, twice.
• 4Record your total elapsed time. Finishing at 50 minutes with correct work is a fail risk; the target is finishing with time to re-open files.
• 5If you bought the $156 voucher-with-retake-and-CertPREP bundle, remember the practice licence has a limited number of attempts.

• 1Redo the same practice set aiming to cut 30 percent off your time without losing accuracy.
• 2Build a personal shortcut list for the ten tasks that cost you the most seconds and drill them alone.
• 3Practise reading a task statement and identifying the exact required end state before touching the mouse. Partial completion earns nothing on that task.
• 4Practise the project-switching rhythm: finish a file's tasks, re-scan them, then move on, because returning later costs reload time.
• 5Take a second practice exam under strict conditions.

• 1Book the exam at your Certiport Authorized Testing Center and confirm the exam code you booked matches the version you practised.
• 2Confirm the centre's ID requirements and arrival time when you book, since these are set by the test centre rather than published centrally.
• 3If you need accommodations, request them now: Certiport requires advance notification and time to review, and offers extended time, a separate room, and a reader or recorder.
• 4Drill the five objectives with the lowest confidence score on your checklist.
• 5Take a final practice exam no later than three days before the real one.

• 1Sit the exam. Your score report appears when you finish and is stored in your Certiport profile.
• 2If you fail, you may retake after 24 hours; if you bought the $120 voucher-with-retake, use the retake voucher within its 30-day window.
• 3If you pass, claim the digital certificate and the Credly badge from your Certiport profile.
• 4Plan the next two exams in different programs, since three passes in three different programs with at least one on the Microsoft 365 Apps track earn the Associate credential.
• 5Diarise the five-year expiration if your certification was earned on or after September 23, 2025.