Further Details | |
---|---|
Course Code | LA18194 |
Location | Yale |
Duration | Part Time, 9:00-16:00 |
Department | Digital Technologies, Computing & IT |
Start Date | 17 Dec 2024 |
End Date | 17 Dec 2024 |
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
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.
Open Event – Yale & Yale Sixth
12/03/2025
17:30
Our Open Events are the perfect opportunity for you to have a look around & get all the info you need to help you make a decision on your next step.
Accessible Open Event – Llysfasi
28/11/2024
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
21/11/2024
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.