Microsoft Office Specialist Excel for Staff

​​Learn how to analyse, manipulate and present data in Excel.  The Microsoft Office Specialist Excel course will give you the skills you need to master the principle features of Excel.   Once you have developed your skills, prove it by gaining a globally renowned Microsoft Office Specialist qualification.

The course blends face-to-face Key Concept sessions, bespoke e-learning and practice projects to provide comprehensive resources for learning Excel 2016. 

Demonstrations and practice exercises use Cardiff Met spreadsheets and scenarios - such as exports from Qualtrics, Moodle data and Business Objects reports - meaning staff should be able to easily apply what they have learnt to their role at Cardiff Met. 

Target Audience

​Staff who use Excel in their role at Cardiff Met.  (Student course also available).


Prerequisites

​Some experience with Excel is recommended, but full training and resources will be provided.


Cost

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


Spring 2019 Cohort

Enrolment for the Spring 2019 cohort is now open to Cardiff Met staff. 

Sign-up for the course by choosing one induction session then book in through MetHub (use your Cardiff Met username and password to sign-in).


Note, the course will be delivered to a mix of staff and students.

 


I really enjoyed the course. The lessons and workshops were very helpful and I also found the revision projects very helpful. It will help me a lot in my current role.

Course Structure

​The course begins with an Induction and Key Concept session. The sessions explain the resources available – a comprehensive e-learning course, practice projects, Microsoft textbooks and GMetrix practice software – and will set you off on your MOS Excel journey by exploring one of the core pillars of Excel: formulae and functions.

After the initial session, the remainder of the course will be delivered through e-learning, practice projects and additional Key Concept sessions.  Attendance at Key Concept sessions is optional, but recommended, as they explore principle features in detail and are an opportunity to get help from the course team (or we can be reached anytime through email or the MOS Yammer group).

Optional Key Concept 2 sessions will be held on Wed 6th February, 13:00 - 15:00 (Llandaff), Thu 7th February, 13:00 - 15:00 (Cyncoed) or Fri 8th February, 10:00 - 12:00 (Llandaff).  Key Concept 3 sessions will be held on 27th February, 13:00 - 15:00 (Llandaff), 28th February, 13:00 - 15:00 (Cyncoed) or Fri 1st March (Llandaff), 10:00 - 12:00.

The course concludes with the Microsoft Office Specialist exam; a 50 minute, computer assessed exam in which you have to complete several tasks on realistic Excel spreadsheets. There will be multiple exam sessions in weeks beginning 25th March, 1st April and 8th April. A "mock" exam session will be held in week beginning 18th March.


The amount of learning time depends on your current Excel knowledge, but as an estimate:

  • Classroom teaching: 2 - 6 hours
  • E-learning: 15 -20 hours
  • Practice projects and GMetrix exam practice: 5 - 9 hours
  • Certification exam: 50 minutes.
For a total of between 23 - 36 hours.



Upcoming Courses

  
  
  
Sign Up>>08/01/2019 10:00T1.11
Sign Up>>08/01/2019 13:00T1.11
Sign Up>>09/01/2019 13:00B1.01
Sign Up>>11/01/2019 10:00T1.11
Sign Up>>14/01/2019 18:00T2.22b
Sign Up>>16/01/2019 15:00T2.22b
Sign Up>>18/01/2019 10:00T1.11
Sign Up>>23/01/2019 13:00T2.22b

Specific Learning Outcomes

The key objectives for the course are listed below.  Click on each objective to find out the exact skills that will be developed:

View a PDF of the complete MOS Excel 2016 Exam 77-727 Objectives.


Certification

Candidates who successfully pass the exam (Excel 2016: Core Data Analysis, Manipulation, and Presentation) will gain the Microsoft Office Specialist Excel 2016 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 MOS FAQs page answers it or find out more about MOS on the Microsoft Learning pages.  If not, get in touch with the IT Training team via email.