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 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.