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.
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.
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.
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'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 (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
VLOOKUP Not Working? Convert Text to Date? (Excel Text to Columns) When working with imported data in Excel, it is not uncommon to encounter issues with numbers and dates not being recognized properly. Importing data via Power Query provides us with a