Excel test for administrative assistants: what to expect
Office and admin roles often screen for everyday Excel: totals and averages, simple IF rules, counting entries, cleaning names and emails, and working with dates.
What employers usually test
Try a sample task
From lesson 14, Joining text. Graded instantly.
Full name
In
D2, join first and last name with a space. Fill down to D6.Your 14-day prep plan
About 30 minutes a day. Free lessons first; Pro lessons are marked.
| Day | Focus | Access | Time |
|---|---|---|---|
| 1 | Your first formula | Free | 21 min |
| 2 | SUM, AVERAGE, MIN, MAX & COUNT | Free | 22 min |
| 3 | Relative vs absolute references | Free | 24 min |
| 4 | Percentages & growth | Free | 22 min |
| 5 | The IF function | Free | 22 min |
| 6 | AND, OR & IFS | Free | 24 min |
| 7 | COUNTIF & SUMIF | Free | 23 min |
| 8 | VLOOKUP | Pro | 24 min |
| 9 | Joining text | Pro | 22 min |
| 10 | Cleaning messy data | Pro | 23 min |
| 11 | DATE, YEAR, MONTH & TEXT | Pro | 23 min |
| 12 | UNIQUE & SORT | Pro | 24 min |
| 13 | Timed run: the analyst interview capstone | Pro | 20 min |
| 14 | Retake the skills test and compare | Free | 10 min |
Questions
Do I need advanced formulas?
Usually not. Speed and accuracy on the basics matter more: totals, simple IF rules, sorting and clean text.
What if the test uses an older Excel version?
Everything in the first two tracks works in any version. Newer functions like XLOOKUP are marked in each lesson.
How long should I prepare?
The first 8 lessons are free and take about an hour each with practice.