Daily Excel puzzle
One formula to write, every day, in a live spreadsheet. The same puzzle for everyone, a new one at midnight. It takes about two minutes, and it's free.
How it works
- Each puzzle gives you a small sheet and one thing to work out. Any formula that gets it right counts.
- The clock starts when you do. Every formula you enter that isn't right yet counts as a try.
- Two hints are there if you need them. You can also ask for the answer, but then the day doesn't count as solved.
- The week starts easy and gets harder. Monday and Tuesday are beginner puzzles, Wednesday to Friday intermediate, and the weekend advanced.
- Solving the puzzle earns XP and counts as practice for your streak and your daily goal.
What the puzzles are about
- Beginner: largest and smallest, rounding, counting, percentages, arithmetic, counting with a condition, joining text, if, dates.
- Intermediate: conditional sums, lookups, counting with two conditions, text, dates, several conditions, ranking, weighted average, loans, rounding.
- Advanced: statistics, dynamic arrays, lookups, dates with a condition, sumproduct, ranking, text.
When a puzzle comes round again it has new names and numbers, so it is the skill you remember, not the answer. After each puzzle you see a formula that solves it, why it works, and the lesson that teaches it.
Common questions
When does the puzzle change?
At midnight where you are. Everyone gets the same puzzle on the same date.
Do I need Excel?
No. The puzzle runs in a spreadsheet in your browser that understands Excel formulas. What you practise works the same way in Excel and in Google Sheets.
What if I can't solve it?
Open a hint, then the second one. If it still won't come, ask for the answer. The day isn't counted as solved, but you see the formula, why it works and the lesson that teaches it.
Is my formula wrong if it differs from the answer shown?
No. Any formula that gets the right result from the data counts. Typing the result in doesn't.
How is the streak counted?
A day counts when you solve that day's puzzle. Miss a day and the streak starts again. It is kept in your browser, or with your account if you sign in.
Want more than one a day? Take the Excel skills test, or start the course.