287+ Formulas
Excel Formula Guide
Your complete reference for Excel formulas and functions. Browse by category, learn with examples, and generate custom formulas with AI assistance.
Browse by Category
25+ formulas
Lookup & Reference
VLOOKUP, HLOOKUP, INDEX, MATCH functions
50+ formulas
Math & Trigonometry
SUM, AVERAGE, COUNT, mathematical calculations
30+ formulas
Text Functions
CONCATENATE, LEFT, RIGHT, MID text manipulation
20+ formulas
Date & Time
DATE, TIME, NOW, TODAY date calculations
15+ formulas
Logical Functions
IF, AND, OR, NOT conditional logic
40+ formulas
Statistical
STDEV, VAR, PERCENTILE statistical analysis
35+ formulas
Financial
NPV, IRR, PMT financial calculations
12+ formulas
Database
DSUM, DCOUNT, DAVERAGE database operations
20+ formulas
Array & Dynamic
FILTER, SORT, UNIQUE dynamic array formulas
40+ formulas
Engineering
CONVERT, BIN2DEC engineering functions
Why Learn Excel Formulas?
Excel formulas are the foundation of spreadsheet productivity. Whether you are analyzing data, creating reports, or automating tasks, mastering formulas will save you hours of work.
Save Time
Automate calculations that would take hours to do manually
Reduce Errors
Eliminate manual calculation mistakes with tested formulas
Boost Career
Excel proficiency is one of the most in-demand workplace skills
Generate Any Formula with AI
Describe what you need in plain English, and our AI will create the perfect Excel formula with a full explanation.
Try Formula Generator