In previous Excel courses, you would have learnt to write formulas and functions to perform calculations using a variety of techniques. This course takes your use of functions to the next level and teaches you many more functions within Microsoft Excel.
The course examines the use of functions with real-world scenarios.
This course is aimed at existing Excel users who need to further their knowledge. Delegates are assumed to have experience of the following:
At the end of this course, you’ll be able to:
Module 1: Function Writing Review
Module 2: Ranking and aggregate functions
Module 3: Rounding numbers
Module 4: Nesting functions
Module 5: Calculate using selective data
Module 6: IF and related functions
Module 7: Array functions
Module 8: Lookup and reference functions
Module 9: Date and Time functions
Module 10: Text functions
Module 11: Custom functions
Join our public courses in our Istanbul, London and Ankara facilities. Private class trainings will be organized at the location of your preference, according to your schedule.