Excel LAMBDA() Function - What is it and when to use it?

PREPARE TO BE AMAZED!!!

LAMBDA() function will change how you use & work in Excel. In this video, let me demonstrate the LAMBDA and its practical applications.

We can use LAMBDA() to create any type of functions in Excel. This revolutionizes the way we work with Excel.

Download the sample file from here 🟩
================================

You need Excel 365 to use LAMBDA. Currently, you also need to enable the "insider" program option, but very soon, you don't need that for LAMBDA.

In this video ⏱👇
==============
0:00 - What is LAMBDA in Excel?
1:19 - Creating our first LAMBDA
2:27 - Adding LAMBDA functions to Excel
3:53 - Using LAMBDA in real life with 4 examples
4:13 - toEuro() LAMBDA to convert $ values to Euro
6:21 - Weighted Averages with a LAMBDA
9:12 - Word Count LAMBDA
11:13 - Tomorrow() LAMBDA

🤷‍♂️What else is NEW in Excel? 🎁
===========================

It is not your grandpa's Excel any more. There are many POWERFUL & fun new features in Excel now. Check out these videos to learn what else is new in Excel.

#WhatsnewinExcel #lambda

~
What does a young sheep 🐑 call his dad?
Lamb Da Da.. 😂

[ferozkibria]

Dear Chandoo, Sir, I really liked the way you introduced Lambda in a very simple way and very effective for business situations. Tough made easy. Super Lambda Techniques of your teaching, Sir. Thanks 😊

[chrisjohnson]

Absolutely unreal. Programming and naming our own functions in Excel. It's happening!!! Thank you for providing these explanations for these new features. I'm literally going to start using this as soon as I get back to work on Monday.

On another note, as someone who's spent the majority of their life in education, I just wanted to take a moment to praise your ability to break these concepts down in an incredibly concise and easy to understand manner. We need a million professors of your caliber in the states ASAP, please.

[Hamish_A]

This is, for me anyway, one of the most important innovations in Excel in years! Such a simple way to roll your own functions!

[OzduSoleilDATA]

Thanks for this explanation and demos. You get me reconsidering my feelings about LAMBDA.
I'd been reluctant because they've been compared to UDFs and I've never needed a UDF. After your video, I'm willing to open my mind and look for possibilities.

[AmySwayzee]

I will use this to create severity metrics (dollars/counts). An additional video would be nice to show how to create these functions so they are in every workbook. So they could be added to the workbook when it's created. Thanks!

[chrism]

Thanks Chandoo, this was a great explanation of LAMBDA!

[dannynedwich]

Excellent examples! Starting off very basic makes it much easier to understand.
Thanks Chandoo!

[jagatkrishna]

Doing GREAT 🙏💕 Videos with Awesome Realtime Examples

[jagatkrishna]

Thanks Sir 🙏💕
Mostly used formula n concept in Industry of database n finance, requesting kindly make videos on it.
Because Managers are Asking mostly queries at interview Time.

[ajieapen]

Chandoo, MS has rolled out lambda for all office 365 users. I say this because I am able to use it despite not being an insider...

[khanabdussabur]

Tomorrow function really awesome chandoo. Thanks a lot.

[smanzoli]

It is very easy to create new functions to use in the cells using VBA Functions (not subs).

Lambda let us do SIMPLE functions, without VBA. Nice. But VBA allows more complex functions since it's a full program, and Lambda is just one formula.

[kuldar.]

Best lambda's explanation, Sir! Do you also have a video about combination of let and lambda? Or just let?

[generalknowledge]

Great sir, I completely understood the LAMBDA now,

[krizvipk]

Just like to know that lambda function uses only two variable or we can use it for more than two variables. Isn't formatting can be used in lambda i.e. converting to date format...
Excellent

[rohindadina]

Looks exactly like the Python Lambda function. Thanks for the video

[primeknowledge]

Amazed as always 😊👍 thanks a million sir 👍

[gregbernard]

This is great / easy to understand. Unfortunately it is only available in GM On-Line for our company (which for PC does not have the name manager). Great video though and I have been playing around with it.

[canirmalchoudhary]

Let's wait for this exciting function I think it can be replacement of LET.

[Bold_Experience]

Thanks Chandoo, can't lamda function saved and work on every other workbook open?
I mean once the function is been created, if it could be subsiquently use in other workbooks?