FormulaGym
XP 0
Streak 0

Excel functions: find the one you need

Pick a function, or filter by the kind of work you do. Every function has a lesson page and a free practice exercise.

17 ready to practise · 9 coming soon
SUMBeginner

Add up a column or range of numbers

FinanceSales & OpsHR
6 lessons · 1 freeLearn it
AVERAGEBeginner

Find the typical value in a set of numbers

FinanceSales & OpsHR
6 lessons · 1 freeLearn it
MAX / MINBeginner

Find the highest or lowest value fast

Sales & OpsFinance
5 lessons · 1 freeLearn it
COUNTBeginner

Count how many cells contain numbers

Data cleanupHR
5 lessons · 1 freeLearn it
COUNTIFIntermediate

Count rows that meet a condition

Sales & OpsHRData cleanup
6 lessons · 1 freeLearn it
SUMIFIntermediate

Add up only the rows that meet a condition

FinanceSales & Ops
5 lessons · 1 freeLearn it
COUNTIFSIntermediate

Count rows that meet several conditions

HRSales & OpsData cleanup
5 lessons · 1 freeLearn it
SUMIFSIntermediate

Add up rows that meet several conditions

FinanceSales & Ops
6 lessons · 1 freeLearn it
IFIntermediate

Show one result or another based on a test

FinanceHRSales & Ops
6 lessons · 1 freeLearn it
Nested IFIntermediate

Choose between three or more outcomes

FinanceHRSales & Ops
5 lessons · 1 freeLearn it
AND / ORIntermediate

Combine several tests inside IF

FinanceHRSales & Ops
5 lessons · 1 freeLearn it
ROUNDIntermediate

Tidy numbers to a set number of decimals

Finance
5 lessons · 1 freeLearn it
VLOOKUPIntermediate

Find a value in a table by its ID

Sales & OpsFinanceHR
6 lessons · 1 freeLearn it
XLOOKUPIntermediate

A modern, flexible replacement for VLOOKUP

Sales & OpsFinanceData cleanup
6 lessons · 1 freeLearn it
INDEX / MATCHAdvanced

Look things up in any direction

FinanceSales & Ops
5 lessons · 1 freeLearn it
IFERRORIntermediate

Replace errors with something readable

Data cleanupFinance
5 lessons · 1 freeLearn it
LEFTBeginner

Pull the first characters out of text

Data cleanup
6 lessons · 1 freeLearn it
IFSIntermediate

Test several conditions without nesting

HRFinance
Coming soon
TEXTJOINIntermediate

Combine text from several cells

Data cleanup
Coming soon
TRIM / CLEANBeginner

Remove stray spaces and hidden characters

Data cleanup
Coming soon
DATEDIFIntermediate

Work out time between two dates

HR
Coming soon
PMTAdvanced

Calculate a loan or lease payment

Finance
Coming soon
NPVAdvanced

Value future cash flows today

Finance
Coming soon
FILTERAdvanced

Pull out only the rows you need

Data cleanupSales & Ops
Coming soon
UNIQUEIntermediate

List each value once

Data cleanup
Coming soon
LETAdvanced

Name values inside a formula

Finance
Coming soon