Excel® 2013 On Demand

Creating Functions Using the Library

To make it easier to find the function you need for a specific use, Excel has organized functions into categories—such as Financial, Logical, Text, Date & Time, Lookup & Reference, Math & Trig, and other functions—on the Formulas tab. Functions—such as beta and chi-squared distributions—for the academic, engineering, and scientific community have been improved for more accuracy and includes new ones in all categories (New!) and web services (New!). Some statistical functions have been renamed for consistency with the real world. After you use a function, Excel places it on the recently used list. When you insert a function from the Function Library, Excel inserts the function in the formula bar and opens a ...