Skip to main content

This qualification is aimed at anyone who wishes to expand and develop their skills using spreadsheet software, such as Microsoft Excel, and is broken down into 5 levels for Introduction, Intermediate, Advanced 1, Advanced 2 and Advanced 3. Each level is 3 hours in total but delivered as three separate one-hour sessions via Zoom or Microsoft Teams and costs £20pp for each hourly session.

Introduction

Unit 1 – Basic data entry and formatting

2nd November 11:30-12:30pm

 

Unit 2 – Simple calculations and functions

9th November 11:30-12:30pm

 

Unit 3 – Introduction to Charts, Controlling charts, Sparklines, Adding graphic elements

16th November 11:30-12:30pm

Intermediate

Unit 4 – Manipulating spreadsheet views, Cell addressing, Conditional formatting

30th November 11:30-12:30pm

 

Unit 5 – Functions 2 – Conditional functions

7th December 11:30-12:30pm

 

Unit 6 – LOOKUP functions, Naming cells and ranges

22nd November 9:00-10:00ampm

Advanced 1 

Unit 7 – Auditing formulae, Protecting cells

7th october 9:00-10:00am

11th october 1:30-2:30pm

2nd November 9:30-10:30am

 

Unit 8 – Functions 3 – Text & date functions, Combining functions, Rounding

18th October 1:30-2:30pm

21st October 9:00-10:00am

2nd November 9:30-10:30am

Unit 9 – Pivot Tables, Introduction to Macros

16th November 9:30-10:30am

Advanced 2 

Unit 10 – Data Validation, Outline Features, Working Areas, Creating Excel tables

22nd November 11:00-12:00

 

Unit 11 – Managing a project, Gantt Charts, Exploring scenarios – What if analysis

22nd November 1:30-2:30pm

6th December 1:30-2:30pm

7th December 9:30-10:30am

 

Unit 12 – Functions 4 – Statistical Functions

29th November 1:30-2:30pm

13th December 1:30-2:30pm

14th December 9:30-10:30am

Advanced 3

Unit 13: Functions 5 – Nested IF, functions with multiple criteria and Forms*

 

Unit 14: Creating a Dashboard – Introduction and additional tools*^     

 

Unit 15: Creating a Dashboard – Design and create*^   

 

^Units 14 & 15 assume knowledge of pivot tables and pivot charts; conditional and lookup functions: IF, Nested IFs, COUNTIFS, SUMIFS, INDEX, XMATCH, CHOOSE, XLOOKUP; Conditional Formatting; form controls; charts; sparklines; and outlines.

Register your interest
Artboard 7Artboard 6emailArtboard 9Artboard 9Artboard 11Artboard 17Artboard 10Artboard 16Artboard 18