Introducing Excel's BRAND NEW function: Excel LAMBDA Function. Excel Lambda allows you to create your own Microsoft Excel custom function without any coding.
In this tutorial I explain in simple words and practical examples of how you can use the Excel lambda function. If you find yourself doing repeated calculations but couldn't find a function that fits your specific needs, THIS will be for you!
I'll take you through the basics of Excel Lambda and how you can apply it to your own Excel files. You will also see an example of a recursive lambda where we loop through cells to do multiple replacements.
In another video (next week) I'll show you how you can program your own Excel RECURSIVE LAMDA. This allows you to create loops in Excel that keeps repeating - with a formula!
Important: Excel Lambda function is available only in Excel for Microsoft 365, currently still in Office Insider (Beta Channel).
Time Stamps
00:00 Excel Lambda Function
00:59 Recursive Excel Lambda Example
02:55 Practical Example of Excel Lambda
04:54 Excel Lambda Explained in Simple Terms
05:20 How to Create an Excel Lambda
09:05 Excel Lambda in Name Manager
10:27 Practical Example of Excel Lambda (with Dynamic Array Functions)
★ My Online Excel Courses ►
✉ Not sure which of my Excel courses fits best for you? Take the quiz:
EXCEL RESOURCES I Recommend:
Get Microsoft 365:
Microsoft Surface:
GEAR
Screen recorder:
Main Camera:
Backup Camera:
Main Lens:
Zoom Lens:
Audio Recorder:
Microphone:
Lights:
More resources on my Amazon page:
Let’s connect on social:
Instagram:
Twitter:
LinkedIn:
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #excel #lambda
0 Comments