LAMBDA Course
Description
his course is designed for users who are comfortable with basic Excel formulas and functions and want to learn how to create their own custom functions with LAMBDA..
Learning Objectives
At the end of this course, learners will know:
Understand the benefits of using LAMBDA functions in Excel.
Grasp the syntax and structure of LAMBDA functions.
Learn how to define arguments and perform calculations within a LAMBDA function.
Build practical custom functions for common tasks (e.g., CAGR, DSO, etc.).
Explore advanced concepts like nesting LAMBDA functions and using LET for intermediate calculations.
Apply best practices for creating user-friendly and error-proof custom functions.
Dynamic arrays and LAMBDA helper function
Using REDUCE() to overcome the Array of Arrays problem
Creating recursive LAMBDAs
Classes
LAMBDA Introduction
Building Your First LAMBDA Function
Practical Applications of LAMBDA
Intermediate LAMBDA TechniquesÂ
Dynamic Arrays and LAMBDA Helper Functions
Using REDUCE to Overcome Array of Arrays Problem
Creating Recursive LAMBDAs
Best Practices and Sharing Functions
Prerequisites
This course requires learners have:
Basic knowledge of Excel's functions.
Basic knowledge of Dynamic Arrays
Office 365 or Excel 2021, and Microsoft's free Advanced Formula Environment add-in.
GitHub Gist account (we will explain how to get this)
Start your course by clicking 1. What a LAMBDA is and its syntax in the Classes box above. After you finish each class, click the next one in the list to navigate to the next class.