Excel LAMBDA Function: How & When to Use It (Beginner-Friendly)

How to create custom functions in Excel with no programming languages.

The new Excel LAMBDA function allows you to define your own custom functions using Excel's familiar formula language, and that means we no longer need JavaScript or VBA programming knowledge to create our own functions. This is a huge step forward! For those familiar with the concept of LAMBDAs, it is worth noting that the LAMBDA function makes Excel's formula language touring complete. Let's take a look!

LEARN MORE
===========



⏲ TIMESTAMPS
0:00 You don't need JavaScript or VBA to do this anymore
00:39 How to create an Excel LAMBDA
03:37 Practical examples of using LAMBDA
05:47 How to use LAMBDA with other functions
08:48 How to use LAMBDA and LET together
13:08 What you need to know about the function

#LAMBDAFunction #ExcelLambda #ExcelTutorial

[ivanfavennec]

Thank you Mynda for sharing your knowledge so generously. It shows to me so well that, sharing is the only function that also multiplies at the same times we all receive it.

[freakinhilariousful]

As a self taught data analyst, your videos are invaluable. Thank you so much for taking the time to put these videos together, I can't even explain how much you've helped me advance in my career.

[rickyrodriguez]

GREAT examples - looking forward to finding out more about Lambda functions in EXCEL in the future.

[annaczgli]

Thank you so much for the clear explanation - I just found my new favorite Excel function!

[danielbejarano]

Thank you so much for sharing and explaining Excel Functions so well making it easy to digest and see their use in what I do in my profession! Without even practicing them on Excel, you make it easy to follow to fully understand how Functions work. Can't thank you enough!

[gyozakeynsianism]

Finally! I was never scared of VBA, but if I wanted a more sophisticated programming environment, I'd use another application. What makes Excel useful is the mix of on-the-fly data analysis and clear formatting. This just makes the code clearer and Excel far easier to use. I'm excited to get started with lambda functions. Great video as usual!

[hubertg]

You always delivered the goods with easy to understand test cases. Big Thanks!

[johnborg]

Thanks Mynda. I have been experimenting with the LAMBDA. Its like writing VBA code with just a function.

[ivanbork]

You are amazing, not only very well skilled into the technical stuff and making great demo videos, but that you also take the time to help and advice personally that’s extraordinary
I made my first real lambda today, calculating over 7 different columns, wrapped into a sum to get the result in one cell – for me, that’s a success

[chrism]

Thanks Mynda. I need to spend some time with this, it looks pretty powerful.

[darrylmorgan]

Hi Mynda!The LAMBDA Function Looks Really Exciting, Powerful And Pretty Versatile Also...Thank You :)

[tobtobx]

Amazing, great video & clear explanation

[taneraslan]

Real education.thanks.love from Turkey

[naturediaries]

Your videos are very helpful ! Love from India !!!

[mikedbman]

Amazing. Don't know how I missed seeing this 2 years ago.

[nairobi]

Amazing concept... A whole new world opens....

[GeertDelmulle]

I like it so much (like everybody else!) that I’ve started a little library of custom functions of my own.
To bad about some stuff like: no I/O for transferring Defined Names between files, Lambda not very stable, etc.
BTW: thanks for the MEDIAN trick. :-)

[remuslupinhp]

You are so awesome! I'll be indebted to you all my life 🐑da🤩

[henryg]

Very good. You made it much easier to understand. Not sure how much I will use it though TBH. Beyond me how it's got 4 thumbs down!?

[bli]

This is PHENOMENAL! Really loved the tax brackets example. It really solidified the functions for accounting related use cases relevant to my line of work.

Any chance you might now when lambda and let become publicly available ie. for us mere mortals outside of the insider program?

PS: depending on the complexity of an authored lambda function, the approach might result in some painful debugging experiences ;-) . The number of parentheses in the tax bracket example was ‘beautiful’.