Featured

XLOOKUP is the only lookup you need to learn in 2026

VLOOKUP breaks when someone inserts a column, can’t look left and defaults to the wrong match type. Here’s how XLOOKUP fixes all three, with worked examples you can copy.

Priya NairNovember 10, 2026

Read the guide

Retire VLOOKUP for good

Excel from zero

Productivity

How to use Excel: a complete beginner’s guide

Sara LindNovember 14, 2026

Retire VLOOKUP for good

Lookup

XLOOKUP is the only lookup you need to learn in 2026

Priya NairNovember 10, 2026

Totals that answer questions

Formulas

Build a sales report in five minutes with SUMIFS

Tom BeckerNovember 3, 2026

Untangle your IFs

Formulas

Stop nesting IFs: IFS, SWITCH and the lookup-table trick

Lena OkaforOctober 27, 2026

Hands off the mouse

Productivity

15 keyboard shortcuts that save you an hour a week

Marco RuizOctober 20, 2026

Pivot in 5 minutes

Data

Your first PivotTable in five minutes

Sara LindOctober 13, 2026

From messy to tidy

Data

Clean messy data with TRIM, PROPER and TEXTSPLIT

Lena OkaforOctober 6, 2026

Dates without tears

Formulas

Dates without tears: due dates, month ends and working days

Tom BeckerSeptember 29, 2026

One formula, many cells

Formulas

FILTER, SORT and UNIQUE: dynamic arrays explained

Priya NairSeptember 22, 2026

Colour that means something

Data

Conditional formatting rules that actually help

Marco RuizSeptember 15, 2026

Reading is good. Practising is better.

Every guide maps to interactive lessons where you type the formula into a live sheet and get graded instantly.

Your next lesson

D2fx=IF(C2>1000,"High","Low")

Product

Region

Sales

Size

Laptop

North

1,200

High

Phone

South

800

Low

Tablet

North

600

Low

What you get with FluentExcel

109 hands-on lessons in a real spreadsheet
Instant grading with hints when you’re stuck
12 real-world projects: budgets, dashboards, payroll
Certificates you can share

Start practising free Function cheat sheet