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.