Excel LAMBDA Function: How & When to Use It (Beginner-Friendly)
MyOnlineTrainingHub MyOnlineTrainingHub
604K subscribers
39,971 views
0

 Published On Feb 24, 2021

How to create custom functions in Excel with no programming languages.
👩‍🏫 Save hours of work by mastering Excel with my courses: https://bit.ly/excelcourses0221

➡️ DOWNLOAD the free example file here: https://bit.ly/lambdafile

The new Excel LAMBDA function allows you to define your own custom functions using Excel's familiar formula language, and that means we no longer need JavaScript or VBA programming knowledge to create our own functions. This is a huge step forward! For those familiar with the concept of LAMBDAs, it is worth noting that the LAMBDA function makes Excel's formula language touring complete. Let's take a look!

LEARN MORE
===========

📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/e...

🎯 FOLLOW me on LinkedIn:   / myndatreacy  

💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e...

⏲ TIMESTAMPS
0:00 You don't need JavaScript or VBA to do this anymore
00:39 How to create an Excel LAMBDA
03:37 Practical examples of using LAMBDA
05:47 How to use LAMBDA with other functions
08:48 How to use LAMBDA and LET together
13:08 What you need to know about the function

View my comprehensive courses: https://www.myonlinetraininghub.com/

#LAMBDAFunction #ExcelLambda #ExcelTutorial

show more

Share/Embed