Excel Formula Practice & Formulas

Explore syntax, real-world examples, and business use cases for 200+ spreadsheet formulas with instant in-browser verification.

Formulas

200+ Formulas

Categories

11 Categories

Practice

Interactive Grid

Access

100% Free

Explore All Excel Formula Categories

28 formulas
Text Formulas

Learn Excel text formulas such as LEFT, RIGHT, MID, LEN, TRIM, and SUBSTITUTE with interactive lessons and exercises.

CHAR, UNICHAR & CODE Formulas
CONCAT & TEXTJOIN String Formulas
EXACT Case-Sensitive Text Formula
Explore Path
26 formulas
Date and Time Formulas

Practice 27 Excel date and time formulas like TODAY, NOW, DATE, DATEDIF, and NETWORKDAYS with interactive exercises. Manage schedules and calculate durations efficiently.

DATE & DATEVALUE Formulas
DAYS & DATEDIF Date Difference Formulas
EDATE & EOMONTH Month Shift Formulas
Explore Path
12 formulas
Logical Formulas

Practice 11 Excel logical formulas like IF, IFS, AND, OR, SWITCH, and IFERROR with interactive exercises. Build decision engines, validate data, and automate alerts efficiently.

AND, OR & NOT Compound Logic Formulas
IF Conditional Decision Formula
IFERROR & IFNA Error Shield Formulas
Explore Path
16 formulas
Information Formulas

Practice 17 Excel information formulas like ISNUMBER, ISTEXT, ISBLANK, ISERROR, and TYPE with interactive exercises. Inspect cells and validate data types efficiently.

CELL & INFO Inspection Formulas
ISNUMBER & ISTEXT Data Type Inspection
ISERROR & ISNA Error Auditing Formulas
Explore Path
24 formulas
Math and Trig Formulas

Practice 26 Excel math and trigonometry formulas like SUM, SUMIFS, ROUND, PRODUCT, and MOD with interactive exercises. Perform calculations and solve complex numeric problems efficiently.

ABS Absolute Value Math Formula
CEILING & FLOOR Multiple Rounding Formulas
INT & TRUNC Integer Math Formulas
Explore Path
26 formulas
Financial Formulas

Practice Excel financial formulas like PMT, FV, PV, IRR, and NPV with interactive exercises. Analyze loans and calculate investments efficiently.

Asset Depreciation Formulas (SLN & DB)
CUMIPMT & CUMPRINC Cumulative Loan Formulas
DOLLARDE & DOLLARFR Fractional Prices
Explore Path
18 formulas
Lookup and Reference Formulas

Practice 14 Excel lookup and reference formulas like VLOOKUP, XLOOKUP, INDEX, MATCH, and OFFSET with interactive exercises. Retrieve data and connect datasets efficiently.

ADDRESS Coordinate Cell Reference Formula
CHOOSE Index Selection Formula
FORMULATEXT Formula Inspection Tool
Explore Path
32 formulas
Statistical Formulas

Practice Excel statistical formulas like AVERAGE, COUNTIFS, MAX, MIN, and STDEV with interactive exercises. Analyze data trends and perform calculations efficiently.

AVERAGE & AVERAGEIFS Statistical Formulas
CORREL & Linear Regression Formulas
COUNT, COUNTA & COUNTBLANK Formulas
Explore Path
18 formulas
Engineering Formulas

Practice Excel engineering formulas like DEC2BIN, BIN2DEC, HEX2DEC, COMPLEX, and BITAND with interactive exercises. Handle base conversions and bitwise logic efficiently.

Binary Number Base Conversions
BITAND, BITOR & BITXOR Bitwise Logic
COMPLEX & IMAGINARY Number Formulas
Explore Path
Formula Handbook

How to Learn Excel Formulas

Understanding Excel formulas shouldn't mean deciphering dense technical documentation. Each formula page includes verified syntax rules, parameter definitions, and practical workplace calculations.

Jump from reading formula definitions straight into practicing them live. Test arguments and edge cases in our spreadsheet simulator before applying formulas to critical production sheets.

01

Select a Category

Pick a category like Lookup & Reference, Text, or Financial.

02

Choose a Formula

Explore specific formulas like XLOOKUP, SUMIFS, or DATEDIF.

03

Syntax & Real Cases

Review parameter requirements, default options, and examples.

04

Interactive Practice

Validate formula calculations live inside our spreadsheet playground.