Interview guide
Excel rounds are practical tests — lookup and aggregation exercises on sample data, pivot-table tasks, and model-building under time limits — where formula fluency and error-checking habits are scored together.
Lookups: XLOOKUP/INDEX-MATCH versus VLOOKUP and why
Aggregation: SUMIFS/COUNTIFS across criteria, array thinking
Pivot tables: build, group, calculate fields on messy data
Data cleaning: text functions, duplicates, Power Query basics
Modeling: assumptions layout, scenario toggles, circularity avoidance
Error handling: IFERROR discipline, auditing someone else's workbook
Practice on ugly data, not clean tutorials — real Excel tests hand you merged cells, text-formatted numbers, and duplicates, and your cleanup sequence is being watched as closely as your formulas.
Excel rounds are practical tests — lookup and aggregation exercises on sample data, pivot-table tasks, and model-building under time limits — where formula fluency and error-checking habits are scored together.
Practice on ugly data, not clean tutorials — real Excel tests hand you merged cells, text-formatted numbers, and duplicates, and your cleanup sequence is being watched as closely as your formulas.
Directly — interviewers build questions from your resume's claims, so every skill and achievement listed becomes fair game. A tailored, honest resume steers the interview toward your strongest material; an inflated one hands the interviewer traps you set for yourself.
Interviewers build their questions from what your resume claims. Tailor it to the role honestly first — free ATS score, missing keywords, and a recruiter-ready rewrite.