Skills test
Excel test
Almost every analyst, operations and finance job description asks for "strong Excel", yet a line on a CV tells you nothing about whether a candidate can actually build a working model, reconcile two messy exports or turn ten thousand rows into a decision. An Excel test replaces that guesswork with a hands-on work sample: candidates complete realistic spreadsheet tasks under the same conditions, and you compare them on what they can do rather than how confidently they describe themselves.
A good Excel assessment goes beyond trivia about ribbon menus. It puts a genuine dataset in front of the candidate and asks them to clean it, look values up across tables, summarise it with a pivot, and interpret what the numbers mean for the business. Because the tasks mirror day-one work, the results predict on-the-job performance and give every applicant the same fair, job-relevant chance to show their skill — regardless of where they learned Excel.
What it measures
Formulas and functions
Whether the candidate can construct correct formulas — arithmetic, IF and nested logic, SUMIFS and COUNTIFS, text functions like LEFT, TRIM and CONCAT, and date maths — and knows when to lock references with absolute and relative addressing.
Lookups and data joining
Combining data across tables with VLOOKUP, INDEX/MATCH or XLOOKUP, handling exact versus approximate matches, and dealing gracefully with missing keys and #N/A errors instead of letting them break a report.
Pivot tables and summarisation
Building pivot tables to aggregate, group and cross-tabulate data, adding calculated fields and filters, and reshaping a flat export into a clear summary that answers a specific business question.
Data cleaning and preparation
Spotting and fixing duplicates, inconsistent formatting, stray whitespace, mixed data types and text-stored numbers so a dataset is trustworthy before any analysis begins.
Interpretation and communication
Reading the output correctly — drawing the right conclusion from a chart, trend or summary table, sanity-checking totals, and explaining what the numbers imply rather than just producing them.
Efficiency and accuracy
Reaching the correct answer without brittle, error-prone workarounds, using structured references and consistent methods, and producing results that hold up when the underlying data changes.
Question formats
Who it's for
This test fits any role where spreadsheets are core to the work — data and business analysts, financial analysts and accountants, operations and revenue-operations staff, and administrative or reporting roles. Use it for junior to mid-level hires where day-to-day Excel fluency is the deciding factor, and calibrate task difficulty upward for senior analyst or finance positions that involve modelling. It works well as an early screen to shortlist fairly, or as a deeper stage before a final interview.
How to read the results
- 1Read scores against the actual demands of the role, not a universal bar — a reporting job leans on pivots and lookups, while a finance role weights formula accuracy and modelling more heavily.
- 2Look at the breakdown by competency, not just the headline number: a candidate strong on formulas but weak on data cleaning will behave very differently on the job than the reverse.
- 3Weight accuracy and sound method over raw speed; a correct, robust answer built with structured references is worth more than a fast one that breaks when the data changes.
- 4Treat the result as a strong, job-relevant signal to combine with an interview and a reference check — use it to focus your follow-up questions on real gaps, not to make the decision in isolation.
Skills test
Assess this skill on real, job-relevant work
Configure a role-tuned assessment and watch it adapt by seniority — no signup.
Related roles
Related reading
Work sample tests: the most predictive way to assess candidates
Work sample tests measure what a candidate can actually do — and they predict on-the-job performance better than résumés or unstructured interviews. Here's how to use them well.
Skills-based hiring: evaluate ability before the resume
Resumes tell you where someone has been, not what they can do. A practical look at screening on demonstrated skill first — and why it widens, and fairens, your funnel.
Frequently asked questions
What is an Excel test?
An Excel test is a pre-employment assessment that measures how well a candidate can actually use spreadsheets — writing formulas, performing lookups, building pivot tables, cleaning data and interpreting results. Instead of trusting a self-reported skill level, you give applicants realistic, hands-on tasks and score them on the work they produce, which is a far better predictor of on-the-job performance.
How do you assess excel skills?
The most reliable way is a work-sample approach: give candidates a real, slightly messy dataset and ask them to complete the tasks the job requires — clean the data, join it across tables with lookups, summarise it in a pivot table, and explain what it means. Mix live spreadsheet tasks with formula-building, a debugging exercise and a couple of interpretation questions so you see both technical accuracy and judgement, then read the competency breakdown against the specific role.
What Excel skills should analysts and finance hires have?
For most analyst, operations and finance roles the core skills are confident formula construction (including IF logic, SUMIFS and text and date functions), lookups with INDEX/MATCH or XLOOKUP, pivot tables for summarising data, disciplined data cleaning, and the ability to interpret and sanity-check results. Senior finance roles add financial modelling and scenario work; a good Excel test lets you set the difficulty to match the level you are hiring for.