What employers test, the Excel skills each role needs, and how to prepare for an Excel assessment with confidence.
12 articles
Before an Excel test, practise ten tasks: fill a calculation down, build a % of total column, count by condition, count and sum with two conditions, fill a summary grid, look up to the left, find the name of the top item, do a two-way lookup, handle missing data, and summarize a case study by group.
Common Excel interview questions cover formulas and order of operations, relative and absolute ($) references, VLOOKUP, INDEX MATCH and XLOOKUP, IF with AND or OR, COUNTIFS and SUMIFS, pivot tables, filters and fixing errors. Good answers name the function, give its arguments in order and explain one limitation or edge case.
An Excel assessment test usually gives you a dataset and practical questions: totals, IF, COUNTIFS and SUMIFS, lookups, sorting, filtering and sometimes pivot tables or a short case study. Scoring commonly checks that the result is right, that it comes from a formula rather than a typed number, and that it still works when inputs change.
The Excel shortcuts that save the most time in a test are Ctrl+Arrow to jump to the edge of your data, Ctrl+Shift+Arrow to select to the edge, Ctrl+D and Ctrl+R to fill formulas, F4 to add $ signs, Alt+= for AutoSum and Ctrl+Shift+L for filters. On a Mac, most use ⌘ instead of Ctrl.
A data analyst needs Excel skills for every stage of an analysis: cleaning text and dates, joining tables with XLOOKUP or INDEX MATCH, pulling subsets with FILTER, UNIQUE and SORT, summarizing with COUNTIFS, SUMIFS and pivot tables, and checking results. Knowing when a pivot table or a formula is the better tool matters as much as the syntax.
The core Excel skills for admin jobs are entering and editing data quickly, moving and selecting with the keyboard, totals with SUM, counts with COUNTIF, sorting and filtering lists, and clear formatting for currency, dates and headers. Add SUMIF and a simple lookup and you can handle most trackers, logs and reports an office uses.
The key Excel skills for finance jobs are absolute ($) references for rates and totals, ROUND for real rounding rather than display formatting, SUMIFS for totals by account and period, pivot tables for summaries, percent change and % of total, lookups, and simple checks that prove a report adds up. Accuracy matters more than speed.
The most useful Excel skills for HR and recruiting are counting headcount with COUNTIFS, totalling payroll with SUMIFS, calculating tenure and time to hire with DATEDIF, TODAY and date subtraction, looking up employee records with XLOOKUP or VLOOKUP, flagging eligibility with IF and AND, and cleaning names and dates so reports stay accurate.
The key Excel skills for sales and operations roles are totalling revenue by region, rep or product with SUMIF and SUMIFS, calculating percent change and % of total, finding the top order and its rep with MAX and XLOOKUP, totalling by month with date criteria, and flagging stock or targets with IF. Answers should update when data changes.
For most job tests, plan on a few weeks of short daily practice. ExcelReady's course is 69 hands-on lessons with about 6.5 hours of listed practice time. Allowing two to three times that for repeats, the basics take about a week and a typical intermediate test two to three weeks at 30 minutes a day.
To pass an Excel test for a job interview, practise the tasks tests commonly set: totals, IF, COUNTIF and SUMIF, VLOOKUP or XLOOKUP, absolute references, sorting, filtering and a simple pivot table. Build every answer from cell references so it updates when inputs change, check results against the data, and do at least one timed practice test first.
To show Excel skills on your resume honestly, name specific functions and features you can use without help, such as SUMIFS, XLOOKUP and pivot tables, instead of labels like "advanced". Add one or two bullets that describe a real task you did with them, and only list skills you could demonstrate in a test tomorrow.