| # | TITLE ▲ | DIFFICULTY ▲ | TOPIC ▲ | COMPANY ▲ | ROWS | ACTION |
|---|
Interactive challenges · Formulas · Real-world datasets · Coming Soon
We're building interactive Excel challenges with real datasets, auto-graded formula tasks, and company-style data problems. Stay tuned!
=SUM(A1:A10)
=AVERAGE(A1:A10)
=COUNT(A1:A10)
=MAX(A1:A10) / =MIN(A1:A10)
=ROUND(A1,2)
Foundation formulas — used in almost every Excel task.
=VLOOKUP(val,range,col,0)
=XLOOKUP(val,lookup,return)
=INDEX(range,MATCH(val,col,0))
=HLOOKUP(val,range,row,0)
Used to fetch data from tables. XLOOKUP is the modern VLOOKUP replacement.
=IF(condition,true,false)
=IFS(c1,v1,c2,v2,...)
=AND(cond1,cond2)
=OR(cond1,cond2)
=IFERROR(formula,"")
Control formula output based on conditions. IFERROR handles divide-by-zero gracefully.
=SUMIF(range,criteria,sum_r)
=SUMIFS(sum_r,r1,c1,r2,c2)
=COUNTIF(range,criteria)
=COUNTIFS(r1,c1,r2,c2)
=AVERAGEIF(range,crit,avg_r)
Aggregate only rows that meet your conditions — like SQL WHERE.
=LEFT(text,n) / =RIGHT(text,n)
=MID(text,start,len)
=LEN(text)
=TRIM(text)
=TEXTJOIN(",",TRUE,range)
Clean, split and combine text data from messy datasets.
=TODAY() / =NOW()
=DATEDIF(start,end,"D")
=WORKDAY(start,days)
=EOMONTH(date,0)
=YEAR(date) / =MONTH(date)
Calculate deadlines, tenures, and date differences in reports.
=PMT(rate,nper,pv)
=NPV(rate,cashflows)
=IRR(cashflows)
=FV(rate,nper,pmt)
=PV(rate,nper,pmt)
Essential for loan calculations, investment analysis and financial modelling.
=FILTER(range,condition)
=UNIQUE(range)
=SORT(range,col,order)
=SEQUENCE(rows,cols)
=OFFSET(ref,rows,cols)
Dynamic array formulas (Excel 365+) — replace complex array formulas.