Develop advanced Microsoft Office knowledge and skills and prove that through a Microsoft Office Specialist (MOS): Expert qualification.
MOS Excel Expert, MOS Word Expert and MOS Access Expert courses and qualifications are now available to Cardiff Met students and staff,
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.
|Sign Up>>||Advanced Office training & certification - Induction||16/06/2022 13:00||16/06/2022 14:00||Online|
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.
Summer 2022: the courses are running as flexible learning courses over the summer period. Given this, no Key Concept sessions will run, but recordings of these will be available.
|There are no items to show in this view of the "IT Training Schedule" list.|
The sessions 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.
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.
There are three Microsoft Office Specialist: Expert courses and qualifications available. Here is a brief overview of each.
MOS Excel ExpertMOS Word ExpertMOS Access Expert
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.