Excel Formula Categories
Master every Excel formula category. From financial calculations to dynamic arrays, learn with examples and generate formulas instantly with AI.
Financial Formulas
Master Excel financial formulas including NPV, IRR, PMT, FV, PV, and more. Learn how to perform inve...
Text Formulas
Learn Excel text manipulation formulas including CONCATENATE, TEXTJOIN, LEFT, RIGHT, MID, TRIM, and ...
Date & Time Formulas
Master Excel date and time formulas including DATE, DATEDIF, NETWORKDAYS, EDATE, and more. Calculate...
Lookup Formulas
Master Excel lookup formulas including VLOOKUP, XLOOKUP, HLOOKUP, INDEX-MATCH, and more. Learn to re...
Math Formulas
Learn Excel mathematical formulas including SUM, SUMIF, SUMIFS, SUMPRODUCT, and more. Perform calcul...
Logical Formulas
Master Excel logical formulas including IF, IFS, AND, OR, NOT, SWITCH, and more. Create conditional ...
Statistical Formulas
Learn Excel statistical formulas including AVERAGE, STDEV, CORREL, PERCENTILE, and more. Perform dat...
Array Formulas
Master Excel dynamic array formulas including FILTER, SORT, UNIQUE, SEQUENCE, and more. Create power...
Information Formulas
Learn Excel information formulas including ISBLANK, ISERROR, ISNUMBER, TYPE, and more. Check cell co...
Database Formulas
Master Excel database formulas including DSUM, DCOUNT, DAVERAGE, and more. Perform database-style op...
Generate Any Excel Formula with AI
Describe what you need in plain English and get the perfect Excel formula instantly. No more memorizing complex syntax.