#excel #exceltutorials #exceltips #exceltraining #microsoftexcel #advancedexcel #excelskills #businessintelligence #excelcourse #productivity #microsoft365 #office365 #exceltricks These are recently announced functions by Microsoft .where we can pass lambdas as arguments
Download data files for practice
https://bi-analytics.org/blogs/entry/...
More on Lambda function
https://bi-analytics.org/blogs/entry/...

0:00 Introduction
2:00 MAP
7:06 REDUCE
9:46 SCAN
13:42 MAKEARRAY
17:09 BYROW
18:56 BYCOL
20:16 ISOMITTED : optional parameter in lambda