Excel

Dec 30, 2022 7:00 AM

This is a 1 hour 45 min. video about everything that the Excel LAMBDA function can do.

This video is also a complete lesson in Defined Names, the LET function and Spilled Single Cell Formula Reports.Course taught by Excel MVP and Highline College Professor, Mike Girvin. Course is Microsoft 365 Excel Complete Story.

The LAMBDA function in Microsoft Excel is a new function introduced in Excel 365 that allows you to create custom functions using JavaScript. It allows you to define a function in a single cell, and then use that function in other cells in your spreadsheet.

- Download pdf notes: https://excelisfun.net/files/10-M365E...
- Download Excel file: https://excelisfun.net/files/10-M365E...

To use the LAMBDA function, you first need to define the function by typing an equals sign (=), followed by the keyword "LAMBDA", and then specifying the input parameters for the function. You then type a colon (:), and then write the JavaScript code for the function.

For example, to create a LAMBDA function that calculates the square of a number, you could use the following syntax:

`=LAMBDA(x: x`

*x)
*

You can then use this function in other cells by referencing the cell that contains the LAMBDA function and providing the input value as an argument. For example, to calculate the square of the number 5, you could use the following formula:

`=A1(5)`

The LAMBDA function is a powerful tool that allows you to create custom functions in Excel using JavaScript. It can be used to perform a wide range of calculations and tasks, and is particularly useful for developers who want to build custom solutions on top of the Excel platform.

https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67

- (00:00) Introduction
- (00:52) Overview
- (02:42) Defined Names
- (12:24) First look at LAMBDA to create a re-usable function
- (19:00) Advanced Formula Environment
- (23:40) Summary of LAMBDA
- (25:20) Rate Of Change Re-usable LAMBDA function
- (28:06) COGS Re-usable LAMBDA function created in Advanced Formula Environment
- (30:22) Save LAMBDA to default file
- (32:15) Show Formula Re-usable LAMBDA function
- (36:06) LAMBDA Helper Functions
- (36:32) BYROW and BYCOL functions
- (41:10) MAP function
- (49:16) SCAN function
- …
- (01:44:43) Closing and Video Links