Category: New functions

New functions of Excel 2016

Function MAXIFS

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 arguments This function depreciates CONCATENATE Function TEXTJOIN Better than the CONCAT function (it’s strange that Microsoft …

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