Excel LAMBDA - HOW & WHEN you Should use it

Рет қаралды 426,733

Күн бұрын

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Introducing Excel's NEW function: Excel LAMBDA Function.
Excel Lambda allows you to create your own Microsoft Excel custom function without any coding.
⬇️ Download the workbook here: pages.xelplus.com/lambda-file
In this tutorial I explain in simple words and practical examples of how you can use the Excel lambda function. If you find yourself doing repeated calculations but couldn't find a function that fits your specific needs, THIS will be for you!
I'll take you through the basics of Excel Lambda and how you can apply it to your own Excel files. You will also see an example of a recursive lambda where we loop through cells to do multiple replacements.
🔍 What You'll Learn:
- An introduction to the Lambda function in Excel.
- Creating dynamic, reusable formulas with Lambda.
- Advanced techniques, including sorting data.
👩‍💼 Perfect for:
- Excel users curious about the latest features in Excel.
- Professionals looking to streamline their data processing.
- Anyone excited about creating custom functions in Excel.
📌 Key Highlights:
- Understand the basics of Lambda functions.
- Explore practical examples of Lambdas in action.
- Prepare for advanced recursive Lambda functions.
In this video I'll show you how you can program your own Excel RECURSIVE LAMDA 👉 • Excel RECURSIVE Lambda...
This allows you to create loops in Excel that keeps repeating - with a formula!
Important: Excel Lambda function is available only in Excel for Microsoft 365.
00:00 Excel Lambda Function
00:59 Recursive Excel Lambda Example
02:55 Practical Example of Excel Lambda
04:54 Excel Lambda Explained in Simple Terms
05:20 How to Create an Excel Lambda
09:05 Excel Lambda in Name Manager
10:27 Practical Example of Excel Lambda (with Dynamic Array Functions)
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel #lambda

Пікірлер: 704

@LeilaGharani 5 ай бұрын

Grab the file I used in the video from here 👉 pages.xelplus.com/lambda-file

@statanaliz 3 жыл бұрын

Спасибо за наглядное объяснение. Ждем обновление Excel. )

@Raul-qw9ht 3 жыл бұрын

Programming basics with the results of advance programming ... really useful for multidisciplinary professionals. Thanks so much for your insight.

@MichaelBrown-lw9kz 3 жыл бұрын

UNBELIEVABLE. I am definitely looking forward to my Excel update. I am going to watch this video over and over again, and I can't wait to start practicing using this Lambda function.

@3danim8r1 3 жыл бұрын

The way Leila explain Lambda function is a simply awesome. Thanks...

@kmannavarapu 3 жыл бұрын

I have been watching this lambda tutorials for a week now. Hands down no one has explained better than you. Thank you!

@LeilaGharani 3 жыл бұрын

Wow, thanks!

@GpD79 3 жыл бұрын

Is it weird that I got excited when she was like, "...it changed everything... you need to see this" at 0:38? HAHA, only Leila makes me excited for excel!!! Thank you for your continued dedication to educate us!

@jaweeddanish9858 3 жыл бұрын

I was fun of Excel, now i love Excel because of Leila. You are a great teacher thanks a lot. Jaweed from Germany

@AhmedIbrahim-vl6bv 3 жыл бұрын

Leila is much more than an excel teacher, a true role model in terms of passion and the constant smile! I have attended 7 courses of yours and it did change my life. May your life be filled with joy!

@chinmaya.6934 3 жыл бұрын

If Leila teaches Quantum Physics and Thermodynamics I bet I will understand even those topics. Wonderfully Explained. Amazing content and lucid as usual, Thanks! Your follower from India

@LeilaGharani 3 жыл бұрын

Wow, thank you! I'm glad you liked it.

@hichamhadj9640 3 жыл бұрын

There are some sick people who disliked the video though

@XAE_A_Xii 3 жыл бұрын

@@hichamhadj9640 they are jealous and they are crap at excel

@euniceesinam2573 3 жыл бұрын

A pity she isn't teaching those! Leila's the best teacher!

@youtube_user9110 3 жыл бұрын

Btw this functionality is great for thermodynamics

@enjeroz 3 жыл бұрын

Great content! I'm since 2015 writing an AI and began from noob skills basic. Of course I came across some problems. But with your vids I managed to launch the first verion of thenfull AI program last month which still runs about 80% in Excel. (Yes it can and works so good) Thank you! Lambda is going to help me with the upgrade.

