Excel Advanced

Further Details
Course Code
LA99270
Location
Yale
Duration
Part Time, 6 hours – 9:00-16:00
Department
Digital Technologies, Computing & IT
Start Date
02 Mar 2023
End Date
02 Mar 2023

Shortlist

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
● Macros
● PivotTables
● Scenario Manager
● Goal Seek
● Advanced Functions
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
£59 or free if eligible for PLA funding. To be eligible, you must be over 19, employed and earning under £29,534 per year or a furloughed worker (any salary) or self-employed
Useful downloads

Ready to begin your journey? Apply now

Our open days

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

Adult Open Event – Bersham Road
24/01/2023

16:00

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.
Adult Open Event – Yale
24/01/2023

16:00

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.
Adult Open Event – Deeside
23/01/2023

16:00

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.
Cambria Christmas Markets – Yale
06/12/2022

Got a question?

Here’s how you can get in touch

A blue phone icon

Contact us

Email Us

Email

Follow Us

Follow us

Got a question?

Here’s how you can get in touch

A blue phone icon

Contact us

Email Us

Email