Excel Function Reference

Function Reference LogoThis section of the Clarkson ITT Wiki includes articles and videos explaining the syntax of functions and demonstrating their use in a range of examples from simple to advanced. There are other sources of information on these functions, but some of the terminology and explanations, even those maintained by the Microsoft community, are not correct.

Whilst this body of work is to some degree a replication of the information available elsewhere, the purpose is to provide our alumni with carefully curated information that assumes a precise terminology as taught in our courses, removing some of the ambiguity in more loosely curated resources. It is also intended as a source of troubleshooting information to assist in understanding and fixing problems in models and analyses.

Title Modified Date
CELL Function 01 August 2021
FIND, SEARCH, LEN and LENB Functions 10 July 2021
INFO Function 01 August 2021
T and N Functions 10 July 2021
TODAY and NOW Functions 10 July 2021

Was the information in this article helpful?

Invalid Input
Thanks! Do you have any suggestions to make it better?
Let us know how you think we could improve...


Invalid Input

Clarkson ITT builds & delivers
expert training, in classrooms
& online, for professionals in
finance, funds management &
accounting - developing their
skills in modelling and analysis.


+61 2 9871 0399
PO Box 104
West Pennant Hills NSW 2125
Clarkson ITT Company page