Utilizing Functions in Excel
Functions are the cornerstones of all data analysis. Data analysis requires that calculations take place. Calculations require functions to execute the computations. In Excel there are two kinds of functions. The ﬁrst type of function is that which resides in the cell of a Worksheet. These types of functions typically carry out mathematical operations utilizing parameters contained within other Worksheet cells. However, Worksheet cell functions are capable of doing far more than just ordinary mathematical operations on Worksheet data, and this chapter will introduce the reader to some techniques for enhancing Worksheet cell functions to accomplish far more than they were ever intended to. The second type of function is a VBA function, which is simply a function written in VBA code. What is not known to many users is that VBA functions can in fact be utilized from within Worksheet cells. The methods for accomplishing this will be covered in this chapter as well.