Category: New functions

New functions of Excel 2016

With the new release of Excel 2016, six new very interesting functions have been added in three libraries. Library Text Function CONCAT Combines the text from multiple ranges and/or strings, but it doesn’t provide the delimiter or ignore empty argumentsThis function depreciates CONCATENATE Example of the function CONCAT – No delimiter between each cells Function …

Continue reading

50 new functions in Excel 2013

With Excel 2013, 50 new functions have been added. Here they are and for some of them, few extra explanations. Most of them are dedicated for top level engineers or statisticians. But there is also some very useful functions for a daily practice of Excel. Date and time 2 new Date and time functions. ISOWEEKNUM …

Continue reading