Excel LAMBDA Library Course: Build Your Own Excel Functions

LAMBDA lets you create your own Excel functions, such as =GSTINCL(A2), =FYLABEL(B2) or =CLEANNAME(C2), without VBA and without macros. In eight lessons you’ll build a personal library of 30+ functions for Indian office work (GST, lakhs and crores, financial-year dates, messy names and phone numbers) and learn to share it with your team.

Each lesson has a practice workbook with automatic checks. You need Microsoft 365 or Excel 2024.

Before you start: be comfortable with LET and dynamic arrays (lessons 4 and 8 of the Excel Intermediate Course).

1. 1Excel LAMBDA Lesson 1: Your First Custom FunctionWhat LAMBDA is, how to test it inline, save it in Name Manager and call it like a built-in function. With the…
2. 2Excel LAMBDA Lesson 2: GST, Lakhs and Money FunctionsBuild GSTINCL, GSTEXCL, GSTONLY, CGST/SGST, LAKHS, CRORE and ROUNDTO5 as reusable LAMBDA functions for Indian invoices and reports.
3. 3Excel LAMBDA Lesson 3: Text Cleaning FunctionsCLEANNAME, INITIALS, DIGITSONLY, WORDCOUNT and MASK: custom LAMBDA functions for messy names, phone numbers and sensitive data.
4. 4Excel LAMBDA Lesson 4: Financial-Year Date FunctionsFYSTART, FYLABEL, FYQTR, DAYSLEFT and AGEYEARS as LAMBDA functions for the Indian April-March financial year.
5. 5Excel LAMBDA Lesson 5: REDUCE and SCAN (Running Balances, Multi-Replace)Use REDUCE to fold a list into one answer and SCAN to keep every step: running bank balances, compound growth and a…
6. 6Excel LAMBDA Lesson 6: MAP, BYROW, BYCOL and MAKEARRAYApply your functions across whole ranges: MAP for every cell, BYROW and BYCOL for row and column totals, MAKEARRAY to generate grids.
7. 7Excel LAMBDA Lesson 7: Optional Arguments and Error HandlingMake LAMBDA functions friendly: optional parameters with ISOMITTED, sensible defaults, SAFEDIV and clear messages for bad input.
8. 8Excel LAMBDA Lesson 8: Package and Share Your Function LibraryCollect your LAMBDA functions in one library workbook, copy them to other files, use the Advanced Formula Environment and keep versions under…

Next: put your functions to work in the Bank Statement Automation course.