Channel: Sele Training

Category: Science & Technology

Tags: reducenew excel functions 2021excel functionsscanisomittedsele trainingbrand new excel functionslambda on steroidslambda helper functionsexcel helper functionsexcellambdamicrosoft 365bycolseletrainingmicrosoft 365 excel7 lambda helper functionsexcel 365excel 2021excel formulasexcel lambdamapbyrowmakearray

Description: Microsoft just released a set of new functions that takes LAMBDA to a whole new level. I’m talking about the new LAMBDA helper functions. These functions have shown up in the preview versions of Microsoft 365 Excel and it appears Microsoft has had bigger plans for LAMBDA than we realized. Support me with your Amazon purchases, click here: amzn.to/2Kxp533 LAMBDA Function Intro Video: youtu.be/Ayc7QOadBa4 LAMBDA More Examples Video: youtu.be/Og9TYOWKXt4 Contents 0:00 LAMBDA Refresher 0:28 MAP 1:38 BYCOL 4:03 BYROW 5:04 SCAN 5:48 REDUCE 7:36 MAKEARRAY 8:05 ISOMITTED 9:04 #seletraining #excel