Finally it clicked on what lambdas can do. I just created my first lambda function for something I do several time day. You have just helped my save soooo much time.
These videos are very helpful, simple and straightforward. You explain clearly what your doing without adding any irrelevant information. Also your names almost the same as mine I'm Benji :D
Super nice explanation of what lambdas are! Easy to grasp, and recreatable . But a little but, that has less to do with the lambda and more with your last step. Whilst I think the search field is super handy for very big data tables with many options, I would actually connect this with your lessons for dropdowns and the # . I just generally mistrust people to spell things correctly, and rather turn around and complain something isn’t working than check their own fallacy. So I take away the potential for mistakes by creating a field in an open area of the sheet or a new sheet with the formula =unique(Table[region column] Creating all unique and hence possible options for the filter and then reference to that field in the data validation with a #
Hi Kenji 😊 your training courses remain the best on UA-cam. My goal this year is to finish all your UA-cam videos coz they are sooooo helpful. I am transitioning from accountant to Commercial analyst roles and I don’t have too much exposure to sales revenue & commercial side of business in my current role. Would like to learn some hand-on experience from real life cases or projects . Do you have any suggestions from your website? Which course can I enrol?
My favourite reason to use Lambda is when I don't know exactly what formula will work best. E.g., working on a big forecast, and wanting to try different methodologies to predict future trends. By putting this into a lambda, it means that - rather than needing to update multiple worksheets with a new formula if I want to try something new - I can just update what is in the Lambda function to quickly compare an output.
Be careful using Lambda, especially recursively. I built an engineering model, part of which was to calculate additional battery strings required by several solution sets to ensure variable carry over times were met. It didn't scale as the number of solutions modelled expanded. No such scaling trouble with Powerquery or VBA, both of which are really well supported by AI.
Thank you for explaining the LAMBDA function, but everything you showed its also manageable by converting the data into a table, which can provide more filter and sort options. What are your thoughts?
Does the name manager save to the file or to your local excel? I am wondering if it works if someone on a different PC opens up the shared file will it have any issues working?
Hi thank you for your interest. I think the Excel for business & finance course is a nice starting point for you: www.careerprinciples.com/courses/excel-for-business-finance For any other questions you can ask info@careerprinciples.com 👍
Are the LAMBDAS reusable? I don't really understand the point of them if you have to go and create the formula first - you've already done the work anyway. Can you help me wrap my brain around it?
🚀Get FREE Excel chart templates from Hubspot: clickhubspot.com/933u
❤❤❤❤❤❤
BOSS I WANT TELL YOU
Finally it clicked on what lambdas can do. I just created my first lambda function for something I do several time day. You have just helped my save soooo much time.
Thank you. It means a lot to me😀
clearest explanation that I’ve seen so far
These videos are very helpful, simple and straightforward. You explain clearly what your doing without adding any irrelevant information. Also your names almost the same as mine I'm Benji :D
Thank you for your nice comment Benji! Yes haha they often confuse mine for Benji XD
Super nice explanation of what lambdas are! Easy to grasp, and recreatable .
But a little but, that has less to do with the lambda and more with your last step. Whilst I think the search field is super handy for very big data tables with many options, I would actually connect this with your lessons for dropdowns and the # .
I just generally mistrust people to spell things correctly, and rather turn around and complain something isn’t working than check their own fallacy.
So I take away the potential for mistakes by creating a field in an open area of the sheet or a new sheet with the formula =unique(Table[region column]
Creating all unique and hence possible options for the filter and then reference to that field in the data validation with a #
Wow, Kenji. I didn't know lambda and it just blowed my mind!! Thank you very much!!
Great to hear that!
Thanks Kenji you are a life savior God Bless you
"First like and first comment! I’m truly impressed by all your videos, sir. 🙏"
Thank you! Really appreciate it :)
can you do more advanced cases of Lambda?
Noted!
Hi Kenji 😊 your training courses remain the best on UA-cam. My goal this year is to finish all your UA-cam videos coz they are sooooo helpful. I am transitioning from accountant to Commercial analyst roles and I don’t have too much exposure to sales revenue & commercial side of business in my current role. Would like to learn some hand-on experience from real life cases or projects . Do you have any suggestions from your website? Which course can I enrol?
Thank you!! For course related questions you can email us at info@careerprinciples.com
Made lamda really easy to follow along. Thanks!
3:15 Lookup functions also work!
Ive never heard of this. You are brilliant!
You are Awesome. Thank you very much. 😊
Great explanation. Thank you, Kenji!!!
Nice ,easy to understand
Excellent ❤😊
Really helpful video!! Thanks Kenji
Excellent video!
My favourite reason to use Lambda is when I don't know exactly what formula will work best. E.g., working on a big forecast, and wanting to try different methodologies to predict future trends. By putting this into a lambda, it means that - rather than needing to update multiple worksheets with a new formula if I want to try something new - I can just update what is in the Lambda function to quickly compare an output.
You are genious!
Be careful using Lambda, especially recursively. I built an engineering model, part of which was to calculate additional battery strings required by several solution sets to ensure variable carry over times were met. It didn't scale as the number of solutions modelled expanded. No such scaling trouble with Powerquery or VBA, both of which are really well supported by AI.
Thank you for explaining the LAMBDA function, but everything you showed its also manageable by converting the data into a table, which can provide more filter and sort options. What are your thoughts?
Thank you
Great sir
7:39 Question: What is the "by_col" argument of the SORT() function?
Thanks.
Kenji, thanks for that! Cool!
Thank you kenji
Well done!
impressive that as well as being an excel-expert, you speak very good german!
13:53 In this case, you should modify it so you can do a wildcard search.
Can I carry this across my worksheets?
Does the name manager save to the file or to your local excel? I am wondering if it works if someone on a different PC opens up the shared file will it have any issues working?
Can this formula be applied to Excel on different devices? Or does the formula have to be created first? Terimakasih
Can user-created functions using LAMBDA be used across workbooks?
Hey, how can i use flatten function in Excel (two or multiple columns into one column)
Hello, I want to learn excel (just because I like it) which of your courses do you recommend. My level will be like basic-intermediate. Thank you
Hi thank you for your interest. I think the Excel for business & finance course is a nice starting point for you: www.careerprinciples.com/courses/excel-for-business-finance
For any other questions you can ask info@careerprinciples.com 👍
Qual a vantagem de usar o LAMBDA em vez de usar um módulo VBA para isso?
Are the LAMBDAS reusable? I don't really understand the point of them if you have to go and create the formula first - you've already done the work anyway. Can you help me wrap my brain around it?
They are reusable indeed
I was just thinking the exact same thing
Hi- couldn't get your spreadsheet to work correctly in Office365
I dont see a practical use for this, can anyone suggest what purpose this can serve?
Thanks, can i add some helper definitions to these custom functions?
LAMBDA is not on my excel
Lambda = PEMDAS and the Alphabet got merged like Jeff Goldblum in The Fly.
WHEN I DOWNLOAD VIDEO THE AUDIO IS NOT ENGLISH WHAT TO DO
ua-cam.com/video/zVyJCCk0sTY/v-deo.html