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
Try a sample task
From lesson 20, 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.