16-18
![](https://www.weymouth.ac.uk/wp-content/uploads/2018/06/Computing-144x144.jpg)
Computing and IT
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Brickwork-144x144.jpg)
Construction & Building Services
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Visual-Arts-2_1920x824-144x144.jpg)
Creative & Visual Arts
![](https://www.weymouth.ac.uk/wp-content/uploads/2019/09/Media-144x144.jpg)
Creative Media Production
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Automotive-Motor-Vehicle-Motorcycle_1920x824-144x144.jpg)
Engineering & Automotive
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Customer-Servicess_1920x824-144x144.jpg)
Foundation Studies
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Hairdressing_1920x824-1-144x144.jpg)
Hair & Beauty
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Heath-and-Social-Care_1920x824-144x144.jpg)
Health, Social Care & Early Years
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Travel-and-Tourism_1920x824-144x144.jpg)
Travel, Tourism & Events
Apprenticeships
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Accounting_1920x824-144x144.jpg)
Accountancy & Bookkeeping
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Jess-144x144.jpg)
Business & Administration
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Carpenry-and-joinery_1920x824-144x144.jpg)
Carpentry & Joinery
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Balti-night-144x144.jpg)
Catering & Hospitality
![](https://www.weymouth.ac.uk/wp-content/uploads/2018/06/Computing-144x144.jpg)
Computing and IT
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Brickwork-144x144.jpg)
Construction & Building Services
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/10/shop-144x144.jpg)
Customer Service
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Electrical_1920x824-144x144.jpg)
Electrical
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Automotive-Motor-Vehicle-Motorcycle_1920x824-144x144.jpg)
Engineering & Automotive
![](https://www.weymouth.ac.uk/wp-content/uploads/2020/06/Haircut-144x144.jpg)
Hairdressing
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Heath-and-Social-Care_1920x824-144x144.jpg)
Health, Social Care & Early Years
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Plumbing_1920x824-144x144.jpg)
Plumbing
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Teaching_1920x824-144x144.jpg)
Teaching
![](https://www.weymouth.ac.uk/wp-content/uploads/2018/01/Team-leading-144x144.jpg)
Team Leading & Management
University Level
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Visual-Arts-2_1920x824-144x144.jpg)
Creative & Visual Arts
![](https://www.weymouth.ac.uk/wp-content/uploads/2019/09/Media-144x144.jpg)
Creative Media Production
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Automotive-Motor-Vehicle-Motorcycle_1920x824-144x144.jpg)
Engineering & Automotive
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Heath-and-Social-Care_1920x824-144x144.jpg)
Health, Social Care & Early Years
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Public-Services_1920x824-144x144.jpg)
Sport & Public Services
Adult Learning
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Applied-Science_1920x824-144x144.jpg)
Access to Higher Education
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Accounting_1920x824-144x144.jpg)
Accountancy & Bookkeeping
![](https://www.weymouth.ac.uk/wp-content/uploads/2017/07/Quote-Melanie_1920x824-144x144.jpg)
Assessor Qualifications (TAQA)
![](https://www.weymouth.ac.uk/wp-content/uploads/2024/07/Green-Skills-banner-1-144x144.jpg)
Green Skills
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 £30pp for each hourly session.
Please contact us for the next available course dates.
Introduction
Unit 1 – Basic data entry and formatting
Unit 2 – Simple calculations and functions
Unit 3 – Introduction to Charts, Controlling charts, Sparklines, Adding graphic elements
Intermediate
Unit 4 – Manipulating spreadsheet views, Cell addressing, Conditional formatting
Unit 5 – Functions 2 – Conditional functions
Unit 6 – LOOKUP functions, Naming cells and ranges
Advanced 1
Unit 7 – Auditing formulae, Protecting cells
Unit 8 – Functions 3 – Text & date functions, Combining functions, Rounding
Unit 9 – Pivot Tables, Introduction to Macros
Advanced 2
Unit 10 – Data Validation, Outline Features, Working Areas, Creating Excel tables
Unit 11 – Managing a project, Gantt Charts, Exploring scenarios – What if analysis
Unit 12 – Functions 4 – Statistical Functions
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.