Excel LAMBDA Function

Brand new in Excel for 2021 - LAMBDA is the most powerful function ever. LAMBDA lets you create your own functions and use them throughout a spreadsheet.

Contents 0:00
Introducing LAMBDA 0:13
Name a Function 1:28
Two Input Variables 2:38
Inputs Using Ranges 3:37
Data Types 4:15
Recursion 5:57
Availability 7:51
Conclusion 8:04

#seletraining #excel #lambda

[andrewpeterst]

We're still using MS Office 2013 at my job. Can't wait to use this in 2037!

[OriginalPiMan]

I don't know why YouTube recommended me this, but I'm glad it did.

[shubhankurkumar]

At this point, excel is a programming language in its own right.

[gopalakrishnanmanikandan]

I'm waking up in the morning, and seeing this video... I can't really believe myself. Many times I have got stuck when I needed to automate some of my works in excel, due to not finding a formula. This is now going to help me, i hope so. Thank you so much for bringing this Lambda function.

[anubis]

I have been begging for this for years. I'm so happy they put it in. I hate having to create custom functions in VBA just for simple actions.

[JimmyHandmix]

Will have to rewatch this in 5-6 years when I upgrade to the 2021 Version

[matekochkoch]

Finally something new that is not annoying. Now there is a valid argument for migrating to the latest office version. This will render a lot of macros obsolete - good for security.

[financialchimes]

This went from very easy functions to mind blown very quickly.

[kauegraumann]

That's a nice alternative to using VBA, when your client complains that he/she can't activate sheet content, or don't know how to.

[micahturpin]

Holy guacamole, I've been waiting for something like this for AGES. I love Excel. :)

[simba]

God bless my successor when I transition my excel sheets with all these lambda defined functions !

[maxwellhouser]

This severely reduces the amount of vba needed for certain sheets, great update and great video

[smileyspoon]

Oh my gosh. This is so amazing. I have been waiting for something like this forever. Thank you for making my Saturday. I will be even more efficient LOL.

[sohailahmed]

I am from a non programming background, but I enjoy VBA. Why do people hate it? It has made querying back end so easy !!!

[PapaMike]

I am shocked that it took them that long to introduce the possibility of creating your own functions without having to use that massive PITA that is VBA

[sumanshrestha]

One formula i had been praying for years...🔥🔥

[spencershields]

The recursion bit is rad, I've wanted something like that in excel for a while.

[TausifB]

While the content is concise and helpful, the presentation is incredible with impressive voice:)

[tylerwiebe]

I'm a heavy user of Excel and have been working in finance for years, and while this function sounds cool, I can't for the life of me think of a situation where this would've come in handy. If you have any real life examples, I'd really be interested in hearing how you use it.

[stevenkirby]

I must need new glasses. I read the title as Excel LAMBADA Function and my mind went in a totally different direction.