Why practising formulas beats watching tutorials
Most people learn Google Sheets formulas the same way: they get stuck, search for the function, watch a ten-minute video, nod along, then return to their own sheet and can't remember whether the range or the search key comes first. The video made sense while it was playing. The knowledge just never moved into their fingers.
That's because spreadsheet formulas are a skill, not a fact. Knowing that VLOOKUP exists is easy. Being able to type =VLOOKUP(F2, A2:C9, 3, FALSE) from memory, choose the right column number, and know why you need FALSE at the end only comes from writing it yourself, getting it wrong, and fixing it. Language apps teach vocabulary through short, repeated practice for the same reason. Formulas work the same way.
SheetsLessons.com is built around that idea. Every function on this site comes with a working spreadsheet right on the page. You read a short, realistic task (total the West region's sales, find the employee with ID 1187, clean up a column of messy names), then type the formula into a formula bar that behaves like the one in Google Sheets. You get an answer in under a second. If it's wrong, you're told what your formula actually returned, so you can see where your thinking went off track.
What makes this different from other formula sites
Your formula is tested, not your answer
Many practice sites only check whether the number in the cell matches the expected number. That means you can "pass" by doing the calculation in your head and typing the result, which teaches nothing. Here, your formula is run against the sheet you see and then against several fresh, randomly generated datasets behind the scenes. If it gives the right answer every time, it's correct. Hard-coded numbers, ranges that happen to work for one dataset, and conditions that are almost right all get caught. Any valid approach passes: SUMIFS or SUMIF, INDEX MATCH or XLOOKUP, & or CONCATENATE.
New data every attempt
Every exercise generates its own data. Press "New data" and the names, numbers and lookup values change. That stops you memorising answers and gets you used to how real spreadsheets look: never quite the same twice.
It behaves like Google Sheets, quirks included
The practice grid runs on a formula engine written to follow Google Sheets' rules. That covers argument order, error codes such as #N/A, #DIV/0! and #VALUE!, wildcards in COUNTIF, and the less obvious behaviour that trips people up at work. For example, VLOOKUP's last argument defaults to TRUE, CONCAT only accepts two values, and AVERAGE skips blank cells instead of counting them as zero. Learning those details here means fewer surprises in your real files.
Help while you type
As you write, the formula bar suggests function names, shows the arguments each function expects, and highlights the argument you're currently on. Click a cell to insert its reference, or drag across several cells to insert a range, just like in Google Sheets. The cells your formula refers to are outlined in colour so you can see exactly what it's pointing at.
What you'll learn
The site covers the 59 Google Sheets functions people use most at work, school and in personal budgets. Each one has its own guide with the syntax, a plain-English explanation of every argument, worked examples with real results, the mistakes people commonly make, and practice exercises.
- The essentials: writing your first formula, cell references, and SUM, AVERAGE, MIN, MAX and COUNT.
- Decisions: IF, IFS, AND, OR and IFERROR, the functions that make a sheet respond to its data.
- Conditional totals: COUNTIF, COUNTIFS, SUMIF, SUMIFS and AVERAGEIF, for reports like "sales by region" or "overdue invoices over $500".
- Lookups: VLOOKUP, XLOOKUP, HLOOKUP, INDEX and MATCH, the skills most often tested in spreadsheet job interviews.
- Text cleanup: TRIM, PROPER, LEFT, RIGHT, MID, FIND, SUBSTITUTE and TEXTJOIN, for turning messy imports into usable data.
- Rounding and ranking: ROUND, ROUNDUP, LARGE, SMALL, MEDIAN and MOD.
If you want a structured path, the 32-lesson course takes you through these topics in a sensible order, from your first formula to two-way INDEX MATCH lookups. If you just need one function right now, go straight to its page from the Google Sheets formulas cheat sheet.
Who it's for
People who use Sheets at work and want to stop copying formulas they don't understand from old files, or stop asking a colleague every time a report needs a new column.
Job seekers preparing for roles in operations, finance, marketing, analytics and administration, where a spreadsheet test is part of the interview. Lookups, conditional sums and text cleanup are what those tests usually check.
Students and teachers who need practice problems with instant feedback instead of answer keys at the back of a worksheet.
Excel users moving to Google Sheets who want to know what carries over and what doesn't. Nearly every function here works the same way in both, and each guide points out where Google Sheets behaves differently.
How to get the most out of it
Practise little and often. Ten minutes and three or four exercises a day will make lookups and conditional formulas feel automatic within a couple of weeks, far faster than a long tutorial once a month. When you get something wrong, read the feedback before reaching for the hint. Use "Show answer" only as a last resort, and when you do, press "New data" afterwards and solve it again without help. Your progress is saved in your browser, so you can pick up where you left off.