The Function Library

The Function Library

While there are hundreds of functions in Excel, the ones you use most frequently will depend on the type of data your workbooks contains. There is no need to learn every single function, but exploring some of the different types of functions will be helpful as you create new projects. You can search for functions by category, such as Financial, Logical, Text, Date & Time, and more from the Function Library on the Formulas tab.

• To access the Function Library, select the Formulas tab on the Ribbon. The Function Library will appear.

Click the buttons in the interactive below to learn more about the different types of functions in Excel.