The Excel XMATCH Function was introduced in 2021 to enable excel users perform advanced matching and lookup operations. The XMATCH function is a successor to the MATCH Function, it is a more robust and flexible function compared to its predecessor. It allows users perform approximate matches with more flexibility, and it also provides options to … Read more
The LOOKUP Function is a powerful tool that allows excel users search for a specific value in a single column or row range of cells and then return a value from another single column or row range. The LOOKUP function is mostly deployed for retrieving data from large data sets or lookup tables. Lookups with … Read more
The LEFT function in excel is used to extract a specific number of characters from the left side of a text string. The function extracts from the first character on the left-hand side of a text string, up to the number of characters specified by the user through the num_chars argument. In today’s post, we … Read more
The RIGHT function in excel is used to extract a specific number of characters from the right side of a text string. The RIGHT function is similar to the LEFT function, however it extracts from the first character on the right-hand side of a text string, up to the number of characters specified by the … Read more
The AND Function in excel is a logical function that is used to check if multiple conditions are true or false. It returns a Boolean TRUE if all the conditions turn out true and FALSE if one or more of the conditions are false. The AND function is often used with other logical functions such … Read more
The ISBLANK Function in excel is used to check whether a cell is empty and return a Boolean value of TRUE if the cell is empty, and FALSE if the cell contains any data or formula. As a standalone function you may struggle to see the use of this function. But just like many other … Read more
The AVERAGEIF Function in excel is used to find the average of a range of cells that meet a specific condition or criteria. The AVERAGEIF Function is in the family of the various conditional (IF) functions, it was introduced in Microsoft Excel 2007 and although it has a superior successor in the AVERAGEIFS function, it … Read more
The excel rank function returns the rank of a numeric value compared to other numerical value within a specified range of values. You can rank in Ascending or descending order with the RANK Function, and the function is very useful in data analysis for sorting an filtering data by rank and identifying the highest and … Read more
The Excel IFERROR Function is a simple but yet elegant function that helps you tidy up formulas that calculate into an error. With the IFERROR Function you are able to return a custom output should a formula generate an error. If in a situation the initial formula works fine and returns an output as expected, … Read more
The weekday function is an excel function used to return the day of the week of any given date. It returns a number from 1 – 7, where 1 represents Sunday and 7 represents Saturday. What is the point of this function you ask. Well, there are so many uses, and one vital to financial … Read more
