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.

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.