13.2 Certification, if it helps you

What this is and why it exists

A Microsoft Office Specialist (MOS) certificate is a line on a CV that you can buy and that an employer can check. Whether it is worth your money is a real decision, not a default. This topic gives you the map of the exams and how they actually work. It also gives an honest way to choose between a certificate and the portfolio you have already built.

The vocabulary

• MOS (Microsoft Office Specialist) — Microsoft's official certification programme, one exam per app, delivered through authorised testing partners.
• Associate level — the core exams: Excel (MO-210), Word (MO-110) and PowerPoint (MO-310). This is the current exam series for Microsoft 365 Apps.
• Expert level — the advanced tier: Excel Expert (MO-211) and Word Expert (MO-111). The modules you met later in this subject, such as what-if analysis, sections and fields, live here.
• Live-in-the-app exam — the MOS format. You do real tasks in the real application against the clock, rather than answering multiple-choice questions.
• Certiport — the network that delivers the exams. You book and sit them at authorised centres, and many Indian colleges and training institutes are centres, or online with someone monitoring.

The mental model

The exam is a test of doing, which is good news for anyone who did this subject's work. MO-210 hands you workbooks and says "apply conditional formatting", "build this PivotTable", "fix this formula", in Excel itself, under time. The modules here map onto it almost one for one. The Excel core and analysis modules cover the Associate exam's ground, and what-if analysis, advanced functions and macros reach into Expert.

Preparation, stated honestly, is this. Redo this subject's practice files against the exam's published list of objectives, which is on Microsoft's certification pages. Always read the current list, because exam series are updated. Drill the keyboard and menu fluency the lessons taught. And take the timing seriously, because the clock, not the tasks, is what defeats prepared people.

The money question deserves grown-up arithmetic. An exam voucher in India typically costs a few thousand rupees through Certiport partners. Prices vary by centre and by bundle, so check the current price before you budget. Check too whether your college is a centre with student rates, because many are. Against that cost, ask who the certificate is for. It earns its fee where a filter reads CVs: campus placements, government and institutional recruitment, staffing agencies, and the first screen at large employers. Those are places where a credential that can be checked passes gates a portfolio link never reaches. It matters least where a person evaluates the work. A hiring manager who opens your dashboard workbook learns more in two minutes than any certificate tells them.

So here is the honest way to decide. Portfolio first, always. It is nearly free, this subject's final project has already built it, and it serves you everywhere. A certificate as well, when a specific gate you are aiming at reads certificates. Then take one exam, usually Excel Associate, because Excel is the credential the Indian office-jobs market actually filters on. A certificate instead of a portfolio: never. A certificate with no work to show is a fee paid for a line nobody can interview you about.

The work

1. Same either way: open Microsoft's certification pages and find the current list of objectives for Excel Associate (MO-210). Read it beside this subject's Excel modules, and mark anything unfamiliar. That margin is your preparation list, and it is usually short.
2. Same either way: find out what the exam would actually cost you. Search Certiport's centre locator for testing centres near you. Ask whether your college is one, because many are, with student rates. Note the current voucher price before you budget anything.
3. Same either way: make the decision on paper. Name the gate you are aiming at, such as a campus placement, a specific employer or government recruitment. Say whether that gate reads certificates. Then write the verdict — portfolio only, or portfolio plus which one exam — with the reason attached. A decision with a reason is what this topic promised.

What you should now be able to explain or do

Name the exam for each app and level, and describe the live-in-the-app format. Find the current list of objectives and map it against this subject's modules. State the cost and the audience arithmetic for your own situation. Then decide, either portfolio only or portfolio plus one exam, and give the reason.

Check yourself