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 4 levels for Introduction, Intermediate, Advanced 1 and Advanced 2. Each unit 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

31st May 9:00-10:00am

26th July 11:00-12:00

6th September 3:00-4:00PM

 

Unit 2 – Simple calculations and functions

14th June 9:00-10:00am

26th July 3:00-4:00pm

13th September 9:00-10:00am

13th September 3:00-4:00pm

 

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

5th July 1:30-2:30pm

20th September 3:00-4:00pm

18th October 9:00-10:00am

Intermediate

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

16th September 9:00-10:00am

4th October 1:30-2:30pm

18th October 9:00-10:00am

 

Unit 5 – Functions 2 – Conditional functions

4th October 3:00-4:00pm

18th October 3:00-4:00pm

13th December 1:30-2:30pm

 

Unit 6 – LOOKUP functions; Naming cells and ranges

22nd November 9:00-10:00am

Advanced 1 

Unit 7 – Auditing formulae; Protecting cells

7th October 9:00-10:00am

 

Unit 8 – Functions 3: Text & date functions; Combining functions

18th october 1:30-2:30pm

21st october 9:00-10:00am

 

Unit 9 – Pivot Tables; Introduction to Macros

 

Advanced 2 

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

8th November 1:30-2:30pm

29th November 3:00-4:00pm

 

Unit 11 – Gantt Charts; What if analysis

6th december 3:00-4:00pm

 

Unit 12 – Statistical Functions

29th November 1:30-2;30pm

6th December 1:30-2:30pm

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