Get confident with Excel formulas.
Practise the formulas you actually use at work, from SUM and IF to lookups and dates. Type a formula, and Confident Cells tells you straight away whether it's right, and what went wrong if it isn't.
Start the first lesson freeSee pricing
- No account or card needed to start
- Works in your browser, nothing to install
- The same formulas work in Excel and Google Sheets
In C2, work out the 20% VAT on each invoice. Your formula will be copied down to C7.
| A | B | C | |
|---|---|---|---|
| 1 | Invoice | Net | VAT |
| 2 | INV-11 | £120.00 | |
| 3 | INV-12 | £89.50 | |
| 4 | INV-13 | £45.50 | |
| 5 | INV-14 | £12.40 | |
| 6 | INV-15 | £260.00 | |
| 7 | INV-16 | £7.50 |
77 short lessons
379 exercises
26 function guides
£0 to start
How it works
- Learn. A short worked example builds the formula one step at a time, with real numbers first.
- Practise. Write it yourself on a real-looking sheet. Hints are there if you need them.
- Check. Prove it on fresh data, with no help, and the lesson is marked Secure.
- Come back. A daily challenge keeps it fresh, a few minutes at a time.
Marking that explains, not just "wrong"
- You type real formulas, just as you would in Excel or Google Sheets. No multiple-choice guessing.
- Every answer is checked on changed data, so a formula that only works by luck doesn't pass.
- Fresh data every time you replay, so you learn the method rather than the answer.
- Built for work: invoices, timesheets, attendance, mark sheets and absence, not made-up puzzles.
C2=ROUND(B2*H1,2)
Excel practice for the job you do
As well as the everyday formulas, there are sections built around real tasks in UK offices, schools and HR teams.
Office and admin
Invoices and VAT, hours on a timesheet, budgets and deadlines.
Schools and colleges
Attendance percentages, mark sheets, grade boundaries and class lists.
HR and people
Bradford Factor scores, holiday entitlement, length of service and absence.
Tidying messy data
Trimming spaces, splitting names, removing duplicates and summing up.
Work guides: VAT in Excel · Excel test for a job interview · Holiday entitlement in Excel · The Bradford Factor in Excel · Attendance percentage in Excel, and persistent absence · Grade boundaries in Excel
Practise the formulas people use most
Each practice page has an exercise to try straight away and links into the full lesson.
Formula basicsSUM, AVERAGE, MAX, MIN, COUNTAbsolute references ($)Percentages and ROUNDIFGrades with IFS and IFERRORCOUNTIF and COUNTIFSSUMIF and AVERAGEIFVLOOKUPBands and approximate matchXLOOKUP and INDEX/MATCHINDEX and MATCH, one at a timeText functionsDates and deadlinesTimes and hours workedCriteria from cells, and wildcardsAND and ORRanking and top scoresHLOOKUP: tables that run acrossMean, median and modeSearching text and wildcardsMatching codes with SWITCH
Function guides with worked examples
Plain-English guides, each with the mistakes to watch for and a sheet to try it on.
Looking things up
Adding up and counting
Decisions and errors
Formula basics
Text
Dates and times
Every lesson
77 lessons in 10 sections. Lessons marked Free open straight away, with no account.
Getting started and shortcuts
Core formulas
- Formula basics Free
- SUM, AVERAGE, MAX, MIN, COUNT
- Absolute references ($)
- Percentages and ROUND
- IF
- COUNTIF and COUNTIFS
- Criteria from cells, and wildcards
- SUMIF and AVERAGEIF
- Grades with IFS and IFERROR
- AND and OR
- VLOOKUP
- Bands and approximate match
- XLOOKUP and INDEX/MATCH
- Text functions
- Dates and deadlines
- Times and hours worked
- Ranking and top scores
- Find and fix
More functions
- TRUE, FALSE and logical tests Free
- Checking cells with IS functions
- Matching codes with SWITCH
- HLOOKUP: tables that run across
- Searching text and wildcards
- Mean, median and mode
- Rounding to steps: FLOOR, CEILING, EVEN, ODD
- Building dates: DATE, DAYS, YEAR, MONTH
- Joining and splitting text
- Counting blanks and entries
- INDEX and MATCH, one at a time
- Lists that spill: UNIQUE, FILTER, SORT
- Fixing SUM formulas
- Today's date: TODAY and DATEDIF
- Working across worksheets
- SUMIFS practice
- VLOOKUP practice
- MATCH and INDEX practice
- Working on a whole column at once
Skill reviews
Office and admin
Tidy and analyse
Schools and colleges
HR and people
Pack tasters
Who it's for
People who use spreadsheets at work
For anyone who copies formulas from colleagues, or avoids them. Start from the basics, or go straight to the formula you need.
Schools and colleges
Staff training for support staff, data staff and teachers, with sections on attendance, mark sheets and grade boundaries.
Teams
So everyone can do the basics without asking the one spreadsheet person. School and team licences come with a completion list.
Free to start. Pro when you want the lot.
£0
- All of Getting started
- The first lesson of every other section
- The daily challenge
- No account needed
£34.99 a year
or £4.99 a month. The yearly plan saves 40%.
- All 77 lessons and 379 exercises
- Every work section, and the certificate
- Progress saved to your account, on any computer
- Cancel any time
From £99 a year
- Pro for every member of staff
- Paid by invoice, no card needed
- A completion list for your CPD lead
Questions
Do I need Excel?
No. Practice happens in your browser. The formulas work the same way in Excel and Google Sheets, so what you learn carries straight over.
Is it for complete beginners?
Yes. Getting started covers moving around a sheet, selecting and filling cells, and the shortcuts that save time. Formula basics then starts from what a formula is. All of that is free. If you already know the basics, jump to any lesson.
Will it help with an Excel test for a job?
The core lessons cover what admin and office tests usually ask: SUM and AVERAGE, IF, COUNTIF and SUMIF, lookups, percentages and absolute references.
Do I need an account?
Not for the free lessons. Your progress is kept in your browser. Sign in with your email to keep it safe and use it on another computer. Pro needs an account.
Can I cancel Pro?
Yes, at any time, from your account page. You keep Pro until the end of the period you've paid for. VAT isn't added: the price you see is the price you pay.
Does it work on a phone?
Yes, but a keyboard makes it much easier.
Start with Formula basics.
It takes about 10 minutes, and it's free.