@at-excel 3 жыл бұрын

Dear Leila, you did a really great presentation of this new mega-function. Thanks a lot! Andreas

@LeilaGharani 3 жыл бұрын

Many thanks! I'm glad it was helpful.

@guido-hillmann 3 жыл бұрын

Wird Zeit, dass Du deinen Rechner mit der Insider-Version wiederbekommst!😄

@JimFikes 3 жыл бұрын

You always explain things so clearly. That's why I have all my students watch your videos. Thanks, Leila!

@LeilaGharani 3 жыл бұрын

Thank you, Jim!

@elactecnology 2 жыл бұрын

And my co-workers as well are big funs of Leila. Leila is a game changer.

@elactecnology 2 жыл бұрын

She is like power query. She really makes an impact that matters. Thank you Leila

@jscomputergenius3834 Жыл бұрын

@@elactecnology 🤣🤣🤣🤣🤣🤣

@SpiritualMotto 3 жыл бұрын

This is second time that I am watching the LAMBDA function explaination but first time i saw in a different channel, you have explained the root clearly and made to create many functions in my own, thanks a lot, the best part of the video is not only i learnt the LAMBDA, however i learnt the usage of SORT, UNIQUE functions too.

@TylerStanczak 3 жыл бұрын

I could definitely brush up on Lambda. Thanks Leila :)

@frayue 3 жыл бұрын

#Mindblown! Excel is getting powerful than ever! Love it! Thanks, Leila!

@danwhite3708 3 жыл бұрын

What an awesome presenter. I just love how she teaches.

@amardeepsingh5252 3 жыл бұрын

I have seen 4 different videos on lambda and this one actually explains the usage from scratch. And that's what you need for a new function. Great job Leila 👍

@LeilaGharani 3 жыл бұрын

Awesome, thank you!

@philipmumba3788 Жыл бұрын

You are actually saving people's jobs, without you many of us could be fired for lack of skill and expertise. Thanks

@urbaneplanner 2 жыл бұрын

good video as usual - for anyone watching this now, worth mentioning that Leila has new videos about the Advanced Formula Environment, which improves on the name editor that one had to use previously - but this video is still a good intro to lambdas

@syedfirdose7215 3 жыл бұрын

I found no better channel than this for excel videos

@Remars808 3 жыл бұрын

its Christmas already, three videos from the Queen.very intricate... but it usually brings me back to nostalgia, revenge of the nerds"lambda lambda lambda fraternity"

@Sam-xm9sr 2 жыл бұрын

Leila you are such an asset to all of the Excel world you teach us with such patience...

@nonoobott8602 3 жыл бұрын

Very explicit tutorial on this incredible function that allows for more possibilities within the grid. Thanks Leila for sharing

@LeilaGharani 3 жыл бұрын

You're very welcome!

@chaitanyalodha3948 3 жыл бұрын

This is game changing!! Would love to see the next video!!

@carlmazziotti221 Жыл бұрын

LAMBDA is going to be my new best friend. All of my long complex formulas will be simplified and with naming I'll be able to understand all that I have done much better. Excel is getting better and better!

@paulchiporombe5413 3 жыл бұрын

Amazing formula. Finally here. Thanks Leila.

@joevano 3 жыл бұрын

This is a game changer... coming from a programming background where we have lambda these come in handy all the time.

@NL-tq1yr 3 жыл бұрын

Pretty sure this was possible with VBA

@joevano 3 жыл бұрын

@@NL-tq1yr of course it was, but now you don’t have to be a programmer to get custom functions. This is a game changer for normal users.

@elfuego970 3 жыл бұрын

Both awesome: function and explanation. Can't wait for part 2. Thanks for all your great job Leila!

@LeilaGharani 3 жыл бұрын

Thank you! 😃

@ExcelinaMinute 3 жыл бұрын

LEILA IS THE BEST TEACHER AND MENTOR EVER! I have learned so much with Leilafor the last 7 years, Leila inspired me to make a difference in other people's lives. My target is to help at least 100,000 students. I

@raymons8600 3 жыл бұрын

Great idea for a channel , good luck

@gerardbouchard1153 3 жыл бұрын

Very concise videos, I can see how Leila Inspire you

@lilig9231 3 жыл бұрын

Terrific 3 minutes Excel Tutorial, please continue,

