🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Very helpful. As an estimator in the field of construction, this video lesson will allow me cross over into other related disciplines with one formula using lambda.
i was doing fine w/ my old microsoft word 2016. moving into newer laptops w/ office365 complicates my simple calculations but then again this channel taught me how to.....Thanks Kev.....
This was a great tutorial. Easy to follow and understand. I do have one question though, how do I make the function work across multiple worksheets in a workbook? When I created the function on my worksheet labeled "2020", it worked great. When used on my worksheet "2021", it wouldn't work. The actual formula, =LAMBDA(DateIn,'2020'!I396-'2020'!H396+1) kept referring back to "2020." When I changed the formula to say "2021" it messed up my information on "2020." Any assistance is much appreciated.
Show me 2 different recursive Lambda() functions that play upon each other and I'll be even more impressed ^_^ (I am going to have experimenting with this; it's now on enterprise channel!)
Very powerful, particularly recursion. I would like to see a side-by-side comparison with array formulas (ctrl+shift+enter). I do think you could simplify the function setup by including the function name as a parameter, once the cell is calculated Excel would automatically create the name i.e. no need for the Name Manager steps.
Hellow ٠ please : when the formula reashing to un ending phase during introductin data? Thank you very much for special vedio* and i am very happy to wrighting for Microsoft ٠
Hi Kevin - I'm using office 365 provided my organization I don't see office insider option. How do I active office insider in this case if I want to activate it?
Hi Kevin, I used to use the OneNote clipping tool but after I updated to MS Office 2019, it just disappeared and can't figure out how to bring it back. Could you help please with a short video
1st question: what happens when so open the wb in an older Excel App? 2nd: what about speed? Is it the same speed as normal functions or does it slow down as 'indirect' functions do?
Wow, this is great! I'll try it, and if everything works out ok I can definitely see myself using it a lot. Thanks once more Kevin, you totally rule!!! 👌🤩😎
Quick note: All Beta Users Are Created Equal, But Some Are More Equal Than Others. • Insider: check • Beta: check LAMBDA function: ERROR, function not found. :-( Use it a lot, I will. For all the obvious reasons. This is major ultra. Combine it with the LET function inside, and the only things it won't be able to do are: make coffee and order pizza. ;-)
Hey kevin I hope you can help me with the following issue.. I am trying to do a screen record of an excel formula using windows 10. the excel function screen tips is not showing up when I record .. do you know how to solve this issue?
Hi Kevin, thanks for your amazing tutorial in this very new excel function. Just want to clarify though if my reader can see correctly the result of my formula using the Office insider if the former is not using the Office insider version.
You can do everything you can currently do in Microsoft Access, and then much more, with Microsoft Power Platform. Don't waste your time with Microsoft Access.
Awesome especially the recursion bit was mind blowing for those who do not have programming skills ....I hope you”ll revert to the topic with further examples on recursion .....
Great video. So the big question is can you create a vlookup that can take 2 inputs to match rather than just the 1, or bring back a value to the left of the matching value. That would make it good enough to replace VBA. In short can loop down rows yet?
For bring back value to the left, check out the new xlookup function. It solves for a lot of the vlookup deficiencies. For two value look up, I also just created an additional concatenate column and then searched on the merged value. It's a cheap and easy way to run a look up on two inputs 😁
@@KevinStratvert Thanks for th reply - I did not know about the XLOOKUP function so that is awesome. I did create my own lookup to bring back value to the left and I also called it XLOOKUP! Ironic or what. The trick of concatenating works well and I have used that trick more than once. Great videos and again - thank you for taking the time to reply.
That works :) That's how I get through all the UA-cam content that I want to consume. There are only so many hours in the day. I usually go at 2x though 😁
I reversed the order of the nested IF (as in, discount is 0 being the first logical test and quantity >150 as third nested IF) but it didn't work . Can you please give me a hint as to why?
Great explanation. However, changing values manually (i.e. the discount percentage) instead of using a parameter is bad practice ☹ I'd use parameters both for the threshold quantities for discount and the discount percentages.
What you now call Lambda(), a zillion years ago we called it a macro. As I remember, macros were rather hacker attractions. I'm now 80 yrs old... am I missing something.
Nice intro - thanks! But your use cases are IMHO opinion not the best. In the discount example you could replace the nested "if" with a simple (X) lookup table.. The "remove the digits" example makes sense because after all these years Excel still does not have regular expressions - the IMHO best solutions to clean up or validate input.
Hi Kevin. I am having trouble with a word document when attaching it in an email. The problem is that I have previously sent a word document through an email and I had to make some changes on the same word document - the changes were made and save it on my laptop. when I try to sent this update document to the same person, somehow is pulling the older version and attaching it to the email. Where or how this is possible? or where this version is save? do you know why this is happening? thanks in advance
Probably the easiest way to solve for this is to open the correct document on your computer. You can then save to the cloud via OneDrive or Google Drive. This way you won't have to attach to email and you won't end up with multiple versions/revisions. This way you'll always work off the most current version... and so will others who are working with you. Hope that helps!
Hi Kevin ,I follow Lambda Function Goto Account Setting And Changed The Channel Name Now My Channel is Beta Channel,But the Lambda function is not displayed in my office 365. Any Change my Office please make a video about lambda Inserting function
Thanks for this clear and useful demo of recursive functions. Hopefully some of my solutions with an explosion of temporary results will now collapse to a single formula, pretty!
huummm... !!!don't know... seems will confuse things a bit... especially when returning to the sheet to make changes or maintenance... I think I'll stay with good-old-obsolete-10-years-ago VBA for now!!!
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Sirach what? A cookie? Kev you’re just the most amazing teacher in the world
Dude, I just got the lambda function! This is an awesome tutorial!!
This video is highly underrated. I loved how you took it up step by step.
Very helpful. As an estimator in the field of construction, this video lesson will allow me cross over into other related disciplines with one formula using lambda.
i was doing fine w/ my old microsoft word 2016. moving into newer laptops w/ office365 complicates my simple calculations but then again this channel taught me how to.....Thanks Kev.....
I had fun watching your video, it has certainly open my eyes up on what can be achieved
Bro your content saves my life lots of times. Keep bringing the technology!!!
Thanks! Will do!
Hi Kevin, this lambda function is great, thanks for sharing some examples of it
This definitely a function I will be using. Thanks for sharing.
Yes this is going to be a great help and I love your channel
I like the way you explained .............. Keep it up !!
Thanks for the heart 😊
I'm your new subscriber here.. Thank you for making this wonderful video. it helps a lot.
Thanks for the note Jessrick! Thanks for subscribing 👍
You're an amazing person Kevin
Wow Kevin that kind of hard when you got to the number removal. Sort of understood the SUBSTITUTE and LEFT, but what does the RIGHT and LEN do
Nice video. Keep it up !
THANKS FOR THIS VIDEO. VERY INFORMATIVE, IT HELPS ME SPECIALLY DOING MY ONLINE SCHOOL ACTIVITIES. AWESOME 👏
Great video Kevin! Thanks for detailed yet simple explanation and right examples to make us understand LAMBDA! Waiting for its public release! 😊👍
This was a great tutorial. Easy to follow and understand. I do have one question though, how do I make the function work across multiple worksheets in a workbook? When I created the function on my worksheet labeled "2020", it worked great. When used on my worksheet "2021", it wouldn't work. The actual formula, =LAMBDA(DateIn,'2020'!I396-'2020'!H396+1) kept referring back to "2020." When I changed the formula to say "2021" it messed up my information on "2020." Any assistance is much appreciated.
Anyone know how to replace the cell reference B7 in the formula with the variable "Boxes" with just a mouse click as he did at 10:30?
Fun fact:the letter from the thumbnail is the greek L/ λ
EXCELlent tutorial!
Show me 2 different recursive Lambda() functions that play upon each other and I'll be even more impressed ^_^ (I am going to have experimenting with this; it's now on enterprise channel!)
Very powerful, particularly recursion. I would like to see a side-by-side comparison with array formulas (ctrl+shift+enter). I do think you could simplify the function setup by including the function name as a parameter, once the cell is calculated Excel would automatically create the name i.e. no need for the Name Manager steps.
Merry Christmas !!!
💗💖🎄🎁❄☃️✨❤💙💚
From the 🇵🇭
Thanks Kevin.
Hellow ٠ please : when the formula reashing to un ending phase during introductin data? Thank you very much for special vedio* and i am very happy to wrighting for Microsoft ٠
Thanks for your tutorial, it help me a great deal. Is there any way to run macro in protected sheet ? Thanks
Hi Kevin - I'm using office 365 provided my organization I don't see office insider option. How do I active office insider in this case if I want to activate it?
Hi Kevin, I used to use the OneNote clipping tool but after I updated to MS Office 2019, it just disappeared and can't figure out how to bring it back. Could you help please with a short video
1st question: what happens when so open the wb in an older Excel App?
2nd: what about speed? Is it the same speed as normal functions or does it slow down as 'indirect' functions do?
Wow, this is great! I'll try it, and if everything works out ok I can definitely see myself using it a lot.
Thanks once more Kevin, you totally rule!!! 👌🤩😎
Can you say about .csv file format in excel and how to extract data from this file format?
Quick note: All Beta Users Are Created Equal, But Some Are More Equal Than Others.
• Insider: check
• Beta: check
LAMBDA function: ERROR, function not found. :-(
Use it a lot, I will. For all the obvious reasons. This is major ultra.
Combine it with the LET function inside, and the only things it won't be able to do are: make coffee and order pizza. ;-)
Hi Kevin, Thank you for that great video.
Unfortunately I'm on Excel 365 but Excel seems not to recognize/accept LAMBDA !?
Thx for your answer !
You’ll need to enroll in the Office Insider program and opt into the beta channel. The very beginning of the video shows how. Hope that helps!
Does anyone know, when the lamda function is fully integrated in excel without to be in the insider program?
thanks, woukd the recursion function work if yiu use the some number two times in the name?
Hey kevin I hope you can help me with the following issue.. I am trying to do a screen record of an excel formula using windows 10.
the excel function screen tips is not showing up when I record .. do you know how to solve this issue?
Hi Kevin, thanks for your amazing tutorial in this very new excel function. Just want to clarify though if my reader can see correctly the result of my formula using the Office insider if the former is not using the Office insider version.
Thanks Kevin 😍🇱🇰
Hi Kevin, I know much abt vba and making my own udf. What's faster you think?
Kevin bro!! Can you please make a video on how to use Microsoft acess,, plzzz
You can do everything you can currently do in Microsoft Access, and then much more, with Microsoft Power Platform. Don't waste your time with Microsoft Access.
Video on Microsoft Access is landing in an hour and a half 👍
Awesome especially the recursion bit was mind blowing for those who do not have programming skills ....I hope you”ll revert to the topic with further examples on recursion .....
Great video. So the big question is can you create a vlookup that can take 2 inputs to match rather than just the 1, or bring back a value to the left of the matching value. That would make it good enough to replace VBA. In short can loop down rows yet?
For bring back value to the left, check out the new xlookup function. It solves for a lot of the vlookup deficiencies. For two value look up, I also just created an additional concatenate column and then searched on the merged value. It's a cheap and easy way to run a look up on two inputs 😁
@@KevinStratvert Thanks for th reply - I did not know about the XLOOKUP function so that is awesome. I did create my own lookup to bring back value to the left and I also called it XLOOKUP! Ironic or what. The trick of concatenating works well and I have used that trick more than once. Great videos and again - thank you for taking the time to reply.
You can speed up the playback to 1.5 and you could still understand it.
That works :) That's how I get through all the UA-cam content that I want to consume. There are only so many hours in the day. I usually go at 2x though 😁
How to get Microsoft store on your Android Phone or Iphone Phone
I reversed the order of the nested IF (as in, discount is 0 being the first logical test and quantity >150 as third nested IF) but it didn't work . Can you please give me a hint as to why?
Great explanation.
However, changing values manually (i.e. the discount percentage) instead of using a parameter is bad practice ☹
I'd use parameters both for the threshold quantities for discount and the discount percentages.
Kevin, I see that lambda works with an IF statement, but will it work with an IFS statement?
Great explanation, kevin, but you didn't explain second part bringing recursion function into lambda in detail
Is Lambda available to all 365 versions? I have Personal. I selected Beta, I cannot locate Lambda.
What you now call Lambda(), a zillion years ago we called it a macro. As I remember, macros were rather hacker attractions. I'm now 80 yrs old... am I missing something.
Nice intro - thanks!
But your use cases are IMHO opinion not the best.
In the discount example you could replace the nested "if" with a simple (X) lookup table..
The "remove the digits" example makes sense because after all these years Excel still does not have regular expressions - the IMHO best solutions to clean up or validate input.
Hi Kevin. I am having trouble with a word document when attaching it in an email. The problem is that I have previously sent a word document through an email and I had to make some changes on the same word document - the changes were made and save it on my laptop. when I try to sent this update document to the same person, somehow is pulling the older version and attaching it to the email. Where or how this is possible? or where this version is save? do you know why this is happening? thanks in advance
Probably the easiest way to solve for this is to open the correct document on your computer. You can then save to the cloud via OneDrive or Google Drive. This way you won't have to attach to email and you won't end up with multiple versions/revisions. This way you'll always work off the most current version... and so will others who are working with you. Hope that helps!
I have an annual Office 365 subscription and there was no option to join Office Insider through the Account option
I typed =lambda(X,Y,X+Y) and i got #NAME?. Please, what does this mean? Lambda not yet available in my version?
Can u please show me how to use Adobe premier pro editing software
I've got it on my list. Most recently, I've been using DaVinci Resolve 17 as my main editing app so that's been my focus.
Hi, we can directly use if function know?
Hi Kevin ,I follow Lambda Function Goto Account Setting And Changed The Channel Name Now My Channel is Beta Channel,But the Lambda function is not displayed in my office 365. Any Change my Office please make a video about lambda Inserting function
Hello Kevin sir ☺️
I would like to make my recordings more clear I mean very clear but I am no been able to please help me kevin
Can you tell me more? Video or audio recordings?
@@KevinStratvertMy texts inside the recording is not clear. I mean the texts in my video recording
Thanks for this clear and useful demo of recursive functions.
Hopefully some of my solutions with an explosion of temporary results will now collapse to a single formula, pretty!
Why cant I get the free Windows Video Editor on my Windows 10?
That symbol reminds me of Half-Life.
Hello kevin how to dark mode messenger in pc i hope you see it
I'm sorry Kevin, is too complicated for me,, this video I can't get understand about Xls format .. anyhow,, u are doing great about the video..👍
Me as a kid...this is complicated because i still learning in microsoft power point and word :P
When you're already understand how to use the function yet you don't have the Office Insider... lol
I could not see the Office Insider Option
Your Admin may not like you very much... ;-)
I signed up for insider but lambda is not working
The only other thing to check... make sure to also join the beta channel.
@@KevinStratvert I have and it's still not showing up when I input =lambda, to clarify I have Microsoft 365 family membership
I thought it was a video about lambada and that kevin was going to dance the lambada Brazilian way...
huummm... !!!don't know... seems will confuse things a bit...
especially when returning to the sheet to make changes or maintenance...
I think I'll stay with good-old-obsolete-10-years-ago VBA for now!!!
Name manager already in excel so why we use lambda .
You can’t create functions within the name manager today e.g you can’t use it to pass in a value and get a result unless you use lambda.
1st comment, 1st View
Lamda lamda lamda!
1St view!!!
You give 4 secs ago I gave 36 secs ago
1st view!!!!
Macros are much better