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
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
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
You need to be familiar with content covered in The Essentials
All training spreadsheets for future practice
Full colour booklet to accompany the lesson
£479 for up to 6 delegates
£79.83 for each additional place
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