Excel is still the first tool most Indian analysts use every day, and many job listings ask for “advanced Excel”. The Microsoft Office Specialist (MOS) Excel exams are the official way to prove that skill. This guide explains the current exams and when they are worth your time.

Facts in this article were checked against Microsoft Learn’s official exam pages in October 2026.

The current MOS Excel exams

Microsoft Learn lists separate MOS Excel exams for the Microsoft 365 Apps version of Excel and for Office 2019. All three exams below were shown as active, with no retirement notice, when we checked.

ExamCertificationVersionLevel
MO-200Microsoft Office Specialist: Excel Associate (Office 2019)Office 2019Associate
MO-210Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps)Microsoft 365 AppsAssociate
MO-211Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps)Microsoft 365 AppsExpert

For most people in 2026, the Microsoft 365 Apps exams (MO-210 and MO-211) make more sense, because that is the version most companies now use. Choose MO-200 only if your training centre or employer specifically works with Office 2019.

MO-210: Excel Associate

Microsoft Learn describes MO-210 as an intermediate-level exam of 50 minutes. It suggests candidates have about 150 hours of instruction and hands-on experience. The skills measured are:

  • Manage worksheets and workbooks
  • Manage data cells and ranges
  • Manage tables and table data
  • Perform operations by using formulas and functions
  • Manage charts

This is solid, everyday Excel. It is a good fit for freshers, people in operations or back-office roles moving towards analytics, and anyone who learned Excel informally and wants to fill gaps.

MO-211: Excel Expert

MO-211 goes further. Microsoft lists four skill areas with these weights:

Skill areaWeight
Manage workbook options and settings10–15%
Manage and format data30–35%
Create advanced formulas and macros25–30%
Manage advanced charts and tables25–30%

“Advanced formulas and macros” and “advanced charts and tables” are the parts most relevant to analysts. Expect lookup functions, logical and date functions, what-if analysis, PivotTables and PivotCharts, and basic macros.

Do you need MO-210 before MO-211?

A Microsoft Q&A answer on Microsoft Learn says that passing MO-211 alone earns the Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) certification. MO-210 is not required for that individual title.

There is also a broader, programme-level credential called Microsoft Office Specialist: Expert (Microsoft 365 Apps). That one combines several Associate and Expert exams across Office apps. Most analysts do not need it.

How the exams are delivered and priced

MOS exams are run through Certiport, a Pearson VUE business, usually at authorised testing centres such as colleges and training institutes. Microsoft’s exam pages say the price is based on the country or region in which the exam is proctored, so ask your local Certiport testing centre for the current fee in India.

The exams are performance-based. Instead of only answering multiple-choice questions, you complete tasks in a live or simulated Excel environment. This makes them a better test of practical skill than a typical online quiz.

Is a MOS Excel certification worth it for analysts?

It depends on your stage.

  • Worth it: if you are a fresher, a commerce or arts graduate, or someone moving from BPO, operations or accounts into analytics. It gives you a recognised proof of Excel skill that you can list next to your degree.
  • Less useful: if you already have two or more years of analyst experience. Recruiters will judge your Excel through interview tasks and your project work instead.
  • Not a substitute: for SQL or a BI tool. A MOS certificate shows you can handle spreadsheets, but analyst roles also expect SQL and usually Power BI or Tableau.

Excel skills the exam does not fully cover

Even MO-211 does not go deep into some features analysts use heavily in 2026:

  • Power Query for repeatable data cleaning
  • The data model and Power Pivot for working with several related tables
  • Dynamic array functions such as FILTER, SORT, UNIQUE and XLOOKUP in real analysis workflows
  • Python in Excel, which Microsoft makes available to Enterprise and Business users on supported versions
  • Copilot in Excel, which depends on your Microsoft 365 plan

Learn these alongside your MOS preparation. They are often what separates “advanced Excel” on a resume from advanced Excel in an interview task.

How to show Excel skill beyond the certificate

Some analyst interviews include a short, timed Excel task, such as: clean a messy sheet, build a PivotTable summary, or answer three questions from a dataset in 20 minutes. Prepare for that format as well as the exam.

  • Keep two or three sample workbooks you can walk through, each with a short “README” sheet explaining the question, the steps and the result.
  • Practise explaining your formulas aloud. Being able to say why you chose XLOOKUP over VLOOKUP, or why you used a table instead of a plain range, signals real understanding.
  • Show one example of a repeatable process, such as a Power Query that refreshes a monthly report in one click. This is the kind of time saving managers notice.

A four-week preparation plan for MO-211

  1. Week 1: Workbook options, data validation, conditional formatting with formulas, and custom number formats.
  2. Week 2: Advanced formulas: lookups, IF combinations, date and text functions, and what-if analysis tools such as Goal Seek and Scenario Manager.
  3. Week 3: PivotTables, PivotCharts, slicers and advanced chart types.
  4. Week 4: Recording and editing simple macros, then timed practice tests in a simulated environment.

Frequently asked questions

Is MO-200 still worth taking?

MO-200 is still listed as active, but it is based on Office 2019. If you use Microsoft 365 at work or college, MO-210 is the better match.

How long is the MO-210 exam?

Microsoft Learn lists the MO-210 exam as 50 minutes long.

Can I take MOS exams online from home?

Delivery options depend on Certiport and the testing centre. Check with an authorised Certiport centre near you about in-person and any remote options before you register.

Official sources

Leave a Reply

Trending