Excel: Creating Custom Functions with LAMBDA

سرفصل های دوره

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.

01 - Introduction

01 - Create custom functions in Excel

02 - What you should know before starting

02 - 1. Introducing Custom Functions in Excel

01 - Explore custom functions in Excel VBA

02 - Describe the Excel formula language

03 - Describe the goals of formula programming

04 - Manage formulas on the Formula Bar

03 - 2. Creating a Custom Function

01 - Define a function using LAMBDA

02 - Assign a function name to a LAMBDA

03 - Define a variable using LET

04 - Use a LET statement in a LAMBDA

05 - Refer to Excel tables in a LAMBDA

04 - 3. Adding Logic to a Custom Function

01 - Create logical branches using IF and IFS

02 - Select a value using CHOOSE

03 - Select a value or display a default value using SWITCH

05 - 4. Creating Custom Functions for Specific Solutions

01 - Scenario Calculate Economic Order Quantity

02 - Scenario Calculate quality of service

03 - Scenario Calculate process capacity given a batch size

04 - Scenario Clean up imported text

06 - 5. Using LAMBDA within Other Functions

01 - Update values using MAP

02 - Summarize values using REDUCE

03 - Calculate intermediate values using SCAN

04 - Generate an array of values using MAKEARRAY

05 - Apply a LAMBDA to an array by column using BYCOL

06 - Apply a LAMBDA to an array by row using BYROW

07 - Manage LAMBDA output

08 - Troubleshoot LAMBDA output

07 - Conclusion

01 - Further resources

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: LinkedIn Learning (Lynda)