To make logical comparisons between values & what you expect
To know how to use If & Nested IF Formulas
To summarise data using SUMIF & COUNTIF formulas
To be able to write, troubleshoot & fix logical & mathematical functions
This course runs on multiple dates, when you apply please choose the date you would prefer.
Monday 16th October – 9.30 – 12.30 – FULL, NO SPACES AVAILABLE
Wednesday 15th November – 9.30 – 12.30
This course is supported by The Government of Jersey – Skills Jersey
You will learn how to:
Read, write & edit IF formulas
Nest multiple IF functions together
Nest IF formulas using AND, OR & TODAY functions
Use Sum, SUMIF, SUMIFS, MAX, MIN, MODE, AVERAGEIF, COUNT, COUNTA, COUNTIF & COUNTIFS functions
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