@GerardoGarcia-sw9jn 3 жыл бұрын

Love your Approach and explanations

@HECHIZADAS 3 жыл бұрын

Great Content, really informative and easy to follow

@rwfrench66GenX 3 жыл бұрын

In the 80's I had a Commodore 64 Plus 4 where the Plus 4 were 4 function keys that you could program to do whatever you wanted, they were called hot keys, and that's what this reminds me of in a way. Bringing the looping function over from VBA can be useful in a way. It's certainly faster than Find & Replace if making the text that perfect is that important. I've always named my array formulas doing V and H lookups so you can use those anywhere in the workbook too. I would imagine there are very specific instances where combining multiple lambdas to clean up the data would come in handy but right now this looks like more of the same from Microsoft, introduce a new function in the latest version so you have to get that version and in the end it really only helps save time in very specific instances. I mean, people had VBA code to fix data for years but now we need Lambda. You did a great job of explaining it and maybe I'll get more out of the second video. I'll definitely check out the feature in my work but right now I'm not sure I see too many advantages over what I already do. Thanks for the video and Happy Holidays to you and your family!

@justsurfin5013 2 жыл бұрын

Went ahead and signed up for Microsoft 365 BETA just for this. Good course

@VishwasKadrolli 3 жыл бұрын

This is awesome and helps in many ways. Thank you Leila. Always look forward for your next video.

@chrissears9912 2 жыл бұрын

Thanks so much, fantastic video. I made my first lambda function to round a value to a specified # sig-figs, took 5 minutes and makes my sheets so much more readable!

@user-jc6te1vm8v 2 жыл бұрын

the aura of mystery surrounding lambda finally disappears with such an ease... thank you so much leila.. could not have been possible without you teaching ❤️

@LeilaGharani 2 жыл бұрын

You're welcome 😊

@kikin62 Жыл бұрын

My favorite teacher in Excel ¡¡ THANKS

@SouravGhosh1810 3 жыл бұрын

I can't stop thinking about combining query and lambda, that will be very interesting and I wish you could do a presentation. Love your videos.

@businessintelligencedigita8117 3 жыл бұрын

Check my recursive example Using Lambda & Recursive Lambda to create user defined custom function Excel kzfaq.info/get/bejne/gLloZpRj3rLKhHk.html *Examples Covered* 1 Square of a number 2 Sum of squares from 1 to N 3 Sum of digits Discussion Link bi-analytics.org/blogs/entry/54-use-of-lambda-recursive-lambda-to-create-user-defined-custom-function-excel/ #Lambda #exceltips #exceltraining

@trilmobile3716 3 жыл бұрын

I finally took the time to look at and try this. This is quite awesome. Thanks for the easy-to-understand explanation!

@cshahed 3 жыл бұрын

Wow. Super excited for it. Can't wait to use it

@prasadp17 2 жыл бұрын

Loving excel more because of your videos. Lamba makes excel much more powerful. Thanks for sharing

@furqanahmad8281 2 жыл бұрын

Amazing. YOu are the Wonder Woman of Ms Excel..

@solomonmokua4643 3 жыл бұрын

Wow, finally a neat way to write custom formulas and give them cool names😃

@accnotech3863 3 жыл бұрын

WAS EXPECTING YOUR VIDEO ON LAMBDA

@reng7777 3 жыл бұрын

Hi Leila!! the Ms Excel team is practically bringing up to excel what what used to do in the VBA SCRIPT ,but this time it has been adapted through the excel formula languague, i would say that this LAMBDA function will bring a more practical solutions to us!! Nice video as always regards from Uruguay!!!

@BrianSantosTRP 3 жыл бұрын

Great video intro to the =lambda() functionality! Can't wait for the recursive lambda features.

@daseaton 3 жыл бұрын

This is by far the most robust explanation of lambda I have seen, and I've seen several. Am I surprised? No. Superlative job as always Leila!

@LeilaGharani 3 жыл бұрын

Thank you!

@patrickschardt7724 3 жыл бұрын

Oh wow. This is a huge addition to Excel. This is wonderful. Great tutorial

@LeilaGharani 3 жыл бұрын

It really is Patrick!

@tommypain 3 жыл бұрын

Awesomeness! (And very well explained.). Thank you.

@MyLilTony93 3 жыл бұрын

I like the new intro/outro animations and music! Also, the lambda function

@LeilaGharani 3 жыл бұрын

