Grab the file I used in the video from here 👉 pages.xelplus.com/lambda-file
@bobgreenfield91582 ай бұрын
Leila, my goal is to have Gematria functions in Excel. Gematria is converting words to numbers. There are at least 36 different Ciphers. I figured that the Lambda function would be the way to go. But I have three problems. 1. Can the lambda function be used outside of a given workbook? 2. Can lambda functions be used to define additional lambda functions? I tried it and it didn't work. This is not good on complex functions. 3. Additionally, my mouse does not work on my laptop, so I use the keypad device. I have been unable to copy an equation in my worksheet and paste it into my Lambda definition line. I would have to carefully enter it again. 4. The definition screen for Lambda functions is tiny, it is difficult to work with big equations in that box, or being able to navigate within it. Suggestions?
@chinmaya.69343 жыл бұрын
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
@LeilaGharani3 жыл бұрын
Wow, thank you! I'm glad you liked it.
@hichamhadj96403 жыл бұрын
There are some sick people who disliked the video though
@XAE_A_Xii3 жыл бұрын
@@hichamhadj9640 they are jealous and they are crap at excel
@euniceesinam25733 жыл бұрын
A pity she isn't teaching those! Leila's the best teacher!
@youtube_user91103 жыл бұрын
Btw this functionality is great for thermodynamics
@ExcelinaMinute3 жыл бұрын
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
@raymons86003 жыл бұрын
Great idea for a channel , good luck
@gerardbouchard11533 жыл бұрын
Very concise videos, I can see how Leila Inspire you
Great Content, really informative and easy to follow
@joevano3 жыл бұрын
This is a game changer... coming from a programming background where we have lambda these come in handy all the time.
@NL-tq1yr3 жыл бұрын
Pretty sure this was possible with VBA
@joevano3 жыл бұрын
@@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.
@kmannavarapu3 жыл бұрын
I have been watching this lambda tutorials for a week now. Hands down no one has explained better than you. Thank you!
@LeilaGharani3 жыл бұрын
Wow, thanks!
@Raul-qw9ht3 жыл бұрын
Programming basics with the results of advance programming ... really useful for multidisciplinary professionals. Thanks so much for your insight.
@JimFikes3 жыл бұрын
You always explain things so clearly. That's why I have all my students watch your videos. Thanks, Leila!
@LeilaGharani3 жыл бұрын
Thank you, Jim!
@elactecnology2 жыл бұрын
And my co-workers as well are big funs of Leila. Leila is a game changer.
@elactecnology2 жыл бұрын
She is like power query. She really makes an impact that matters. Thank you Leila
@jscomputergenius38342 жыл бұрын
@@elactecnology 🤣🤣🤣🤣🤣🤣
@jaweeddanish98583 жыл бұрын
I was fun of Excel, now i love Excel because of Leila. You are a great teacher thanks a lot. Jaweed from Germany
@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!
@GpD793 жыл бұрын
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!
@philipmumba37882 жыл бұрын
You are actually saving people's jobs, without you many of us could be fired for lack of skill and expertise. Thanks
@MichaelBrown-lw9kz3 жыл бұрын
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.
@AhmedIbrahim-vl6bv3 жыл бұрын
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!
@alterchannel2501Ай бұрын
Perfect as always! By the way I love when your eyes move up-right when speaking😊
@user-jc6te1vm8v2 жыл бұрын
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 ❤️
@LeilaGharani2 жыл бұрын
You're welcome 😊
@urbaneplanner2 жыл бұрын
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
@amardeepsingh52523 жыл бұрын
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 👍
@LeilaGharani3 жыл бұрын
Awesome, thank you!
@firasiraqi93823 жыл бұрын
Am very sure really thats LAMBDA will be a very important start to move the excel to New Area thats i was dream with it before . Excel is genius & Crazy world but its guided to VBA , and i hope thats Lambda will be the start to blowing Creativity with our work in easily way . Thank you Liela , for your amazing explanation and video 👍🏻👍🏻👍🏻👍🏻👍🏻
@LeilaGharani3 жыл бұрын
I agree. I think we're seeing the start of a journey :)
@thedavidseatonshow3 жыл бұрын
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!
@LeilaGharani3 жыл бұрын
Thank you!
@Jeroentia3 жыл бұрын
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.
@iliomil3 жыл бұрын
Just one word to describe the Lambda function and Leila's explanations: Wow!
@LeilaGharani3 жыл бұрын
Thank you 😊
@iliomil3 жыл бұрын
@@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 :-)
@remars-xcel3 жыл бұрын
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"
@justsurfin50133 жыл бұрын
Went ahead and signed up for Microsoft 365 BETA just for this. Good course
@cdyard13 жыл бұрын
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!
@LeilaGharani3 жыл бұрын
Glad you like it, Claire!
@surenderoati3 жыл бұрын
I am a UI developer but get more interested in excel just because of your great explaination. Thanks a lot 😊☺️
@LeilaGharani3 жыл бұрын
You are most welcome :)
@SpiritualMotto3 жыл бұрын
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.
@nonoobott86023 жыл бұрын
Very explicit tutorial on this incredible function that allows for more possibilities within the grid. Thanks Leila for sharing
@LeilaGharani3 жыл бұрын
You're very welcome!
@TylerStanczak3 жыл бұрын
I could definitely brush up on Lambda. Thanks Leila :)
@vijayarjunwadkar3 жыл бұрын
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! 😊👍👏
@LeilaGharani3 жыл бұрын
ahhh that's really nice! Glad you found the video useful 😀
@vivekphadke16 Жыл бұрын
Thanks, Leila, I also made a help file with my comments so that it becomes easy to recollect if I visit LAMBDA later. Thank you for making it clear and understandable.
@LeilaGharani Жыл бұрын
Glad it was helpful!
@SeanGHOB3 жыл бұрын
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.
@rwfrench66GenX3 жыл бұрын
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!
@chris_thornborrow3 жыл бұрын
Leila, its midnight, i dont have the latest excel but you are such an amazing teacher I watched it all.
@LeilaGharani3 жыл бұрын
Thanks for watching, Chris!
@danielk.26633 жыл бұрын
This is great. There will be libraries of just pick up and go lambda functions for recurring problems.
@SouravGhosh18103 жыл бұрын
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.
@businessintelligencedigita81173 жыл бұрын
Check my recursive example Using Lambda & Recursive Lambda to create user defined custom function Excel kzbin.info/www/bejne/gISbZGRorrGZiqc *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
@YvesAustin Жыл бұрын
The lambda function is really interesting and I get a few inquiries about it. However, the biggest issue I find is the fact that at best it is workbook specific, meaning if you have to recreate it for next months’ data, you are starting from scratch again (copy/paste lambda). Public functions in vba posted in a xlam addin still have the upper hand 😊 #govba
@violentapolenta3 жыл бұрын
This is aaaaaawesoooooooomeeee. I share Leila's videos to my coworkers ALL THE TIME. I love this channel, thanks for everything you do ♥️
@LeilaGharani3 жыл бұрын
Awesome! Thank you for your support!
@prasadp172 жыл бұрын
Loving excel more because of your videos. Lamba makes excel much more powerful. Thanks for sharing
@denconstutube3 жыл бұрын
I found the topic to be complicated to understand, but after I listened to it twice I did understand the steps to make it work. Excellent presentation. I will do some testing to see how I can use this in my excel projects. Your enthusiasm makes the subject exciting. Thank you.
@LeilaGharani3 жыл бұрын
Hope it will come in handy for you.
@pratipsengupta79533 жыл бұрын
Ma'am, only a Persian Mathematician could do this. I say that with deep respect for centuries of brilliant Persian Mathematicians.
@at-excel3 жыл бұрын
Dear Leila, you did a really great presentation of this new mega-function. Thanks a lot! Andreas
@LeilaGharani3 жыл бұрын
Many thanks! I'm glad it was helpful.
@guido-hillmann3 жыл бұрын
Wird Zeit, dass Du deinen Rechner mit der Insider-Version wiederbekommst!😄
@enderkazakli95573 жыл бұрын
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) ) ) )
@fida803 жыл бұрын
It seems it's not a job but a passion for you , you enjoy it and it shows
@syedfirdose72153 жыл бұрын
I found no better channel than this for excel videos
@furqanahmad82812 жыл бұрын
Amazing. YOu are the Wonder Woman of Ms Excel..
@sachinrv13 жыл бұрын
Fantastic un-coding of LAMBDA. Looking forward to your next video.This function together with Office 365 functions, has the power of replacing age old pivot table as well. No drag and drop. Just create LAMBDA function and that's it. Cheers :)
@LeilaGharani3 жыл бұрын
That's a great idea Sachin!
@budiantotanudirdjo26273 жыл бұрын
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.
@anubhav19888 Жыл бұрын
Very well explained. Tks. It took me few attempts to do it.
@Sam-xm9sr2 жыл бұрын
Leila you are such an asset to all of the Excel world you teach us with such patience...
@patrickschardt77243 жыл бұрын
Oh wow. This is a huge addition to Excel. This is wonderful. Great tutorial
@LeilaGharani3 жыл бұрын
It really is Patrick!
@AtabekZingi3 жыл бұрын
I hoped I could create my own functions in Excel for years as objects or classes, my dream came finally true :-) thanks sister leila :-)
@LeilaGharani3 жыл бұрын
You are welcome 😊
@nhanharelli33 жыл бұрын
Learning Excel and feeling tingles. Great Vídeo 10/10.
@LeilaGharani3 жыл бұрын
Awesome! Thank you!
@BMR863 жыл бұрын
I swear to you for the longest time since I was in college 10 years ago, I always forgot what key to press to fix a cell... and its F4!!! thank you for that!!
@LeilaGharani3 жыл бұрын
I’m glad you found that!
@excelworx87123 жыл бұрын
Hi Leila, this is the best tutorial of LAMBDA I have seen. I cannot try it out as my laptop is not running on MSO 365. I already have several formulas that I want to try out on LAMBDA. Waiting for the wifey to come home to grab her laptop which has MSO 365, haha
@LeilaGharani3 жыл бұрын
Hi. Thank you. This is currently only on beta in 365. And apparently only 50% of the users got it in the first round. You might have to wait a bit longer. Fingers crossed that all 365 users get it soon.
@excelworx87123 жыл бұрын
@@LeilaGharani yes, saw that. So, will have to wait
@ExcelExciting3 жыл бұрын
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.
@LeilaGharani3 жыл бұрын
Thanks Faraz! Hope you'll get it soon.
@kikin62 Жыл бұрын
My favorite teacher in Excel ¡¡ THANKS
@waris88073 жыл бұрын
The beauty is face or the brain? Now we can create a Lamda machine to find out. Thank you. Great as always.
@mattschoular88443 жыл бұрын
Thanks Leila. LAMBDA is a game changer for sure. Looking forward to the recursion version next week..
@LeilaGharani3 жыл бұрын
Yes. It is! The recursive part is amazing. I still have to do some tests regarding performance of this on bigger data sets.
@robertovelicaz77193 жыл бұрын
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 😃
@LeilaGharani3 жыл бұрын
It really is a game changer, Roberto!
@robertovelicaz77193 жыл бұрын
@@LeilaGharani looking forward to seeing the uses you find for it! 😃👍🏻
@jesuspalalia51643 жыл бұрын
This is more useful than the Let function. Tbh I never used the Let function. I find this Lambda function more powerful though and can see situations where I can apply this in my job. It seems like this function will supercede the Let function.
@reng77773 жыл бұрын
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!!!
@kashmuneer3 жыл бұрын
That's amazing...and the way you explained it makes is more amazing.... I don't understand who are the people who disliked the video 🤔
@LeilaGharani3 жыл бұрын
Thank you! I'm glad you liked it.
@chelebarry3 жыл бұрын
Wow that was great explanation I have not been using excel that much this days I got interested and good thing I did this seems like a very useful tool to know... I really enjoy the way you explain things it is very clear...
@LeilaGharani3 жыл бұрын
Great to hear!
@MyLilTony933 жыл бұрын
I like the new intro/outro animations and music! Also, the lambda function
@LeilaGharani3 жыл бұрын
😁
@haashini100319853 жыл бұрын
@Leila The best example of all-ever videos uploaded in KZbin for Lambda. Asusual, Lots of Thanks to you. Awaiting for your next course ...any clue please.
@LeilaGharani3 жыл бұрын
That is so nice! Thank you. As for courses - it will take some time. I might release a few shorter courses but I am planning a comprehensive Power BI course sometime next year.
@haashini100319853 жыл бұрын
@@LeilaGharani Thank you for the reply. Inspired by you a lot for Excel. God Bless.
@gr8wh8orca534 ай бұрын
Excellent training "Leilamda" 😂🤯 Excel and Data for eternity, nothing is out of reach for Excel...keeps on keeping on !!!
@philippedemecheleer23812 жыл бұрын
Very interesting feature! I'm going to test it right away 😊
@chaitanyalodha39483 жыл бұрын
This is game changing!! Would love to see the next video!!
@PhoenixRealOne3 жыл бұрын
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 :)
@LeilaGharani3 жыл бұрын
😁 Thank you for subscribing and welcome!
@mikeparker38653 жыл бұрын
very exciting. easier than writing vba functions.
@chrissears99122 жыл бұрын
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!
@mohammadashiq99963 жыл бұрын
I like the Excel Lambda ,Very simple description, recommends Leilla gharani for Learning on Line
@LeilaGharani3 жыл бұрын
Thank you!
@frayue3 жыл бұрын
#Mindblown! Excel is getting powerful than ever! Love it! Thanks, Leila!
@elactecnology2 жыл бұрын
Leila is a game changer in our lives. Who else agrees put like. I am watching this video for the second time. Thank you Leila
@venkatiyer74593 жыл бұрын
Thanks again... Your teaching style is too good... Sorry I am using Excel 2019.... I have to wait for using Lambda...
@jasper_ferrer3 жыл бұрын
you explained this very well. Thanks
@solomonmokua46433 жыл бұрын
Wow, finally a neat way to write custom formulas and give them cool names😃
@amansaini49483 жыл бұрын
I am a Hindustani but I saw your video and did like it, whatever the English brothers are watching this video, they will definitely like the video.
@Azam_Pakistan3 жыл бұрын
Excellent. You know how to teach. Plus your lighting is just superb. You must be a photographer too.
@Abrogator912 жыл бұрын
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
@danwhite37083 жыл бұрын
What an awesome presenter. I just love how she teaches.
@statanaliz3 жыл бұрын
Спасибо за наглядное объяснение. Ждем обновление Excel. )
@amit120003 жыл бұрын
Great Leila you new concept in very simple way so we understand thing instantly
@LeilaGharani3 жыл бұрын
Glad you think so!
@FlameRat_YehLon2 жыл бұрын
One thing to note is that you can define lambda names locally using let function, and that's just creating local function inside a function that can be used multiple times. In the future, many Excel documents that has long formulae would probably be just a let with tons of parameters and the actual execution being actually clear to see what's going on.
@jimihope11132 жыл бұрын
Thanks Sister for your great help!
@SolomonKinyanjui_sk3 жыл бұрын
It's a good function , initially i thought it's similar to LET function but no this function is more powerful than LET. I hope it will be soon in excel so that I can practice, anyway good work.
@LeilaGharani3 жыл бұрын
agree. I think LET was just to setup the scene for Lamba. It will make it easier to make complex lambdas. But it's not necessary for simpler cases.
@SolomonKinyanjui_sk3 жыл бұрын
@@LeilaGharani Sure
@Wzxxx2 жыл бұрын
Amazing teaching skills
@kigoindonesia31953 жыл бұрын
I just know lambda function from you Leila, thanks!
@roelpanis87113 жыл бұрын
Thanks, very good explanation!
@growth25093 жыл бұрын
Outstanding function and well explained.
@LeilaGharani3 жыл бұрын
Many thanks!
@christoslefkimiotis98893 жыл бұрын
You've just opened new horizons, nice video, thx
@LeilaGharani3 жыл бұрын
You're welcome, Christos!
@trilmobile37163 жыл бұрын
I finally took the time to look at and try this. This is quite awesome. Thanks for the easy-to-understand explanation!
@konradbryczkowski2423 жыл бұрын
Thank you very much! I have recommended your channel to no end, it never fails! Keep at it!
@LeilaGharani3 жыл бұрын
Thank you for your recommendation!
@andrewmoss64493 жыл бұрын
Finally got LAMBDA in my Excel today! 🥳
@LeilaGharani3 жыл бұрын
Excellent! Let us know how you like it.
@OzduSoleilDATA3 жыл бұрын
This is intense. I wanna see this recursion jazz next week. 🤔
@aliikhlaq3 жыл бұрын
There are many tutorials out for lamba but waiting for you to upload Thank you Wonder Women :)
@LeilaGharani3 жыл бұрын
You're welcome 😊 I hope you liked it.
@Excelambda3 жыл бұрын
So great that you covered recursive. !!! VBA power , this is what we are looking for😉✌✌
@LeilaGharani3 жыл бұрын
Oh yes! This is best part! 💪🏼
@yewchoob857 ай бұрын
Took me a while to work out that the params after the function need to be right after the closed brackets, I usually break up formulas to make them more readable and it wasn't working. e.g. This works > LAMBDA(a,b, a*b)(1,2) This doesn't > LAMBDA(a,b, a*b) (1,2)
@mashokhan8811 Жыл бұрын
Really mam you are amazing - this is really help a lot - god bless you and love you mam so much
@exgnyaana28413 жыл бұрын
Have used Lambda in Python. Great to have it in Excel!!!!!!!!!!!!