In this Excel training course, learners will explore advanced functions such as lookup and error functions for precise data retrieval and error handling.

The training includes logical and statistical functions for effective data analysis, and learners will acquire skills in creating and using range names in formulas for improved organisation and data validation techniques are taught to set restrictions on data entry, promoting consistency.

Automation is introduced through basic macro recording, allowing users to streamline repetitive tasks.

COURSE PRE-REQUISITES:

Learners who wish to attend this course must have a good knowledge of Excel and be competent at working with formulas using absolute cell references, use basic functions like sum, average, max, min, count and be able to write formulas across multiple sheets and multiple workbooks.