The Excel functions are continuously being updated and improved in the Function Library group on the Formulas tab. Each book along the ribbon houses functions in categories, which makes it much easier for the user to locate functions and understand the purpose of using them. We will be looking at some functions from the various books available in the Function Library group. The first example we will use is the COUNTA function, which can easily be typed into the cell directly, but we will take the long-method route for the purpose of demonstrating the process of using the Function Library. The Function Library group can be seen in the following screenshot:
- Open the SSGRegions.xlsx workbook.
- Click on the cell in which to apply a function—in the case of this example, we will use cell B30 to work out the count of the employees. From the Function...