Excel Interview Study Guides
Short guides with live practice questions for the skills employers test.
Excel Test for Interview: What's on It and How to Pass
What employers put on an Excel interview test, how it's scored, and a free practice test with real formulas.
Read guide →VLOOKUP Interview Questions, Answered
The VLOOKUP and INDEX-MATCH questions interviewers ask, the common mistakes, and live practice in your browser.
Read guide →SUMIFS Practice Exercises
Practice SUMIF and SUMIFS with live exercises. Learn the argument order and common interview traps.
Read guide →Excel Test for Data Analyst Roles
What data analyst Excel tests cover: SUMIFS, lookups, pivot tables, text cleaning. Free practice with real formulas.
Read guide →IF Function Practice
Practice Excel's IF function, nested IFs, AND/OR and IFS with live exercises graded instantly.
Read guide →How to Remove Duplicates in Excel
Remove duplicates in Excel with the Remove Duplicates button, UNIQUE, or flag them with COUNTIF. Includes a live practice exercise.
Read guide →Excel Subtraction Formula
How to subtract in Excel: cells, ranges, percentages and dates. With a live practice exercise graded instantly.
Read guide →Excel Multiplication Formula
Multiply cells, columns and ranges in Excel with *, PRODUCT and SUMPRODUCT. Includes a live practice exercise.
Read guide →INDEX MATCH in Excel
Learn INDEX MATCH in Excel: syntax, why it beats VLOOKUP, two-way lookups and a live practice exercise.
Read guide →Excel Percentage Formula
Calculate percentages in Excel: percent of total, percent change and percent difference. With live practice.
Read guide →Excel ROUND Function
Round numbers in Excel with ROUND, ROUNDUP, ROUNDDOWN and MROUND. Examples plus a live practice exercise.
Read guide →Weighted Average in Excel
Calculate a weighted average in Excel with SUMPRODUCT and SUM. Step by step, with a live practice exercise.
Read guide →Separate First and Last Name in Excel
Split full names into first and last name in Excel with LEFT, FIND, MID, TEXTSPLIT or Text to Columns. Live practice included.
Read guide →Combine Text from Two Cells in Excel
Join text from two or more cells in Excel using &, CONCAT and TEXTJOIN, with spaces and separators. Live practice.
Read guide →Excel "Does Not Equal" (<>)
How to use 'does not equal' (<>) in Excel formulas: IF, COUNTIF, SUMIF and conditional formatting. With live practice.
Read guide →Excel TRIM Function
Remove leading, trailing and double spaces in Excel with TRIM, plus fixes for non-breaking spaces. Live practice included.
Read guide →