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 ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.