AAT Spreadsheet and Excel Requirements: Level 3 MATS Explained
Where spreadsheets appear in AAT, what the Level 3 MATS unit expects, the software you need for the practice assessment, and what Level 3 costs.
Many AAT students ask the same question early on: how much Excel do I actually need? The honest answer is that AAT does not run a single spreadsheets unit under the current Q2022 qualification, but spreadsheet skills still turn up in more than one place. The biggest is Level 3 Management Accounting Techniques, usually shortened to MATS. This guide explains where spreadsheets appear in AAT, what MATS expects, what it costs, and how to prepare. For wider exam tactics, see our guide on how to pass AAT MATS.
The details below come from AAT's published qualification and assessment information, checked on 17 October 2026. AAT updates its documents from time to time, so confirm anything that affects your booking with AAT directly.
Is there a spreadsheets unit in AAT?
No. Under the Q2022 qualification there is no standalone spreadsheets unit. Instead, spreadsheet use is built into specific units. That matters because some students expect a separate Excel paper, then discover the skill is tested inside a management accounting exam. If you are choosing between levels, our guide to the AAT levels shows how the units are organised.
Where spreadsheets appear in AAT
| Level | Unit | Where spreadsheets come in |
|---|---|---|
| Level 2 | Business Environment | AAT's delivery guidance includes accounting software and spreadsheets |
| Level 2 | Principles of Costing | Learning outcome 4 covers cell references |
| Level 3 | Management Accounting Techniques (MATS) | Learning outcome 5: use spreadsheet techniques to provide management accounting information |
We have only verified spreadsheet content for the units above. We have not confirmed how spreadsheets are used at Level 4, so we are not making claims about it here.
What MATS tests
MATS is one of the four mandatory units in the Level 3 Diploma in Accounting, alongside Business Awareness, Financial Accounting: Preparing Financial Statements, and Tax Processes for Businesses. Learning outcome 5 of MATS, titled "Use spreadsheet techniques to provide management accounting information", carries a 15 percent weighting. So spreadsheets are a meaningful slice of the unit, but not the whole of it. The other learning outcomes cover the management accounting techniques themselves, and you cannot skip them and hope your Excel will carry you.
The assessment is computer-based. AAT says it is partly computer-marked and partly human-marked, and it lasts 2 hours 30 minutes. The pass mark for AAT assessments is 70 percent. Because some of it is marked by a person, you should lay out your spreadsheet answers clearly so a marker can follow your working.
Software and device requirements
This is where students get caught out. AAT's practice assessment for MATS requires Windows with desktop Excel and macros enabled. Cloud-based Excel is not supported, and the practice assessment cannot be taken on a Mac. We are describing the requirement for the practice assessment, as that is what AAT's practice assessment page states. AAT's page also says MATS is not available to sit remotely, so check with your training provider or assessment centre about where you will sit the live exam and which equipment they provide.
In practical terms, if you own a Mac or rely on a browser-based version of Excel, ask your provider how to practise on a compatible setup well before your exam date. Finding this out the week before is a stressful way to learn it.
What it costs
AAT lists a fee of £67 for each Level 3 unit assessment. With a registration fee of £244 and four mandatory unit assessments, AAT's published total for Level 3 comes to £512. That total is registration plus four assessments, and it does not include tuition, study materials or any resit fees. Fees change, so check AAT's current list, and see our guide to AAT exam fees for a wider picture.
How to prepare for the spreadsheet part
These are our suggestions, not AAT requirements. Start with the basics that Level 2 introduces, particularly cell references, because relative and absolute references underpin almost every formula you will write. Then practise the skills that management accounting leans on, such as building simple tables, summarising data, producing charts, and checking your answers with a second method.
Get used to the exam environment early. Use AAT's practice assessment on a compatible Windows machine so you are not meeting the interface for the first time on exam day. Time yourself, because the whole assessment runs for 2 hours 30 minutes and spreadsheet tasks can quietly eat the clock.
Finally, remember that the human-marked element means presentation matters. Label your workings, keep formulas visible where the task asks for them, and avoid hard-coding numbers that should come from a cell reference.
Frequently asked questions
Do I need to be good at Excel before starting AAT?
No. Spreadsheet skills are introduced at Level 2 and developed in MATS at Level 3, so you can build them as you go.
How much of MATS is about spreadsheets?
Learning outcome 5, the spreadsheet outcome, has a 15 percent weighting according to AAT.
Can I practise on a Mac?
AAT's MATS practice assessment cannot be taken on a Mac, so you will need a Windows machine with desktop Excel and macros.
What is the pass mark?
AAT's pass mark is 70 percent across its assessments.
If you are planning your AAT route, explore Learnsignal's AAT courses and start building your Level 3 skills with a clear plan.
This page was last updated:
Learnsignal Education Team
Expert Tutor at Learnsignal
Qualified professional with years of experience helping students advance their professional careers.
View all posts by Learnsignal Education Team