Further Details | |
|---|---|
Course Code | LA18202 |
Location | Yale |
Duration | Part Time, 9:00-16:00 |
Department | Digital Technologies, Computing & IT |
Start Date | 02 Jul 2026 |
End Date | 02 Jul 2026 |
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
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
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.
Bersham Road – Wheels Event
21/06/2025
10:00
Join us at Coleg Cambria site Bersham Road on Saturday 21st June
