Get good at Excel formulas. By typing them.

Excel formula practice means learning Excel by actually writing formulas, instead of just reading about them or watching someone else do it. You get a small table of data and a question, like “what were total sales in the North region?”, and you write the formula that answers it. Then you find out right away if you were right.

That’s exactly how this site works. Every exercise is a real spreadsheet that runs in your browser. You click cells, type formulas, press Enter and get instant feedback. If you’re wrong, you see what your formula returned and get a hint. If you’re right, you move on to something a little harder.

Why practicing beats watching tutorials

Video tutorials are great for seeing what’s possible. The problem is that following along feels like learning, even when nothing is sticking. The moment you open a blank spreadsheet at work, you can’t remember whether the range comes first or the criteria, or why your VLOOKUP returns #N/A.

Practice fixes that because it makes you recall the formula instead of recognizing it. Each time you pull the syntax out of your own memory, get it slightly wrong and correct it, the next attempt gets easier. Fifteen minutes of exercises a day will usually teach you more than an hour of videos, and you can see your progress as you go.

Which Excel formulas should you practice first?

You don’t need to know all 500 Excel functions. A small set covers most of what people use at work. We recommend practicing them in this order:

1. 1SUM, AVERAGE, MIN, MAXThe building blocks. They teach you how cell references and ranges work.
2. 2IF, AND, ORLet a formula make decisions, like marking a sale as “Big” or a student as “Pass”.
3. 3SUMIF, SUMIFS, COUNTIFSAdd up or count only the rows that match a rule. Used in almost every report.
4. 4XLOOKUP and VLOOKUPPull a value from another table. The most asked-about formulas in job tests.
5. 5INDEX and MATCHThe flexible lookup that works in every version of Excel.
6. 6Text and date functionsLEFT, MID, TRIM, TEXTJOIN, EOMONTH and NETWORKDAYS for cleaning and organizing data.
7. 7FILTER, SORT, UNIQUEModern dynamic array formulas that replace a lot of manual work.

Once these feel natural, pivot tables and charts are the next step. They let you summarize thousands of rows without writing a single formula.

How to practice for an Excel test or job interview

Many employers test Excel skills before hiring, especially for finance, analyst, operations and admin roles. These tests are usually timed and focus on a few things: lookups (VLOOKUP, XLOOKUP, INDEX/MATCH), conditional formulas (IF, SUMIFS, COUNTIFS), pivot tables, and cleaning messy data.

The best preparation is to practice those exact skills against the clock. Do a few exercises from each topic, then take a timed practice test. Look at which questions slowed you down and go back to that topic. Repeat until the test feels easy.

How long does it take to get good at Excel formulas?

It depends on where you start, but most people are surprised by how quickly it comes together. With 15 to 20 minutes of practice a day, a beginner can usually get comfortable with SUM, IF and SUMIFS within a couple of weeks, and with lookups not long after. The key is doing a little every day instead of cramming once a month.

Practice in your browser, no Excel license needed

You don’t need to install anything. The exercises run in a spreadsheet built into the page and use the same formula syntax as Microsoft Excel, so everything carries over to your real work. Most formulas work the same way in Google Sheets too. When you want to keep going offline, Premium members can download the practice files and open them in Excel.

Ready to try? Start with the free exercise at the top of the page. It takes about 30 seconds.

Want to go deeper on one function first? Our Excel formula guides explain XLOOKUP, VLOOKUP, IF, SUMIFS, COUNTIF and more, each with a live exercise at the end.