A quick announcement folks.
I am doing an Excel Boot-camp in Singapore this weekend (July 8-10) along with Paramdeep from Pristine. If you are interested in joining our Bootcamp, this is your last chance.
Visit our Singapore Excel Boot-camp page for details & sign-up information.
The last date for enrollment is Thursday, 7th of July. If you have any questions or doubts, you can call me at +91 814 262 1090 or email me at chandoo.d @ gmail.com
PS: We are planning have not more than 25 people so that the we can learn a lot better. So far we have about 11 people enrolled. So hurry up!
On the other note,
Many of you have asked me details about various upcoming training programs of Chandoo.org. So I made a training calendar to help you plan for various programs we are offering.
Chandoo.org Training Calendar
This is the training calendar for second half of the 2011 (July – Dec):
For details & links, visit our trainings page.
Click here to download our Training Calendar Excel Workbook.
Do you want any other training programs?
I am always looking for opportunities to learn new things and share them with you. So if you think I can train you on a particular topic, drop a comment and let me know. If we have enough interest on a particular topic, I can add a course on that.
Please share your ideas thru comments. Thank you.
PS: If you are in Singapore and want to learn Excel & Financial modeling, go ahead and sign-up for our boot-camp. Its going to be fun.
8 Responses to “What is LAMBDA? 4 Practical examples to REALLY understand it”
Thanks so much for this, it's utterly brilliant!
Silly question - I assume LAMDA will work with dynamic arrays?
Very much so. Many of the new functions like MAP only make sense in the context of dynamic arrays and Lambda functions.
As usual, very informative material. Easy to understand and apply!
Thanks for making everyone awesome!
Easy to understand Lambda function through this tutorial. Thanks Chandoo.
I have Officce 365 (updated), but I can't see LAMBDA function. 🙁
I dont see "Office Insider" option in my excel 365.
Another option for First Monday...
=LAMBDA(anydate,WORKDAY.INTL(EOMONTH(anydate,-1),1,"0111111"))
Loving the binary options in WORKDAY.INTL David...