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 IFS Function

The IF function is one of the most popular functions in Excel. But what about the IFS function? Does it really make writing nested IF functions easier? Let's find out.

Excel Dynamic Sorted Chart

Create an automatically sorted Excel bar chart that ALSO lets you hide and show categories based on a flag in the cell. It's super easy with Excel dynamic arrays.

Excel DGET Function

Quickly learn how to use Excel's DGET Function to lookup one or more criteria. DGET can also do a left lookup (unlike VLOOKUP). It's a forgotten Excel database function. Can you apply DGET to a range of cells? Find out in this article.

Excel FILTER Function

Excel's New Dynamic Array FILTER Function The FILTER function can be thought of as the new power lookup function; in many cases replacing the traditional VLOOKUP and INDEX/MATCH functions when searching for data in a table. Situations you will benefit from when

Excel XLookup Explained

Excel XLOOKUP Explained (Goodbye VLOOKUP!) In this post, we will examine Excel’s BEST function for performing a lookup… We’re going to look at how the new (upcoming) XLOOKUP function solves common lookup problems typically solved by older functions like… LOOKUP VLOOKUP HLOOKUP