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

eLearning

Find out moreFind out more

Inductions | In-house systems
Support | Project Work

Tailored
Solutions

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

Excel – Formulas and Functions II

The Need:

To be able to combine, match & compare data across spreadsheets
To know how to troubleshoot formula errors
To protect formulas in cells & worksheets

You will learn how to:

Name cell ranges
Use the VLOOKUP & XLOOKUP functions
Know how to nest the IFERROR function
Understand the meaning behind common error messages
Troubleshoot common formula errors
Protect cells & worksheets

Logistics:

The course can be delivered online or face to face in our training centre or at your place of work. If you would like to have this class online, you will need access to two screens, a webcam, speakers & a microphone

Prerequisites:

You need to be familiar with content covered in The Essentials

Includes:

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

Cost:

£479 for up to 6 delegates
£79.83 for each additional place

Error: Contact form not found.

SUBMIT

Contact

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

    Or talk to us directly...

    +44  1534 873785
    admin@alxtraining.com


    Windward House
    La Route de la Libération
    St Helier, JE1 1BG
    Jersey

    https://what3words.com/stamp.happy.fanfare