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