Excel: Creating Custom Functions with LAMBDA
Duration: 1h 55m | .MP4 1280x720, 30 fps(r) | AAC, 48000 Hz, 2ch | 273 MB
Genre: eLearning | Language: English
Duration: 1h 55m | .MP4 1280x720, 30 fps(r) | AAC, 48000 Hz, 2ch | 273 MB
Genre: eLearning | Language: English
Discover how to create your own custom Excel functions with the LAMBDA function. Instructor Curt Frye begins with a brief history of custom functions in Excel, then explains the structure of the Excel formula language. Next, Curt shows you how to create a LAMBDA and define it as a custom function in Excel’s Name Manager. He also highlights how to manage loops and conditional steps. Plus, Curt covers how to use LAMBDA as an input to other new worksheet functions.
More Info