The Silence of the LAMBDA -- An Introduction to Excel's LAMBDA Function
Vložit
- čas přidán 24. 07. 2024
- If you've been hearing about the LAMBDA function in Excel but aren't sure what it is, why it's useful or where to start, then this video is for you!
The LAMBDA function in Excel lets us turn lengthy formulas into our own custom functions that can be reused anywhere in the workbook.
This video is aimed at people who are new to LAMBDA and provides an introduction to the basics. We'll introduce the concept or variables, start replacing cell references with variables and then we will create our own functions.
#excel #lambdafunction
********************************
🔗LINKS to related videos
➡️Refine data with the FILTER function
• 💫 Refine data with the...
📉Create a Basic Pivot Table in Excel - Part 1
• 🎉Create a Basic Pivot ...
📊Create a Basic Pivot Table in Excel - Part 2
• 📈Basic Pivot Table Ski...
************************************************
🤝Let's CONNECT on social:
➡️TikTok: / cellmates_
➡️Instagram: / cellmatestr. .
➡️LinkedIn: / deborahas. .
➡️Twitter: / cellmates_
➡️Facebook: / cellmates
Awesome explanation! 💚🐏🙂
Best, concise explanation of LAMBDA that I've come across so far!
Thank you!
Very clear explanation Deb with interesting examples. Thanks for posting on CZcams.
Best video about LAMBDA so far. Now I know what this function does and how helpful it can be. 👏🏽👏🏽👏🏽👏🏽👏🏽
Amazing! Glad you enjoyed the video!
Hi Deb,
This is the 1st video that I watched on Your Channel - I liked it.
✓ The names were very funny - Tom Bruise . . Bradley Hooper . . Jon Scam 😁
✓ Request: please provide a downloadable practice Workbook. It will be very, very helpful 🙏🏿
Thank You!
U r an Amazing Teacher. Lambda function explained in plain vanilla . A 5 star rating for u. Thanks
Thank you so much!
Great video - so clear.
Thanks for this very informative video. by the way the title is well chosen.
❤❤❤❤❤❤
Nicely done Deb!
This presentation was very informative
Thank you!
Would you (please) do a video on the best and easiest way to share these Lambdas in different workbooks
Hi Rosy, great question! There is no button as such to make them accessible across workbooks. The simplest way I have found is to simply click on the cell that contains the LAMBDA, copy and paste into a new workbook. That copies the formula across. You can delete the formula once you’ve done that. The named range/formula should now stay in the new workbook.
Thank you so much.
What about Lambda Helper functions?
Thank you Debs. This is informative.
How about we get Python in Excel video? 😊
Possibly soon Deborah ;-)
Thank you for this
Teaching it this way makes it super easy
How is the performance if i would use it on ranges exceeding 3000 rows?
You're welcome! You shouldn't have any problems using it on larger datasets. It's the same as using any other function. Thank you for watching!
@@cellmatestraining thank you for the feedback.
any thoughts about a way to calculate empty cellls using subtotals? I managed to do that with helper columns but haven't figured away to do it :)
thank you in advance
@@ahmed007Jabertry using AGGREGATE instead. It will sun cells and you can choose to ignore blanks.
It is very easy to create new functions to use in the cells using VBA Functions (not subs).
Lambda let us do SIMPLE functions, without VBA. Nice. But VBA allows more complex functions since it's a full program, and Lambda is just one formula.
Yes, but for the average user sitting at their desk, VBA is extremely difficult to learn and most have no need to learn it.
LAMBDAS are a simpler and easier for most to understand. This is a basic LAMBDA, they can be very complex.
@@cellmatestraining you are right, but even low complexity Lambdas are also not for the average user sitting at their desk.. let alone very complex ones. Average users will NEVER create a personal function.
@@cellmatestraining depends of the problem... actually VBA in many cases is less complicated than a complex lambda with all those nested functions... mpa, let, lampda inside other 3, lol... when lambdas get mediu complex, it's already impossible to read compared to an easy procedural sequence of lines... not to mention how easier it is to loop, and other things... recursiveslambda is yeat harder to understand when you are not above avrg user. But yeah, I know where you aim it and it's quite right. Actually both tools serves same purpose, but for most time, different problems... VBA is where it would be way too complex to do in lambas, or actually impossible.
@@smanzoli every formula I show someone jumps into the comments to say why something else is better. 😂 That’s fine! I’m simply here showing how these functions work. I’m not telling you to use them if you find something else better or easier.
No one is going to comment on silence of the LAMBDAS ?! :)
I know right? I was so proud of that. 😂
@@cellmatestraining any new uploads about the new In-excel-python feature?