Excel Job Interview Questions by Position

In this article, I summarize the MOST COMMON Excel questions that are currently asked during interviews. This covers positions such as business or MIS analyst, Data Analyst, Financial Analyst or more senior positions. You'll be surprised at the level of Excel that's currently required for some of these positions.

Excel Multiple Match Results Simple

If you don't have the Filter function in Excel, you need to check out this easy formula approach to get multiple match results in Excel. Download the workbook and use the version that fits your example best.

MAXIFS MINIFS with Multiple Criteria

Excel MAXIFS MINIFS (MAX MIN with Multiple Criteria) Finding the largest or smallest value in a set is one of the first tasks beginning Excel users discover.  Just after the SUM function, the MAX and MIN functions quickly become one of the