517+ Excel Formulas
Complete guide with practical examples, detailed syntax and tips to master every Excel function.
Explore by Category
Math and Trigonometry
Functions for performing mathematical calculations, from simple addition to advanced trigonometric formulas.
Text
Functions for manipulating and analyzing text strings: extraction, concatenation, formatting, and searching.
Lookup and Reference
Functions for looking up values in tables, cell references, and creating dynamic links.
Logical
Functions for performing logical tests, conditions, and comparisons in your Excel formulas.
Date and Time
Functions for manipulating dates and times: calculations, conversions, and temporal formatting.
Statistical
Functions for statistical analysis: averages, median, standard deviation, distributions, and probabilities.
Financial
Financial functions for investment calculations, loans, depreciation, and profitability analysis.
Database
Functions for analyzing structured data in lists with filtering criteria.
Information
Functions for testing cell type and content: checking for errors, empty values, and data types.
Engineering
Functions for engineering calculations: base conversions, complex numbers, and Bessel functions.
Compatibility
Functions retained for compatibility with earlier versions of Excel. Replaced by new functions with improved accuracy.
Cube
Functions for extracting data from OLAP (Online Analytical Processing) cubes.
Web
Functions for working with Web data and online services.