😁

@lesterpotts6142 3 жыл бұрын

Amazing, thank you for making it so easy to understand. Keep up the good work.

@michaellayne9832 3 жыл бұрын

As usual, very informative. I have to digest this a bit and try it out before I will know how much I'll be using this, but I have a feeling it may be often! Thank you, again, for your insight and explanations!

@robertovelicaz7719 3 жыл бұрын

Brilliant, brilliant, brilliant....Thanks so much Leila! Can’t wait for the next video! The mind boggles to think of all the things you will be able to do with this new function 😃

@LeilaGharani 3 жыл бұрын

It really is a game changer, Roberto!

@robertovelicaz7719 3 жыл бұрын

@@LeilaGharani looking forward to seeing the uses you find for it! 😃👍🏻

@konradbryczkowski242 3 жыл бұрын

Thank you very much! I have recommended your channel to no end, it never fails! Keep at it!

@LeilaGharani 3 жыл бұрын

Thank you for your recommendation!

@SeanGHOB 3 жыл бұрын

Classic bait-and-switch! "Recursive Lambdas are so great! Watch this video to find out why! Actually, I'll do those in next week's video" Well done. I'm hooked.

@edge5817 3 жыл бұрын

Can't wait to have it...Thank you Leila

@ExcelExciting 3 жыл бұрын

Wonderful Explanation as usual!! I'm still waiting for my update on the insider to get my hands-on LAMBDA function. Hope to see it soon, my mac soon.

@LeilaGharani 3 жыл бұрын

Thanks Faraz! Hope you'll get it soon.

@OzduSoleilDATA 3 жыл бұрын

This is intense. I wanna see this recursion jazz next week. 🤔

@violentapolenta 3 жыл бұрын

This is aaaaaawesoooooooomeeee. I share Leila's videos to my coworkers ALL THE TIME. I love this channel, thanks for everything you do ♥️

@LeilaGharani 3 жыл бұрын

Awesome! Thank you for your support!

@iulianionescu 3 жыл бұрын

This is pretty darn awesome, Leila!!! Looking forward to using it! Thank you

@LeilaGharani 3 жыл бұрын

Glad you like it, Iulian!

@amyl9864 3 жыл бұрын

Now I need to find reasons to use this! Great explanation as always on your topics!

@danielk.2663 3 жыл бұрын

This is great. There will be libraries of just pick up and go lambda functions for recurring problems.

@mattschoular8844 3 жыл бұрын

Thanks Leila. LAMBDA is a game changer for sure. Looking forward to the recursion version next week..

@LeilaGharani 3 жыл бұрын

Yes. It is! The recursive part is amazing. I still have to do some tests regarding performance of this on bigger data sets.

@fida80 3 жыл бұрын

It seems it's not a job but a passion for you , you enjoy it and it shows

@cdyard1 3 жыл бұрын

Someone asked about the LAMBDA function in a Facebook group on Excel. I was going to ask you about this function and lo and behold, a video about the Lambda function! Great video, BTW, and great explanations. I'll have to see it two or three times before I can use it but it's fantastic!

@LeilaGharani 3 жыл бұрын

Glad you like it, Claire!

@vijayarjunwadkar 3 жыл бұрын

This is simply WOW! Now for me LAMBDA = (L)eila from (A)ustria is (M)aster of (B)est (D)ata (A)nalysis! Thank you for such a simple explanation, where you learn it right first time! Waiting for Thursday! 😊👍👏

@LeilaGharani 3 жыл бұрын

ahhh that's really nice! Glad you found the video useful 😀

@udusegbe 3 жыл бұрын

Great function from team Excel. Imagine combining LET & LAMBDA! Thanks for simplifying everything about Lambda, Leila. Now you got us all excited to tune for the recursive use case :-)

@christopheraldrich665 2 жыл бұрын

I really like your channel!!! I’ll keep watching and supporting w/super thanks!

@PhoenixRealOne 3 жыл бұрын

Before I watched the video: Why would anyone subscribe to an channel about MS Office? You find what you need and don't care until you need something else... half way through the video: *new Subscriber* GREAT video!!! Can't wait to check out more :)

@LeilaGharani 3 жыл бұрын

😁 Thank you for subscribing and welcome!

@Anisabell2 3 жыл бұрын

Wow, this looks great, and it seems very useful. Thanks for the insight and I'll be waiting for the next video 🤩

