- xlwings Newsletter
- Posts
- xlwings Newsletter #25
xlwings Newsletter #25
The New Excel Lambda Functions
Blog Post
What Makes Excel's Lambda Functions so Awesome (and what doesn't)?
In December 2020, Microsoft
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 blog post, 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
in a cell and if Excel suggests the function name, you are all set.
The blog post touches on the following points:
Why Do We Need Lambda Functions?
Create your First Lambda Function!
How Do Lambda Functions Work?
Why are Lambda Functions so Awesome
Limitations with Lambda Functions
Managing Lambda Functions Across Workbooks
Keeping Track of Your Lambda Functions
Conclusion
Alternatively, you can also watch the short video with the blog post's highlights: