Excel Skills Employers Actually Test For (and How to Learn Them)
VLOOKUP/XLOOKUP, PivotTables, IF logic, cleaning data and one dashboard — the five tasks behind most Excel tests.
guide:0:in_content · 300×250 / 336×280 fluid
Nine out of ten 'Excel required' postings test the same five moves: lookups, PivotTables, IF logic, cleaning messy data, and one summary dashboard. Most candidates fail not from ignorance but from slowness — the test is timed, usually 30 to 45 minutes. Learn the five in order and you pass the filter that quietly rejects half the applicant pool.
Lookups and PivotTables first
XLOOKUP (or VLOOKUP) joins two tables; PivotTables summarise thousands of rows in seconds. Together they answer 70% of test questions: match this list, total sales by region, top five anything. Drill until each takes under two minutes.
Logic plus clean data
IF, SUMIFS and COUNTIFS turn rules into numbers; Text-to-Columns, TRIM, Remove Duplicates and Find-Replace turn chaos into a table. Tests love dirty data on purpose — the candidate who cleans first finishes first.
One dashboard to rule the test
The final question is almost always 'summarise for a manager': three KPIs, one chart, conditional formatting for attention. Build it with structured tables and named ranges so formulas stay readable under pressure.
Do this week
- Do one XLOOKUP and one PivotTable drill daily for a week.
- Download a messy public dataset and clean it start to finish.
- Rebuild one dashboard from scratch without looking at notes.
- Time yourself: full 5-task test in 40 minutes.
Quick answers
XLOOKUP or VLOOKUP — which to learn?
XLOOKUP if your Excel has it; VLOOKUP anyway for older versions. Tests accept either — speed is what scores.
Is Google Sheets enough to practise?
Yes for logic and lookups. PivotTables differ slightly, so do one dry run in real Excel before test day.
What score do employers want?
Most pass/fail around 70%. Finish all five tasks roughly and you are already above the median.
guide:0:article_end