@enderkazakli9557 3 жыл бұрын

Having inspired by this great teacher, I spent a couple hours in the internet and struggled with this "recursive lambda thing". Finally, I was able to make a custom function for dealing with text substitutions requiring looping. Cheers. Define a custom function XUB (eXtended sUBstitute) in the Name Manager as shown: ---------------------------------------------------------------------------------------- =LAMBDA(Text2Process, FindText, ReplaceText, IF(FindText="", Text2Process, XUB(SUBSTITUTE(Text2Process, FindText, ReplaceText), INDIRECT("R" & ROW(FindText) +1 & "C"&COLUMN(FindText), FALSE), INDIRECT("R" & ROW(ReplaceText) +1 & "C"&COLUMN(ReplaceText), FALSE) ) ) )

@jimihope1113 2 жыл бұрын

Thanks Sister for your great help!

@XLGuy 3 жыл бұрын

Now that's some function!!! Thank you so much Leila for explaining this, didn't watch anyone else's explanation and waited for yours, and I'm really glad for that. Looking forward to the next video. 😍

@LeilaGharani 3 жыл бұрын

Thank you for waiting! I'm glad it was worth it 😀

@nicolaesposito962 4 ай бұрын

amazing explanation! finally!

@prislander55 3 жыл бұрын

Amazing!! Thank you so much for sharing this!

@anubhav19888 11 ай бұрын

Very well explained. Tks. It took me few attempts to do it.

@CharlyCGR Жыл бұрын

Congratulations Leila!! You are great!!

@chris_thornborrow 3 жыл бұрын

Leila, its midnight, i dont have the latest excel but you are such an amazing teacher I watched it all.

@LeilaGharani 3 жыл бұрын

Thanks for watching, Chris!

@waynethurman2144 3 жыл бұрын

Thank you Leila!

@JWentu Жыл бұрын

woah... there is so much to learn in just this video!

@roelpanis8711 3 жыл бұрын

Thanks, very good explanation!

@iliomil 3 жыл бұрын

Just one word to describe the Lambda function and Leila's explanations: Wow!

@LeilaGharani 3 жыл бұрын

Thank you 😊

@iliomil 3 жыл бұрын

@@LeilaGharani Prego, Leila! Ogni tuo video è sempre chiaro, anche nel presentare concetti articolati. Tutto il tuo materiale è fruibile da chiunque in modo semplice e fluido. Bravo Zulu Leila! Ilio :-)

@controlsgirl Жыл бұрын

Great walkthrough!

@mangaikumar8908 2 жыл бұрын

Great to listen you really make it crystal clear

@silverlicious2086 3 жыл бұрын

Very good instructions Leila. Well done.

@philippedemecheleer2381 2 жыл бұрын

Very interesting feature! I'm going to test it right away 😊

@jasper_ferrer 3 жыл бұрын

you explained this very well. Thanks

@tuyoexcelypowerbi 3 жыл бұрын

Powerful and very well explained!!

@x9rtu3os1t8 Жыл бұрын

Leila forever awesome! Thank you.

@johnborg6005 3 жыл бұрын

Thanks Leila. This is a fun function

@raitup00 3 жыл бұрын

Awesome explanation!

@Gustavo2811 3 жыл бұрын

Leila! This is amazing! I never thought to do something like this on Excel. Thank you!

@LeilaGharani 3 жыл бұрын

You're very welcome, Gustavo!

@rajsahu1029 3 жыл бұрын

Wonderful. Very interesting. waiting the next video Thanks.

@luda_c 3 жыл бұрын

A superb tutorial as usual. Thank you Leila.

@LeilaGharani 3 жыл бұрын

Thank you! 😊

@somanet5322 3 жыл бұрын

Leila, You Rock !!

@budiantotanudirdjo2627 3 жыл бұрын

I knew such function when I develop power query linked calculation. Now it is available as formula. It may helps a lot for excel bound users.

@christopherikechukwueyidah5928 3 жыл бұрын

Thanks for this. Really appreciated. 👍🏿👍🏿👍🏿

@LeilaGharani 3 жыл бұрын

My pleasure, Christopher!

@Abrogator91 2 жыл бұрын

I love lambda! Excel is such a wonderful tool, and this just makes it so much better! Unfortunately, most of my spreadsheet usage is in Google sheets. I hope Google adds this as well