Learn Excel in 10 Minutes a Day: A 4-Week Plan
A 4-week plan to learn Excel in 10 minutes a day: the formulas to practise in order, from SUM to VLOOKUP, with mini tasks you can do anywhere.
By Ayoub Farid · · 3 min read
Ten minutes is short enough to do every day and long enough to learn one formula properly. Over four weeks that adds up to about five hours of focused practice, which is enough to go from "I avoid spreadsheets" to "I can handle most everyday tasks".
The trick is the order. Each day builds on the last.
How to use each 10 minutes
- 2 minutes: write yesterday's formula from memory.
- 6 minutes: learn and practise today's formula on a small sheet.
- 2 minutes: use it once on real data (your budget, a work file, anything).
Week 1: the foundations
| Day | Learn | Mini task |
|---|---|---|
| 1 | = and cell references | Add two prices with =B2+B3 |
| 2 | Ranges and SUM | Total a column with =SUM(B2:B13) |
| 3 | AVERAGE | Average monthly spend |
| 4 | MIN and MAX | Find your best and worst month |
| 5 | COUNT and COUNTA | Count entries in a list |
| 6 | Operators and brackets | Profit: =B2-C2, margin: =(B2-C2)/B2 |
| 7 | Review | Rebuild days 1–6 without help |
Guides: SUM, AVERAGE, MIN and MAX.
Week 2: copying formulas correctly
| Day | Learn | Mini task |
|---|---|---|
| 8 | Fill down | Revenue per row, filled down |
| 9 | Relative references | Watch how references shift |
| 10 | $ absolute references | Share of total: =B2/$B$14 |
| 11 | Mixed references | A small multiplication table |
| 12 | Percentages | Percent change month to month |
| 13 | Rates and totals | Price with tax from one rate cell |
| 14 | Review | Rebuild week 2 from scratch |
Guides: fill down, absolute references, percentages.
Week 3: decisions and conditions
| Day | Learn | Mini task |
|---|---|---|
| 15 | IF | "Over budget" / "OK" |
| 16 | AND, OR inside IF | Bonus if two conditions are met |
| 17 | COUNTIF | Count orders by status |
| 18 | SUMIF | Total spend by category |
| 19 | SUMIFS and COUNTIFS | Two conditions at once |
| 20 | IFERROR | Hide #DIV/0! politely |
| 21 | Review | A mini report using all of the above |
Week 4: lookups and clean-up
| Day | Learn | Mini task |
|---|---|---|
| 22 | VLOOKUP | Price for a product code |
| 23 | XLOOKUP | Same, the modern way |
| 24 | INDEX and MATCH | Look up to the left |
| 25 | TRIM, UPPER, PROPER | Clean a messy name list |
| 26 | Joining text | First + last name |
| 27 | Dates: TODAY, DATEDIF | Age or days until a deadline |
| 28 | Final review | Take a practice test |
Keep it going
Missing one day is fine. Missing three in a row usually ends the habit, so set a fixed trigger: morning coffee, the bus, lunch. Streak-based apps help here. Cellio lessons are about two minutes each, so a 10-minute block fits three to five of them, and it keeps your streak for you. Weeks 1 and 2 of this plan match its live units.
Frequently asked questions
Can you really learn Excel in 10 minutes a day?
You can learn the formulas most jobs use, if you practise writing them every day. Complex reporting takes longer.
What if I miss a day?
Just continue. Do a short review the next day before moving on.
Do I need a computer for this plan?
No. Every task works in the Excel or Google Sheets mobile apps, or in a learning app.
What comes after week 4?
Pivot tables, charts and dynamic array functions like FILTER and UNIQUE.