Early access · free to start

Learn Google Sheets by doing, not by watching.

Short, hands-on exercises for VLOOKUP, QUERY, IMPORTRANGE and more. Write the formula yourself, get instant feedback, and still remember it next week.

Try it in a live sheet Browse guides
  • VLOOKUP & XLOOKUP
  • SUMIF & COUNTIF
  • FILTER & QUERY
  • IMPORTRANGE
  • ARRAYFORMULA
  • Apps Script, and more

No video. Touch the sheet.

Click the highlighted cell, type a formula, press Enter. The sheet checks your answer instantly, just like the real lessons.

Fruit & Veg Sales
+Sheet1

Live exercise · try it

Three steps, five minutes

Each lesson covers one function. No long videos, no setup.

Read a short guide

Plain-English syntax and a worked example you can follow in a minute or two.

Write the formula

A real task with a small sample table. You type the formula yourself.

Get instant feedback

See right away if it is correct, with a hint when it is not.

Try one right now

No sign-up. Use the table below, type your formula, and press Check.

ABC
1IDProductPrice
2P-101Notebook4.50
3P-102Pen1.20
4P-103Backpack32.00
5P-104Stapler8.75

Find a price with VLOOKUP

Write a formula that returns the price of product P-104 from A1:C5, using an exact match.

Hint: the price is in the 3rd column of A2:C5, and an exact match needs FALSE as the last argument.

Want the explanation first? Read the full VLOOKUP guide, which includes a second exercise.

The fun way to learn Sheets skills

Most people learn spreadsheet formulas the same way: they watch a tutorial, nod along, and then forget it by the time they need it at work. Watching someone type =VLOOKUP is not the same as typing it yourself.

Sheet Exercise is built around one idea: you learn a formula by writing it. Every lesson gives you a small table, a real task, and a box to type your answer. You find out right away whether it works.

We start with the functions people search for the most, explain each one in plain English, and add more every week.

Practice for busy people

You do not have time for a ten-hour course. Each lesson covers one function and takes a few minutes: read a short guide, then do the exercise. You can finish one on a coffee break and pick up the next one tomorrow.

No more boring videos. There is nothing to pause, rewind, or copy from a screen. You type every formula yourself, and typing is what builds memory. After a few rounds of VLOOKUP, SUMIF or FILTER, the syntax starts to feel natural.

The lessons are short enough that you can work through the core functions in days, not months.

Online practice, no setup

Every exercise runs in your browser. The sample table is on the page, you type your formula into the box, and the page checks it on the spot. There is nothing to install, no file to download, and no account to create.

Your formula is compared with the accepted answers right in your browser. It is not stored or sent anywhere.

When you are ready to try the same formula in a real spreadsheet, open Google Sheets in another tab and paste it in.

Use Sheets to level up your career

Spreadsheets sit under a surprising amount of daily work: finance reports, sales pipelines, marketing dashboards, inventory lists, project trackers. People who can look up, sum, filter and clean data quickly finish that work faster and make fewer mistakes.

Formula skills also show up in hiring: many analyst, operations and finance roles include a spreadsheet test. Practicing the exact functions those tests use is a direct way to prepare.

Google Sheets is free, runs in any browser, and works the same on every team you join, which makes it a good place to build the habit.

Hands-on, one skill at a time

People learn skills by doing, not watching. So each lesson teaches a single skill, shows it in a worked example, and then asks you to repeat it on a new problem. Repeating it is what makes it stick.

What is coming next:

  • More functions, from XLOOKUP and SUMIF to QUERY, ARRAYFORMULA and IMPORTRANGE In progress
  • Levels from easy to advanced, so you always know what to practice next Planned
  • Progress tracking and points for correct answers Planned
  • Downloadable practice sheets you can copy into your own Google Drive Planned

For beginners and power users

We start with the functions people look up the most, then move on to QUERY, ARRAYFORMULA and automation with Google Apps Script.

Questions

Is Sheet Exercise free?

Yes. The guides and exercises that are live today are free and need no account. Advanced lessons may be added as a paid option later.

Do I need to create an account?

No. You can read the guides and do the exercises without signing up.

How does the exercise check my formula?

The page compares what you type with the accepted answers for that task, right in your browser. Your formula itself is not stored or sent anywhere.

Will this help me with Excel too?

Many core formulas, such as VLOOKUP, SUMIF and COUNTIF, work the same way in Excel. The exercises are written for Google Sheets, and the guides point out Sheets-specific behavior.

Is Sheet Exercise affiliated with Google?

No. Sheet Exercise is an independent learning site. Google Sheets is a trademark of Google LLC.

Get started for free

No sign-up required. Pick a function and start practicing.

Try the free exercise Browse guides