Excel practice › Excel functions

Excel functions, with examples you can edit

Each page explains one function the way you'd use it at work: what it returns, its arguments, the mistakes that produce errors. Every example is a working sheet, so you can change the formula and watch the result, then solve a few exercises. Answers are included.

Lookup

Logic

Conditional math

Text

Dates

Dynamic arrays

Basics

More Excel practice

Excel practice onlineExcel skills testExcel formula playgroundExcel formula errors, fixed liveExcel test for job interviews, with answers