Further Details
Course Code
LA18200
Location
Yale
Duration
Part Time, 9:00-16:00
Department
Digital Technologies, Computing & IT
Start Date
15 May 2025
End Date
15 May 2025
Course Overview
These courses are designed to develop the learner’s skills with spreadsheet software and give them the tools necessary to produce professional spreadsheets.

Excel Advanced - 6 hour course

● Sorting
● Multiple Column Sorts
● Custom Lists and Sorts
● Printing a Selection
● Displaying & Printing Formulas
● Formulas that Produce Errors
● Data Validation
● Use Drop down list with Vlookups
● Relative and Absolute Referencing
● Mixed Referencing
● Multiple IF Functions
● Lookup Functions
● Nested IF Functions - AND, OR
● Lookup Functions - H, V and X
● Macros
● PivotTables
● Scenario Manager
● Goal Seek
● Advanced Functions
● Excel and AI
Ongoing tutor support and tasks
Familiarity with the standard functionality of Excel, or completion of the Excel Extra course
This course will help to give you the skills needed to use Excel at an advanced level
£99
Useful downloads

Ready to begin your journey?

Our Open Days

Our Open Days are your chance to explore the College and find out about the range of courses we offer.

Accessible Open Event – Deeside & Deeside Sixth
13/03/2025

17:00

Neurodiverse people who want to study at Cambria are invited to our Accessible Open Events. It’s the perfect opportunity to explore everything Cambria has to offer in a sensory-supportive setting.
Accessible Open Event – Northop
26/03/2025

17:00

Neurodiverse people who want to study at Cambria are invited to our Accessible Open Events. It’s the perfect opportunity to explore everything Cambria has to offer in a sensory-supportive setting.
Accessible Open Event – Yale & Yale Sixth
19/03/2025

17:00

Neurodiverse people who want to study at Cambria are invited to our Accessible Open Events. It’s the perfect opportunity to explore everything Cambria has to offer in a sensory-supportive setting.
Accessible Open Event – Bersham Road
20/03/2025

17:00

Neurodiverse people who want to study at Cambria are invited to our Accessible Open Events. It’s the perfect opportunity to explore everything Cambria has to offer in a sensory-supportive setting.

Got a question?

Here’s how you can get in touch

A blue phone icon

Contact us

Email Us

Email

Got a question?

Here’s how you can get in touch

A blue phone icon

Contact us

Email Us

Email

You have successfully added this course to
your shortlist, are you ready to apply?