What Makes Excel's Lambda Functions so Awesome (and what doesn't)?

In December 2020, Microsoft announced Lambda Functions as a new Excel feature. Lambda functions are an exciting way to define custom functions (a.k.a. user-defined functions) by only relying on Excel formulas, without having to use VBA or writing an add-in. In this video, we’re going to see how Lambda Functions work and why they are so awesome. It’s not all roses though: we’ll also look at the current limitations of Lambda Functions and how to solve some of them. Currently, Lambda Functions are only available to Microsoft 365 subscribers on the Beta Channel. To see if you can already use them, start typing =LAMBDA in a cell and if Excel suggests the function name, you are all set.

[CodingIsFun]

Hi Felix,
Great tutorial! Thanks for sharing your knowledge 👍
Also, thank you so much for your awesome library 'xlwings'. *I am loving it* ❤
Cheers,
Sven

[esquire]

Done reading your book, Python for Excel and I learned so much! Hope more videos from Felix :)

[rishimavaishnavi]

Hey! You have very cool videos! How can I contact you? Do you have mail?