Confident Cells
Excel and Google Sheets practice for work

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
Try one now

In C2, work out the 20% VAT on each invoice. Your formula will be copied down to C7.

ABC
1InvoiceNetVAT
2INV-11£120.00
3INV-12£89.50
4INV-13£45.50
5INV-14£12.40
6INV-15£260.00
7INV-16£7.50

77 short lessons

379 exercises

26 function guides

£0 to start

How it works

  1. Learn. A short worked example builds the formula one step at a time, with real numbers first.
  2. Practise. Write it yourself on a real-looking sheet. Hints are there if you need them.
  3. Check. Prove it on fresh data, with no help, and the lesson is marked Secure.
  4. 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)

Not yet. It's right in C2, but when it's copied to C3 it gives £0.00 instead of £18.00. Check which references should be locked with $ and which should move.
Real marking from the VAT exercise: the formula works on the first row, then breaks when it's copied down.

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

All Excel practice exercises

Function guides with worked examples

Plain-English guides, each with the mistakes to watch for and a sheet to try it on.

Every lesson

77 lessons in 10 sections. Lessons marked Free open straight away, with no account.

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.

Free

£0

  • All of Getting started
  • The first lesson of every other section
  • The daily challenge
  • No account needed

Start practising

Pro

£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

Get Pro

Schools and teams

From £99 a year

  • Pro for every member of staff
  • Paid by invoice, no card needed
  • A completion list for your CPD lead

School prices

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.

Try it now