Workplace Productivity and Office Skills
Spreadsheets
More work decisions pass through a grid of cells than through any other tool in the office. Budgets, rotas, stock lists and sales logs all start there, in Excel or Google Sheets, and the same few ideas decide whether the file stays trustworthy: references, tables, functions and charts. This page follows the five areas Microsoft's MO-210 exam assesses and explains which habits separate a sheet people rely on from one they quietly redo.
Why this topic exists: Cells, ranges, tables, formulas and charts in Excel and Google Sheets: the MO-210 blueprint's five areas and ICDL Spreadsheets; the single most examined office skill.
A spreadsheet is a small program that most of its authors never think of as one. Each formula is an instruction, each cell reference an address, and a sheet with three hundred formulas fails the way code fails: an input overwritten by hand, a range that stops one row short, a total that silently leaves out the month someone added last. Excel and Google Sheets share nearly all of the ideas, so what follows applies to both unless it names one. The difference between a beginner and a dependable user is rarely the number of functions they know; it is whether a colleague can open the file next quarter and trust it.
Habits that keep a sheet honest
Hard functions cause few spreadsheet errors. Structure causes most of them, and a handful of rules prevents the bulk.
- Keep inputs, workings and outputs apart. Assumptions in one block or sheet, calculations in another, the summary a reader sees in a third. When a figure changes, you edit one cell and everything downstream follows.
- Use real tables, not painted ranges. A formatted table grows when rows are added, so the formulas and charts that point at it stay complete.
- Know when a reference must stay fixed. Relative and absolute references decide what a formula does when copied; confusing them is the usual reason a filled-down column goes wrong.
- Never type a constant into a formula. A tax rate or unit price buried inside a formula is invisible to the next person. Give it a labelled cell.
- Control what people type. Drop-down lists and data validation stop 'n/a', 'N.A.' and an empty cell from turning into three separate categories in the summary.
- Check totals two ways. A row sum and a column sum over the same block should agree; when they do not, something has been skipped.
What the MO-210 exam assesses
Microsoft's MOS Excel Associate examines five areas in a 50-minute proctored session, with tasks carried out in Excel rather than picked from a list. The credential renews after 60 months, and Microsoft reckons a candidate needs around 150 hours of teaching and hands-on use first; its sample workbooks are budgets, invoices, team charts and data-entry logs. ICDL's Spreadsheets module, part of the CORE programme, covers similar ground.
| MO-210 area | What it looks like at work |
|---|---|
| Manage worksheets and workbooks | Setting up a multi-sheet file, moving around it, preparing it for print or sharing |
| Manage data cells and ranges | Entering, filling and formatting data so that it reads correctly and sorts correctly |
| Manage tables and table data | Turning a list into a table, then sorting, filtering and adding a total row |
| Perform operations by using formulas and functions | Sums, counts, conditions and text clean-up that update when inputs change |
| Manage charts | Picking a chart that suits the data and labelling it so it needs no explanation |
The exam proves speed with features, not judgement about models; that judgement grows from building sheets other people must use. Once lookups, PivotTables and recorded macros become weekly work, the next step is advanced Excel. When data outgrows a workbook or has to refresh from a database, it moves to data and AI, and financial models and ledgers belong to the finance field.
Within this topic
- Advanced Excel: formulas, macros and Power QueryDynamic arrays, LET, what-if analysis, advanced PivotTables and recorded macros: the MO-211 Expert blueprint's four domains; Power Query, LAMBDA and hand-written VBA sit beyond the outline but inside the job, where a spreadsheet user becomes the office's analyst without leaving Excel.
- Digital literacy and computer essentialsFiles and folders, the browser, accounts and passwords, safety habits and typing: DigComp 2.2's information, safety and problem-solving areas and ICDL's Computer & Online Essentials; the entry point of the whole field.
- Documents and word processingStyles, sections, references, tables and document collaboration in Word and Google Docs: the MO-110 blueprint and ICDL Documents; mail merge and templates are the daily craft the exam leaves out, and the skill hiring managers assume and rarely test.
- PresentationsSlide masters, layouts, themes, notes, transitions and export in PowerPoint, Google Slides and Keynote: the MO-310 exam and ICDL Presentation; design taste is the part no exam covers.
- Email and calendarRules, folders and labels, shared mailboxes, delegation, scheduling and etiquette in Outlook and Gmail: DigComp's communication area and the MO-400 Outlook exam that still counts towards MOS Associate.
- Collaboration, file sharing and meetingsCo-authoring, version history, sharing and permissions, channels, document libraries and online meetings in Teams, SharePoint, OneDrive, Drive and Meet: DigComp 2.2's communication and collaboration area (six competences) and ICDL's Teamwork module.
- Notes and personal knowledge managementNotebooks, tags, links and search in OneNote, Loop, Notion, Evernote and Obsidian: DigComp's managing of data, information and content; a field with practices and products but no examining body, an honest gap.
- Workplace automation: Power Automate and Power AppsFlows, triggers, connectors, approvals and canvas apps built by the people who use them, plus Copilot Studio agents: the PL-900 blueprint's five areas; robotic process automation for the desktop belongs here too.
- AI assistants in the officeCopilot in Word, Excel, PowerPoint and Outlook, Gemini in Workspace, ChatGPT for everyday work, and the questions of grounding and data protection: the Applied Skills business-user lab, ICDL AI Essentials, DigComp 2.2's AI examples.
- Enterprise systems for end users: SAP and OracleModules, transactions, master data and the daily screens of SAP S/4HANA, Oracle E-Business Suite and Fusion, Dynamics 365 and Workday: SAP Learning's certifications name the consultant behind each module; the end user is who this topic serves.
Concepts to know
Glossary entries with the reason each one matters here.
- Pivot table
Groups and aggregates a record list without formulas.
- Cell reference
Relative, absolute and mixed addressing behind every copied formula.
- Data validation
Entry rules and drop-downs that keep shared sheets clean.
Certifications that test it
Vendor exams and free certificates; facts, cost and the preparation path are on each page, and the certifications hub has them all.
Tools of the trade
- Microsoft Excel
The subject of the topic, not just a tool for it.
Frequently asked
- Is Google Sheets good enough to learn spreadsheets on?
- Yes, for the concepts. References, functions, filters and charts behave the same way in both, and Sheets makes live co-editing easy. The differences show at the advanced end and in certification, where the exam ladder exists only for Excel.
- How long does it take to prepare for MO-210?
- Microsoft's own guideline is roughly 150 hours of training plus hands-on work. Someone who already builds budgets or logs in Excel every week will need much less revision than that; a newcomer should treat the figure as realistic.
- Which functions should a beginner learn first?
- SUM, AVERAGE and COUNT with their conditional forms such as SUMIFS and COUNTIFS; IF for simple decisions; one lookup function, XLOOKUP where your version has it; and a few text functions for cleaning imported data. Together they cover most of what office sheets need.
- When is a spreadsheet the wrong tool?
- When several people must edit the same records at once without overwriting each other, when changes must be kept for audit, or when the file takes minutes to recalculate. Those are signs the job wants a database, a business system or a reporting tool.
Courses in the directory
593 courses are filed here; the top 6 by our ranking, details and the provider link on each course page.
Last reviewed 26 September 2026 · Getting Digital