All articles with 'new excel functions' Tag
Excel’s LAMBDA() Function let’s you create and share your own functions. It is a true game changer. Learn how to use it with 4 practical examples in this article.Continue »
Ever wanted to convert numbers to words in Excel? For example, 456,123 becomes four hundred fifty-six thousand one hundred twenty-three.
Microsoft recently introduced LET function to Excel. This allows us to create variables on the fly to use within a formula. I just made a words from number formula using LET function and bit of good old INDEX.
Read on to learn how this all works.Continue »