Advanced Microsoft Office Specialist training and certification

Develop advanced Microsoft Office knowledge and skills and prove that through a Microsoft Office Specialist (MOS): Expert qualification. Advanced MOS x600.jpg

MOS Excel Expert, MOS Word Expert and MOS Access Expert courses and qualifications are now available to Cardiff Met students and staff, for free.

Sign-up: Courses

Sign-up for a MOS Expert induction session to find out more about the training and certification and to start your Microsoft Office Specialist: Expert journey.

There are 3 intakes a year - November, March and May/June.

There are no items to show in this view of the "IT Training Schedule" list.

Sign-up: Key Concept Sessions

Key Concept sessions are optional. They explore some of the course material through worked examples and exercises. They are open to all students & staff regardless of whether you enrol on the full course. See a description of each session.

There are no items to show in this view of the "IT Training Schedule" list.

Where and how to attend?

Sessions listed as Online (in the Campus column, above) will be held through a Microsoft Teams meeting. A link (URL) to the meeting and joining instructions will be sent after booking on a session. In person sessions will be held in a digital skills training room, see directions to our rooms.

Some sessions will be held in person and online, so ensure you choose your preferred booking type when signing-up. We recommend you attend these in person (if you can) but full support will be provided for those joining online.

Target Audience

​Cardiff Met students or staff.


A good level of general ICT proficiency is required, e.g. ability to manage files, use a web browser. For the Word Expert and Excel Expert courses you should pass the MOS Word and MOS Excel specialist qualifications (respectively) or alternatively have an equivalent level of knowledge and skill.


The course and exam are free to Cardiff Met students and staff, but places are limited.

Course Overviews

There are three Microsoft Office Specialist: Expert courses and qualifications available. Here is a brief overview of each.

Course Structure

To enrol on a course you need to attend an induction session and complete the induction form. The induction explains the nature and structure of the courses and the resources available.

The core of each course is comprehensive video-based LearnKey e-lessons. In addition, the courses include practice questions and exercises and GMetrix practice (mock) exams. The courses can be studied at your own pace.

Each course concludes with the Microsoft Office Specialist: Expert exam: a 50 minute, computer assessed exam in which you have to complete several tasks on realistic spreadsheets, documents or databases. The exams can be taken remotely, from your home.

Visit our Microsoft Office Specialist page to find out more about MOS and the benefits of a MOS qualification.

Key Concept Session Details

MOS Excel Expert Key Concept Session 1: Conditional Functions

This Excel Expert Key Concept session focuses on using conditional functions, such as IF, COUNTIF, AVERAGEIF and SUMIF that output different values depending on whether conditions are true or false.

MOS Excel Expert Key Concept Session 2: PivotTables

This Excel Expert Key Concept session explores PivotTables, which are a quick and flexible way to create reports on your data. You will learn how to insert PivotTables, "pivot" the data to present it in different ways, format PivotTables, group data and summarise data by different functions.

MOS Word Expert Key Concept Session 1: Styles and Mail Merge

This Word Expert Key Concept session explores styles and mail merge. You will learn how to customise styles to make your documents look professional, and manage recipients lists and create merged documents to perform a mail merge.


Candidates who successfully pass an exam will gain a Microsoft Office Specialist: Expert qualification. You will receive:

  • a physical and digital certificate
  • a digital badge that can be used to share (e.g. on LinkedIn) and verify your achievement


Got a question?

See whether the Certification FAQs page answers it, or find out more about MTA on our Microsoft Office Specialist page.  If you still have questions, get in touch with the IT Training team via email.