Download Excel File: https://excelisfun.net/files/EMT1749.xlsx
Learn how to use the 7 helper functions for the LAMBDA function. Learn how to use LAMBDA to create a re-usable function, and then how to use LAMBDA as a function value in the LAMBDA helper functions: MAP, SCAN, BYCOL, BYROW, REDUCE, ISOMITTED, MAKEARRAY.
Also see the Old School worksheet formula methods we used to use when we did not have these new functions.
1. (00:00) Introduction
2. (00:15) Function values are now in the Excel worksheet
3. (00:54) LAMBDA to make a reusable function.
4. (02:43) ISOMITTED Function to add message for missing arguments.
5. (03:39) How BYROW, BYCOL and MAP are related.
6. (04:32) How SCABN and REDUCE are related
7. (04:49) What is MAKEARRAY
8. (04:56) BYROW Function to create spilled row totals.
9. (06:56) BYCOL Function to create spilled column totals.
10. (07:41) MAP Function: three examples.
11. (08:53) How MAPS and BYROW are related.
12. (09:19) MAP function to spill results from the scalar AND Logical function. This MAP example uses a LAMBDA function that works across two columns.
13. (10:44) BYROWS to help calculate standard deviation of finance portfolio of stocks
14. (12:26) SCAN Function to create array of running total counts. This example uses SCAN to add and accumulate.
15. (13:27) REDUCE Function to add a set of numbers after they accumulate.
16. (14:10) SCAN Function multiply and accumulate.
17. (14:25) SCAN Function to join and accumulate.
18. (14:49) MAKEARRAY Function to create an array of random values.
19. (15:25) MAKEARRAY that uses row and column variable in LAMBDA.
20. (15:54) Summary and concluding video links