Again and again, amazing teacher; easy to follow, well paced and insightful.
@Officeinstructor
3 жыл бұрын
Thank you so much. Glad you liked it
@leksdic
3 жыл бұрын
While others just show the new function with x,y and x+y, you showed a comprehensive, functional, everyday-use example.And that is why I'm subscribed!
@Officeinstructor
3 жыл бұрын
You can't imagine after the INCREDIBLE effort I put in my videos, how much such encouraging comments make me Happy. Thank you Alex
@geezitshuge
3 жыл бұрын
Your a Genius, and a great teacher. That's a rare combination.
@Officeinstructor
3 жыл бұрын
Wow, thanks!
@yousrymaarouf2931
3 жыл бұрын
Our teacher, Nabil Murad, you made the excel program a pleasure and you became better watching one of your channel’s videos than watching a movie or watching TV .. Thank you for the wonderful preparation, interesting presentation, graceful language and great direction ... You made me very happy ... Many thanks and Respect ,,,
@Officeinstructor
3 жыл бұрын
Thank you very much Yousry, it's a great pleasure to read your feedback and have you as a member of the OfficeInstructor channel
@nadermounir8228
2 жыл бұрын
Very well explained Nabil. Thank you for this amazing video 📹 👍
@ImagineTraining
3 жыл бұрын
Absolutely brilliant, well paced and clear explanation with so many extra nuggets of information during the demonstration. Bravo!
@Saad.PS2009
3 жыл бұрын
شرح واضح ومميز جدا مشكور استاذ / نبيل مراد
@Officeinstructor
3 жыл бұрын
Thank you my friend Saad
@SolomonKinyanjui_sk
3 жыл бұрын
Good work Nabil. This lambda function is similar to LET function so what is the distinction? I'm an officer insider but how do I create the lambda function I want to practice.
@Officeinstructor
3 жыл бұрын
The Lambda Function can have one or multiple nested LET functions, as well as other LAMBDA functions. Unlike the LET, it can be saved as a custom function and you can use it like any built-in function
@SolomonKinyanjui_sk
3 жыл бұрын
@@Officeinstructor so how do I get the function from insiders I'm already an insider.
@123mailashish
3 жыл бұрын
Can we change ur name to "Nabil Magician Mourad"
@Officeinstructor
3 жыл бұрын
Thank you my friend... That's very nice of you. I'm glad you enjoyed the video.
@armotxa124
3 жыл бұрын
Thank you 👍
@Officeinstructor
3 жыл бұрын
You are Welcome
@Softwaretrain
3 жыл бұрын
Thanks, easy explanation, But I think this issue is not a good example for LAMBDA function. For this challenge it's better to use Let function as bellow in one formula. =LET( name,INDEX(A:A,SEQUENCE(COUNT(C:C),,3,3)), family,INDEX(A:A,SEQUENCE(COUNT(C:C),,2,3)), Fname,name&" "&family, region,INDEX(B:B,SEQUENCE(COUNT(C:C),,4,3)), amount,INDEX(C:C,SEQUENCE(COUNT(C:C),,3,3)), CHOOSE({1,2,3},Fname,region,amount))
@Officeinstructor
3 жыл бұрын
LET function is a great function No doubt. Note that my goal is to teach the concept of a new function to millions of viewers in a simple way (as much as I can). I will definitely create much more advanced examples of the Lambda function with nested LET functions. When introducing the new function, Microsoft gave us the simplest example you can imagine: =Lambda(x,y,x+y). I tried to create something a little bit more interesting. I spend few minutes thinking of the example and long hours thinking how to explain it in a very smooth way. Anyway, I appreciate your valuable contribution.
@Softwaretrain
3 жыл бұрын
@@Officeinstructor You are great. Appreciate it. I watched your other tutorials and really amazed. Just I wanted to give you a feed back since if we use new function in an example that will not solve with other solutions as easy as it is, will be better. Anyway I really liked your tutorials. Thumbs up.
@johnsonbrown5735
3 жыл бұрын
Magnificent, Bravo👍🏼
@Officeinstructor
3 жыл бұрын
Thank you
@OzduSoleilDATA
3 жыл бұрын
Amazing, Nail. Just amazing. 💥💥💥
@Officeinstructor
3 жыл бұрын
Thank you so much my friend. Totally appreciated Oz Du Soleil
@gaylonpeterson1568
3 жыл бұрын
Thank you Nabil for all you intense effort to make such appealing graphics, you eloquent narration and for waving your 'Magic Wand' to make the complex appear simple. The videos you make are always very interesting. Looking forward to many more of your videos.
@Officeinstructor
3 жыл бұрын
So nice of you
@rmorales0415
3 жыл бұрын
Very very nice your my favorite tutorial Teacher for excel 👍👍👍👍👍
@Officeinstructor
3 жыл бұрын
Thank you so much Ricardo for the nice comment. It's a pleasure to have you in my channel.
@GrainneDuggan_Excel
3 жыл бұрын
Wow - such a clear explanation of why we might want to use lambda. Thank you Nabil
@Officeinstructor
3 жыл бұрын
You are most welcome
@IvanCortinas_ES
3 жыл бұрын
Excellent explanation Nabil. I have to review the whole process with peace of mind. I think the new Lambda function helps the second user, or end customer, to better understand the process. As for the creator of the process, it simply brings order, but has to do redundant work, because the work already worked well before! A question. Once the function is created, can it be used in different books? Thank you very much for telling us all the details!
@adnanahmed8821
3 жыл бұрын
What an amazing function. Will lambda, sequence, filter be available for office 2019? Most of the users don't have office365.
@marcosbrooksallen7868
3 жыл бұрын
Very Good and Well Explained. Thanks Mr. Nabil. Your contributions to the Community are very appreciated!.
@mikahamari5994
3 жыл бұрын
I have made the updates and *lambda* is still not found (365, Windows). I read from some sources that they give it first to some users and eventually it is given to everybody. This isn't fair. What is this all about?
@gaurangkelkar4376
3 жыл бұрын
Lambda is time saving ,only once your time invested in to make basic formula and than after enjoy the show of LAMBDA. That's great
@sasavienne
3 жыл бұрын
A great video from a great teacher. Thanks Nabil . Salim from Hamburg.
@Officeinstructor
3 жыл бұрын
Thank you Salim
@sasavienne
3 жыл бұрын
@@Officeinstructor Thumbs up. I will try all these steps on my own PC إن شاء الله.. Must see this video again.
@luisv7117
3 жыл бұрын
Genius is like a database but in excel well done, no stupid music and slow explanation thank you sir.
@Officeinstructor
3 жыл бұрын
You are most welcome Luis
@axion8788
3 жыл бұрын
Most revelatory exposition of the Lambda function I've seen. Wow, the use of context and steps is superb!
@sn-rn4pv
3 жыл бұрын
Nabil, you are just awesome, no words, an excel legend. Thanx a lot for such an informative and useful post.
@9Dan22
3 жыл бұрын
There is so much to learn in excel, this software alone is a university degree on its own. Once you master it you will discover amazing things. It can organise your life
@9Dan22
3 жыл бұрын
Can you give us must more basic examples on lambda.. to understand this you got to be already at advanced level. Give us some small examples and we can build on that.
@mohammadmohammad-yv4md
3 жыл бұрын
Masha'Allah superb explanation
@Officeinstructor
3 жыл бұрын
Thanks and welcome
@WeyherPfalz
3 жыл бұрын
Wow!
@Officeinstructor
3 жыл бұрын
!!
@KishoreKumar-of7sb
3 жыл бұрын
waiting for Exercise File !!!
@Officeinstructor
3 жыл бұрын
Done! Check the link in the video description
@jimfitch
3 жыл бұрын
Thank you, Nabil, for this clear explanation using a complex example. *** I realize that your purpose is explanation of LAMBDA (mission accomplished), but also think that you could write this to incorporate the INDEX statement which would further simplify the user’s implementation in the workbook. Something along the line of: fctGetValue(vSourceRange, vIndex, [formula]). *** I use LET extensively & see the greatest value of LAMBDA as simplifying the user’s ability to audit & maintain/update functions that are used in multiple instances in the same workbook. That will be extremely helpful for my applications where I develop workbooks, release them for use, then return to them in 12-18 months when something breaks, the inputs change, &/or functional requirements change. LET & LAMBDA will make that come-back-to-it-later review so much easier, especially as advancing age takes its toll. *** I’m aware that LET & LAMBDA can be used together, but I anticipate that I’ll use LET for functions that are used once in a workbook & LAMBDA for functions used more than once. (I’ll also use LET within LAMBDA to make complex functions easier to understand.) *** Now, my big problem: what standard prefix will I use for LAMBDA functions? 😉 I use fct for VBA functions, fx for Power Query functions; what should I use for LAMBDA? *** Thanks again for this great tutorial.
@Officeinstructor
3 жыл бұрын
Hi Jim, totally agree with what you said. I definitely have the intention of creating another tutorial where i nest the LET into the Lambda and call another Lambda from within a Lambda, something that will be much more complex than this tutorial. Thanks for sharing your experience and ideas.
@jamesdavis4163
3 жыл бұрын
Is this available in Excel for Mac, I can't seem to find it
@tsvs58
3 жыл бұрын
Excellent explanation and demonstration. Mumtaz
@petermyran4986
3 жыл бұрын
Very interesting and such a good example to illustrate the usefulness of the LAMBDA() function. I look forward to the link example workbook to be posted so I can follow along step-wise. Thanks!
@Officeinstructor
3 жыл бұрын
Done! Check the link in the video description
@snaiper73
3 жыл бұрын
Clear explanation, thank you sir!
@nerenlakhraj5252
3 жыл бұрын
Nabil this is fantastic ... Previously I had given up when dealing with over a 1000 records but now there is a solution. Thank you, its fantastic
@Officeinstructor
3 жыл бұрын
Glad you like it Neren. Thanks for watching
@Luciano_mp
3 жыл бұрын
Very well explained. Thanks for another excellent tutorial. Thanks Nabil!👏👏👏
@Officeinstructor
3 жыл бұрын
Always welcome
@nonoobott8602
3 жыл бұрын
Amazing video tutorial. The use-case is very apt. You're very explicit in your teaching as always. Thanks for sharing
@Officeinstructor
3 жыл бұрын
Thank you my friend for the nice words and motivation (as always)
@nonoobott8602
3 жыл бұрын
@@Officeinstructor Trust me it's devoid of flattery. I've learned so much on Excel from you and you're an amazing teacher. Keep shining your light
@mouradmourad-iw1mj
2 жыл бұрын
روعة مراد استمر
@argokusumandani9773
3 жыл бұрын
🎉👏 Brand new & revolusioner function. Thank you Sir!
Пікірлер: 69