Channel: Sele Training

Category: Science & Technology

Tags: excel tutoriallambda recursivelambda dynamic rangemost powerful excel funcitonexcel recursive functionexcel advanced functionlambda function for 2021excel dynamic formulassele trainingexcel formulas and functionsrecursive functionexcel lambda functionlambdaexcel data typeslambda recursionlambda function excelexcel recursionrecursive lambdaexcel 2020excel 2021lambda excelexcel lambdalambda functionexcel 2021 lambda

Description: 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: techcommunity.microsoft.com/t5/excel-blog/announcing-lambda-turn-excel-formulas-into-custom-functions/ba-p/1925546 Dynamic Array Formulas Video: youtu.be/xwTUfU8PqCU Data Types Video: youtu.be/o3_-DnlfHkY LAMBDA Helper Functions Video: youtu.be/nCrnkHJQNEw LAMBDA More Complex Examples Video: youtu.be/Og9TYOWKXt4 Support me with your Amazon purchases, click here: 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