Brand new in Excel for 2021 - LAMBDA is the most powerful function ever. LAMBDA lets you create your own functions and use them throughout a spreadsheet.
Brian's Blog Post: https://techcommunity.microsoft.com/t5/excel-blog/announcing-lambda-turn-excel-formulas-into-custom-functions/ba-p/1925546
Dynamic Array Formulas Video:
https://youtu.be/xwTUfU8PqCU
Data Types Video:
https://youtu.be/o3_-DnlfHkY
LAMBDA Helper Functions Video:
https://youtu.be/nCrnkHJQNEw
LAMBDA More Complex Examples Video:
https://youtu.be/Og9TYOWKXt4
Support me with your Amazon purchases, click here: https://amzn.to/2Kxp533
Contents
0:00
Introducing LAMBDA
0:13
Name a Function
1:28
Two Input Variables
2:38
Inputs Using Ranges
3:37
Data Types
4:15
Recursion
5:57
Availability
7:51
Conclusion
8:04
#seletraining #excel #lambda