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.


Autumn 2018 Cohort

Enrolment for the Autumn 2018 cohort is now open to Cardiff Met staff. 

Use the Microsoft Office Specialist Excel Sign-up page on Learning Pool to enrol (use your Cardiff Met username and password to sign-in).

  • MOS Excel Induction and Key Concept Session - Tue 2nd Oct, 10:00 - 12:00, T2.22b, Llandaff Learning Centre.
  • MOS Excel Induction and Key Concept Session - Wed 3rd Oct, 13:00 - 15:00, T2.22b, Llandaff Learning Centre.
  • MOS Excel Induction and Key Concept Session - Thu 4th Oct, 10:00 - 12:00, L1.07, Cyncoed Learning Centre.

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 17th October, 13:00 - 15:00 (Cyncoed) or Fri 19th October, 10:00 - 12:00 (Llandaff).  Key Concept 3 sessions will be held on 7th November, 13:00 - 15:00 (Cyncoed) or Fri 9th November (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 19th November, 3rd December and 10th December. A "mock" exam session will also be held in week beginning 26th November.


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>>02/10/2018 10:00T2,22b
Sign Up>>03/10/2018 13:00T2.22b
Sign Up>>04/10/2018 10:00L1.07

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.