Excel Function Reference
This 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.