Excel Functions – Official Categories
Prefer the official structure? Filter the directory using Microsoft Excel’s built-in categories and quickly locate the formula you need.
Categories are useful when you want to explore related formulas (for example all lookup functions, date calculations, or text tools) and understand how Excel organizes its function library.
Statistical
111 functions
Browse Excel statistical functions for averages, distributions, and data analysis.
Math & Trigonometry
80 functions
Explore Excel math and trigonometry functions for calculations, rounding, powers, and numeric transformations.
Financial
55 functions
Browse Excel financial functions for loans, interest rates, payments, and cash-flow analysis.
Engineering
54 functions
Explore Excel engineering functions for complex numbers and technical calculations.
Text
44 functions
Explore Excel text functions for cleaning, splitting, extracting, and formatting text data.
Lookup & Reference
40 functions
Explore Excel lookup functions like XLOOKUP, VLOOKUP, INDEX, and MATCH to connect tables and return related values.
Compatibility
40 functions
Browse Excel compatibility functions used for legacy workbooks and older Excel versions.
Date & Time
25 functions
Browse Excel date and time functions for workdays, durations, and scheduling.
Information
22 functions
Explore Excel information functions to inspect values, types, and errors.
Logical
19 functions
Browse Excel logical functions like IF, IFS, AND, and OR to build decision rules and conditions.
Database
12 functions
Explore Excel database functions for aggregating data using criteria ranges.
Cube
7 functions
Browse Excel cube functions for querying OLAP sources and data models.
User Defined
3 functions
Browse Excel user defined functions created via VBA or add-ins.
Web
3 functions
Explore Excel web functions related to external and web-based workflows.