How to Practice Excel So It Actually Sticks
How to practice Excel effectively: write formulas from memory, use your own data, check answers by changing inputs, and space your practice. A simple method.
By Ayoub Farid · · 3 min read
Most people "practise" Excel by watching a video and following along. Then they open a blank sheet at work and nothing comes out. Following along isn't practice. Here's what is.
1. Write it from a blank cell
The test of whether you know a formula: can you write it with nothing in front of you? Close the tutorial. Open a blank sheet. Write =SUMIF( and see if the arguments come back. If they don't, that's the useful part. Check, then try again tomorrow.
2. Start with a question, not a function
Don't practise "VLOOKUP". Practise "what's the price of product P-104?". In real work you start with a question and have to choose the formula. Training that choice is half the skill.
Good questions for any sales table:
- What were total sales? (SUM)
- What's a typical month? (AVERAGE)
- Which month was best? (MAX, then lookups)
- What share of the year did each month bring? (division plus $)
- How many months beat the target? (COUNTIF)
3. Check answers by breaking them
Excel won't tell you a formula is wrong if it returns a number. So check it yourself:
- Change an input. Does the answer move? If not, you typed a value.
- Fill down and read the last row. Did the references shift the way you meant? This catches most $ reference mistakes.
- Calculate one case by hand. If 3 × 2.50 isn't 7.50 in your sheet, something's off.
- Write it two ways.
=B2+B3+B4vs=SUM(B2:B4).
4. Mix old and new
Each session, start with one formula from a previous day before learning a new one. Mixing topics (called interleaving) feels harder, and that's why it works: you have to choose the right tool each time.
5. Short and daily beats long and rare
Ten minutes a day for a month is far better than one five-hour session. Memory needs gaps and repetition. If you like structure, use the 10-minutes-a-day plan.
6. Learn from your mistakes, specifically
"Wrong" is useless. "The range has 2 cells but the data has 3" is useful. When you get a formula wrong, name the exact reason before fixing it. Our formula errors guide covers the common ones.
7. Use real data once a week
Take a real file: your bank export, a work report, a sports table. Ask three questions and answer them with formulas. Real data has messy bits (blank cells, extra spaces, text that looks like numbers) that practice data doesn't.
A practice tool that does this for you
Cellio was built around this method. Each exercise starts with a question, you write the formula by tapping cells, and the app checks it by calculating it on the sheet and on hidden versions of the data. When you're wrong, it gives the specific reason, and missed questions come back at the end of the lesson. Try our practice exercises too.
Frequently asked questions
What is the best way to practice Excel?
Write formulas from memory to answer real questions, check them by changing inputs, and practise a little every day.
Can I practice Excel without Excel?
Yes. Google Sheets, Excel for the web and learning apps all work for formula practice.
How often should I practice Excel?
Daily, for 10 to 15 minutes, is more effective than long weekly sessions.
What should I practice for an Excel test?
Core formulas, $ references, IF, COUNTIF/SUMIF and a lookup. See basic Excel test questions.