To be able to combine, match & compare data across spreadsheets
To know how to troubleshoot formula errors
To protect formulas in cells & worksheets
Laptops will be required for this course with the relevant software installed or accessible.
This course has been designed specifically for individuals who are confident in Microsoft Excel and need to learn essential functions and formulas for their role.
Wednesday 2nd October – 9.30am – 12.30pm
Free
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
ALX Training
We are a team of experienced IT Trainers & Software Adoption Specialists who deliver creative design-led learning to private & public sector organisations.
Driven by our clients’ needs, we help organisations realise the full potential of their IT investment.
ALX Training is part of BDO Jersey, working closely with BDO Advisory and C5 Alliance to help businesses and people succeed