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 five, 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.
MOS courses are running as flexible learning courses over the summer period, meaning you can study at your own pace. Enrolment will open in May and remain open until July. Exam sessions will be held in June, July and early September. There will be no Key Concept sessions (as these are optional), though recordings of these will be available.
The amount of learning time depends on your current Excel knowledge, but as an estimate:
- Induction: 1 hour
Key Concept teaching: 0 - 10 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: Absolute References and Text Functions
How to use absolute references (references that do not change) and text functions such as LEFT, CONCAT and UPPER in Excel formulae.
Key Concept Session 3: Sorting and Filtering
Learn some of the ways data can be sorted and filtered in Excel.
Key Concept Session 4: IF Functions
Focuses primarily on using the IF function that outputs different values depending on whether a test is true or not.
Key Concept Session 5: Charts
In this Key Concept session we explore how to create and format charts in Excel, and the best practice for doing so.