This course is designed for people who want to use, edit or create mathematical and logical formulas in their spreadsheets.
To be able to automate Excel processes by writing and troubleshooting mathematical & logical formulas.
Will be able to read, write and edit the following formulas:
Nesting IF functions
Nesting IF with AND, OR and TODAY functions
SUM, SUMIF, SUMIFS, MAX, MIN, MODE, AVERAGEIF
COUNT, COUNTA, COUNTIF and COUNTIFS functions
Advanced Filter to extract unique values
3 hours with lots of hands-on practical exercises
Must be familiar with the very basics of writing a formula.
£435 including the hire of 8 laptops
All training spreadsheets for future practice
Full-colour booklet to accompany the lesson
Fill out the form below to discover how ALX Training can help you:
Or talk to us directly...
+44 1534 873785
+44 7797 774676