Data analyst Excel test: practice the skills that get checked
Data analyst screens lean on summarizing and reshaping data: multi-condition counts, lookups, splitting text, and modern dynamic-array functions that return whole tables from one formula.
What employers usually test
Take the data analyst timed test
Five tasks in a live grid, easiest first. Graded instantly, with a lesson for every gap.
- 5 tasks in a live grid, easiest first. Graded the moment you submit
- About 10 minutes. Skip anything you don't know
- Your level and the exact lessons for your gaps, right away. No signup
- Aced it? Keep going with a bonus round of harder, interview-style tasks
Try a sample task
From lesson 27, FILTER. Graded instantly.
Two conditions
In
F5, return rows where the region matches G2 and the amount is greater than G3. If nothing matches, show None.Your 14-day prep plan
About 30 minutes a day. Free lessons first; Pro lessons are marked.
| Day | Focus | Access | Time |
|---|---|---|---|
| 1 | Relative vs absolute references | Free | 24 min |
| 2 | AND, OR & IFS | Free | 24 min |
| 3 | COUNTIFS, SUMIFS & AVERAGEIFS | Free | 25 min |
| 4 | XLOOKUP | Pro | 24 min |
| 5 | INDEX & MATCH | Pro | 25 min |
| 6 | LEFT, RIGHT, MID & LEN | Pro | 23 min |
| 7 | TEXTBEFORE, TEXTAFTER & FIND | Pro | 23 min |
| 8 | UNIQUE & SORT | Pro | 24 min |
| 9 | FILTER | Pro | 25 min |
| 10 | LET | Pro | 23 min |
| 11 | RANK, LARGE & SMALL | Pro | 24 min |
| 12 | SUMPRODUCT | Pro | 24 min |
| 13 | Timed run: the analyst interview capstone | Pro | 20 min |
| 14 | Retake the skills test and compare | Free | 10 min |
Questions
Is Excel still tested if the job uses SQL or Python?
Often, yes. Excel is a quick way for interviewers to see how you summarize and check data.
Should I learn dynamic arrays?
Yes. FILTER, SORT and UNIQUE replace many manual steps and signal that you know current Excel.
How long should I prepare?
Two weeks at 30 to 45 minutes a day, finishing with the timed capstone.
Prep for other roles
Updated Checked by running: every exercise answer on this page was graded by our formula engine on .