Microsoft Office Specialist Excel

​​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.

Demonstrations and practice exercises use Cardiff Met spreadsheets and scenarios, such as exports from Qualtrics, Moodle data and Business Objects reports. This means staff should be able to easily apply what they have learnt to their role at Cardiff Met and students will get real-world experience of how to use Excel.

Read on for course details, or sign-up below


Sign-up: Full Course

The course consists of an induction, comprehensive e-learning and practice projects and optional Key Concept sessions. It culminates in the MOS Excel exam. Estimated learning time: 23–36 hours.

To sign-up for the course, choose one induction option: an induction session or an Anytime Induction that is completed online when you wish. Learn more about an Anytime Induction.

  
  
  
  
  
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.

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.

Target Audience

Cardiff Met students or staff.

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 students and staff, but places are limited.

I learned so many useful things - I always knew Excel was a powerful tool but being self-taught only knew the basics - I have used much of what I learned in my job

Course Structure

The course begins with an induction - either an induction session or Anytime Induction. The induction explains the nature and structure of the course and the resources available – a comprehensive e-learning course, practice projects, Microsoft textbooks and GMetrix practice software.

The core of the course is the e-learning and practice projects. In complement to those, there are three, optional, Key Concept sessions. These sessions explore some of the more interesting and difficult topics through worked examples and practical exercises.

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. 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.


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

  • Induction: 1 hour
  • Key Concept teaching: 0 - 6 hours
  • E-learning: 16 -20 hours
  • Practice projects and GMetrix exam practice: 5 - 9 hours
  • Certification exam: 50 minutes.

For a total of between 23 - 36 hours.


Key Concept Session Details

Key Concept Session 1: Functions

This Excel Key Concept session explores a fundamental pillar of Excel: functions. You will learn how to insert and use functions such as SUM, AVERAGE & COUNT. In addition, you will learn about AutoSum and number formatting options.

Key Concept Session 2: Organising Data

This session uses a real-life example - importing data from a Qualtrics survey - to illustrate how Excel features such as filtering, sorting, subtotals and tables can be used organise data.

Key Concept Session 3: Conditional Functions and Charts

This session will focuses on using conditional functions, such as IF, COUNTIF and SUMIF. You will also learn how to create and format charts to depict data visually.


Upcoming Courses

  
  
  
Sign Up>>03/12/2020 13:00

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 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
  • students only - Microsoft Office Specialist is a verified Higher Education Achievement Report (replacement for academic transcript) activity that will appear in section 6.1 of the report; another means of proving to employers you have the skills you claim. The course can also be used as evidence of your professional development for PDP modules.



 

Got a question?

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