Excel Formulas

Practice with real-world datasets and instant feedback

Math

SUM
Basic

The SUM function is your go-to tool for adding up numbers quickly. Whether you're calculating total sales, expenses, or...

5 challenges Practice
SUMIF
Intermediate

SUMIF is perfect when you need to add up numbers based on a specific condition. Want to know total sales for a particula...

5 challenges Practice
SUMIFS
Intermediate

When one condition isn't enough, SUMIFS steps in. This powerful function lets you add numbers based on multiple criteria...

5 challenges Practice
ROUND
Basic

Round a number to a specified number of digits

3 challenges Practice

Statistical

AVERAGE
Basic

Need to find the typical value in your data? AVERAGE calculates the mean of your numbers, helping you understand trends...

5 challenges Practice
COUNT
Basic

COUNT is your simple yet powerful tool for counting how many cells contain numbers. Use it to track the number of transa...

5 challenges Practice
COUNTIF
Basic

Count cells that meet a single condition

3 challenges Practice
COUNTIFS
Intermediate

Count cells that meet multiple conditions

3 challenges Practice
AVERAGEIF
Basic

Calculate average of cells that meet a condition

2 challenges Practice
AVERAGEIFS
Intermediate

Calculate average of cells that meet multiple conditions

3 challenges Practice
MAXIFS
Intermediate

Find the maximum value among cells that meet conditions

4 challenges Practice
MINIFS
Intermediate

Find the minimum value among cells that meet conditions

3 challenges Practice
MAX
Basic

Find the largest value in a range

3 challenges Practice
MIN
Basic

Find the smallest value in a range

3 challenges Practice
COUNTA
Basic

Count non-empty cells in a range

3 challenges Practice

Lookup & Reference

VLOOKUP
Intermediate

Search for a value in the first column and return a value from another column in the same row

3 challenges Practice

Text

LEFT
Basic

Extract characters from the beginning of text

3 challenges Practice
RIGHT
Basic

Extract characters from the end of text

3 challenges Practice
MID
Basic

Extract characters from the middle of text

3 challenges Practice
LEN
Basic

Count the number of characters in text

3 challenges Practice
TRIM
Basic

Remove extra spaces from text

3 challenges Practice
UPPER
Basic

Convert text to uppercase

3 challenges Practice
LOWER
Basic

Convert text to lowercase

3 challenges Practice
CONCAT
Basic

Join text from multiple cells or ranges

3 challenges Practice

Logical

IF
Intermediate

Return one value if condition is true, another if false

3 challenges Practice