Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel Interview Questions for Practice & Exam Preparation
Rating: 5.0 out of 5(1 rating)
42 students
Created byVivek Chauhan
Last updated 3/2026
English

What you'll learn

  • Subject Matter Mastery
  • Critical Thinking & Problem Solving
  • Time Management & Organization
  • Independent Learning

Course content

6 sections • 232 lectures • 5h 0m total length

  • Count between dates by age range8:24
  • Count birthdays by year0:56
  • Count cells between dates2:17
  • Count cells between two numbers3:05
  • Count cells equal to1:19
  • Count cells equal to case sensitive1:02
  • Count cells equal to one of many things1:40
  • Count cells equals to this or that1:40
  • Count cells greater than1:02
  • Count cells less than0:49
  • Count cells not between two numbers1:17
  • Count cells not equal to0:59
  • Count cells not equals to many things0:55
  • Count cells not equal to x or y1:42
  • Count cells that are blank0:50
  • Count cells that are not blank1:31
  • Count cells that begin with0:45
  • Count cells that contain case sensitive1:14
  • Count cells that contain either x or y1:58
  • Count cells that contain errors0:45
  • Count cells that contain n characters1:45
  • Count cells that contain negative numbers1:02
  • Count cells that contain numbers0:59
  • Count cells that contain odd & even numbers2:44
  • Count cells that contain positive numbers1:04
  • Count cells that contain specific text2:35
  • Count cells that contain text & non text1:46
  • Count cells that do not contain errors0:58
  • Count cells that do not contain many strings1:25
  • Count cells that end with1:19
  • Count columns that contain specific values2:11
  • Count dates by day of week1:51
  • Count dates in given year0:52
  • Count if row meets internal criteria1:42
  • Count if row meets multiple criteria1:08
  • Count if two criteria match2:13
  • Count matches between two columns1:05
  • Count matching values in matching columns1:26
  • Count missing values0:58
  • Count non-blank cells by category0:49
  • Count not equal to multiple criteria2:23
  • Count numbers by nth digit2:15
  • Count numbers by range1:10
  • Count numbers that begin with1:33
  • Count numbers with criteria2:15
  • Count or sum whole numbers only3:49
  • Averageif with filter0:36
  • Calculate grades with vlookup0:59
  • Calculate gainers and losers1:50

Requirements

  • No such requirements needed, anyone can learn this course

Description

Excel interview questions cover basics (cells, Ribbon, formulas), core functions (VLOOKUP, SUMIF, IF, COUNTIFS), data analysis (PivotTables, charts, conditional formatting), and advanced topics like INDEX-MATCH, macros, and Power Query, testing both fundamental knowledge and practical application for data handling, analysis, and reporting. Questions range from defining concepts like absolute vs. relative references to solving real-world problems with functions and tools to assess a candidate's proficiency for various roles.

Beginner / Foundational Questions

  • Basics: What is a cell, workbook, worksheet, Ribbon?

  • Formulas/Functions: How do formulas start? Difference between formula & function?

  • Cell Referencing: What are relative vs. absolute cell references? How to use $?

  • Data Handling: AutoSum, Freeze Panes, Filters, Conditional Formatting


    Intermediate Questions

    • Core Functions: VLOOKUP, HLOOKUP, SUMIF, COUNTIF, COUNTA, COUNTBLANK, IF, AND, OR, CONCATENATE.

    • Data Management: Data Validation (dropdowns), Named Ranges, Text to Columns, Wildcards (*, ?).

    • Analysis: PivotTables (creation, fields, slicers), Charts (types, creation).

    • Troubleshooting: Handling errors (IFERROR), limitations of VLOOKUP.


    Advanced & Data Analyst Questions

    • Advanced Functions: INDEX-MATCH (vs. VLOOKUP), FILTER, SORT, XLOOKUP, LET, SUMPRODUCT, IFERROR, &.

    • Data Analysis Tools: Data Analysis ToolPak (regression), What-If Analysis, Power Query.

    • Automation: Macros (VBA), Power BI integration, connecting to external data.

    • Best Practices: Creating dashboards, handling large data, protecting sheets/workbooks.

In short you will be an expert in Excel.

Who this course is for:

  • Beginner Excel who wants to learn Advance Excel & get job easily.

Report abuse