1 option
Excel: Creating Custom Functions with LAMBDA/ with Curt Frye.
- Format:
- Video
- Author/Creator:
- Frye, Curt, speaker.
- Language:
- English
- Genre:
- Instructional films.
- Educational films.
- Physical Description:
- 1 online resource
- Place of Publication:
- Carpenteria, CA: linkedin.com, 2022.
- System Details:
- Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScript and cookies must be enabled. A broadband Internet connection.
- Summary:
- Learn to use Excel's LAMBDA function to create your own custom functions.
- 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, recursion, and conditional steps. Plus, Curt covers how to use LAMBDA as an input to other new worksheet functions.
- Participant:
- Presenter: Curt Frye
- Notes:
- 11/29/2022
- Access Restriction:
- Restricted for use by site license.
The Penn Libraries is committed to describing library materials using current, accurate, and responsible language. If you discover outdated or inaccurate language, please fill out this feedback form to report it and suggest alternative language.