16-18

Computing and IT

Construction & Building Services

Creative & Visual Arts

Creative Media Production

Engineering & Automotive

Foundation Studies

Hair & Beauty

Health, Social Care & Early Years

Travel, Tourism & Events
Apprenticeships

Accountancy & Bookkeeping

Business & Administration

Carpentry & Joinery

Catering & Hospitality

Construction & Building Services

Customer Service

Electrical

Engineering & Automotive

Hairdressing

Health, Social Care & Early Years

Plumbing

Teaching

Team Leading & Management
University Level

Creative & Visual Arts

Creative Media Production

Engineering & Automotive

Health, Social Care & Early Years

Sport & Public Services
Adults

Access to Higher Education

Accountancy & Bookkeeping

Assessor Qualifications (TAQA)

Creative & Visual Arts

Electrical

Hair & Beauty

Teacher Training
Microsoft Office – Excel
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