3 hour Excel & Word Sessions | Beginner to Advanced
£100pp (excl GST)

Open Courses

Book nowBook now

We can create content for Inductions,
Micro Learning modules and Training Videos


Find out moreFind out more

3 fully equipped rooms
£45 per hour | Daily rates available

Room Hire

Find out moreFind out more

Inductions | In-house systems
Support | Project Work


Find out moreFind out more

Inductions | Migrations
New Processes | Best Practice

Systems Training

Find out moreFind out more
ALX Training / Excel / Excel – Formulas and Functions II

Excel – Formulas and Functions II


For individuals who want to work with text or date fields in their spreadsheets and need to clean or manipulate these text fields.


To automate Excel processes by writing and troubleshooting lookup formulas.

Course Content

Named cell ranges
VLOOKUP Function
IFERROR and IFNA Function
Understand the meaning behind common error messages
Troubleshoot common formula errors
Cell & worksheets protection
Data Validation


3 hours with lots of hands-on practical exercises


Must be familiar with the content in Excel – The Essentials.


£435 including the hire of 8 laptops


All training spreadsheets for future practice
Full-colour booklet to accompany the lesson

[contact-form-7 404 "Not Found"]


Fill out the form below to discover how ALX Training can help you:

    Or talk to us directly...

    +44  1534 873785
    +44  7797 774676
    [email protected]

    Hilary House
    19 Hilary St
    St Helier, Jersey
    JE2 4SX