In the 33rd session of Chandoo.org podcast, let’s turn the mic to our listeners and hear their tips.
What is in this session?
This session has 2 things.
- A surprise Easter egg (an Excel tip hidden in the podcast audio)
- Collection of Excel tips recorded & submitted by Chandoo.org readers
Listen to this session
Podcast: Play in new window | Download
Subscribe: RSS
Click here to download the MP3 file.
Links & Resources mentioned in this podcast
Keyboard & Mouse shortcuts
Chart formatting tips:
Transcript of this session:
Download this podcast transcript [PDF]
Did you find the Easter egg?
Now that you found the Easter egg, it is your turn. Go ahead and leave a comment with cryptic message. Share your favorite Excel tip or ideas with us.
Thanks to the contributors
Many many thanks to both Roberts, Micky, TJ, Val & Orkun. It was fun learning from you.
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...