FormulaCamp
Completed
← All paths
Learning paths

Excel Interview Questions & Test Prep

Excel interview questions and test prep: practice the VLOOKUP, SUMIFS, IF, PivotTable, data cleaning and chart tasks employers ask, with worked lessons.

29 lessons · about 7.3 h · 21 lessons are free

0 of 29 lessons done

Start the path

Who it is for

Job seekers facing an Excel test or a technical screen for finance, analyst, admin, sales or operations roles, and anyone refreshing core skills fast.

What you will be able to do

  • Solve classic lookup tasks with VLOOKUP, INDEX + MATCH and XLOOKUP, and explain the trade-offs
  • Use SUMIFS, COUNTIFS and nested IF or IFS with confidence under time pressure
  • Clean a messy dataset and summarize it with a PivotTable in a few minutes
  • Pick the right chart, avoid common formula errors and talk through your approach

Lessons in this path

  1. 1Keyboard Shortcuts and Common Beginner MistakesFreetheory and quiz10 min
  2. 2Absolute References ($)Freelesson15 min
  3. 3Named RangesFreelesson15 min
  4. 4The IF FunctionFreelesson15 min
  5. 5Nested IF and IFSFreelesson15 min
  6. 6AND, OR, NOTFreelesson15 min
  7. 7COUNTIF and SUMIFlesson15 min
  8. 8Multiple Conditionslesson15 min
  9. 9The VLOOKUP FunctionFreelesson15 min
  10. 10VLOOKUP: Range LookupsFreelesson15 min
  11. 11INDEX + MATCHFreelesson15 min
  12. 12XLOOKUPFreelesson15 min
  13. 13Formula Errors and How to Fix ThemFreelesson20 min
  14. 14IFERROR and Checking FunctionsFreelesson15 min
  15. 15Splitting Stringslesson15 min
  16. 16Cleaning Datalesson15 min
  17. 17Numbers Stored as Text and Dates from CSVlesson20 min
  18. 18Duplicates and Text to ColumnsFreelesson15 min
  19. 19Sorting DataFreelesson15 min
  20. 20Filter and SUBTOTALFreelesson15 min
  21. 21UNIQUE and SORTlesson15 min
  22. 22FILTERlesson15 min
  23. 23Tenure, Deadlines, Weekdayslesson15 min
  24. 24Conditional Formatting with a FormulaFreelesson15 min
  25. 25Data Validation and Dropdown ListsFreelesson15 min
  26. 26ChartsFreelesson15 min
  27. 27Choosing the Right ChartFreetheory and quiz15 min
  28. 28PivotTableFreelesson15 min
  29. 29PivotTable with Rows and ColumnsFreelesson15 min

Interview-style questions

Typical tasks and questions for this role. Each one is taught in a lesson of the path.

  1. What is the difference between VLOOKUP and XLOOKUP, and what does the last argument of VLOOKUP do?

    Learn it in: The VLOOKUP Function

  2. Sum sales where region is "West" and the amount is above 1,000. Which function, and how?

    Learn it in: Multiple Conditions

  3. Grade scores into A, B, C and F. Write it with nested IF and then with IFS.

    Learn it in: Nested IF and IFS

  4. Summarize 10,000 sales rows by region and month. Walk me through the PivotTable.

    Learn it in: PivotTable

  5. This list has extra spaces, mixed case and duplicates. How do you clean it?

    Learn it in: Cleaning Data

  6. Which chart would you use to compare parts of a whole versus a trend over time, and why?

    Learn it in: Choosing the Right Chart

Practice

Other paths