LAMBDA Excel Lesson 8: Using LAMBDA functions across multiple workbooks

This is the final lesson of an 8-Part Mini Course on LAMBDA in Excel
(Download the Excel file that goes with this course in the link below)

In this 8-part short video series, you will:
1. Learn how to use the LAMBDA Function in Excel and how to create simple Custom Functions using LAMBDA
2. Create a function called =CAGR() that calculates a Compound Annual Growth Rate
3. Create a function called =DSO() that calculates a company’s Days Sales Outstanding
4. Create a function called =IMPLIEDG() that calculates the implied growth rate of an annuity
5. Create a function called =EOQUARTER() to solve the problem we mentioned earlier
6. Create a function called =TSM() that calculates a company’s dilutive options using the Treasury Stock Method
7. Create a bonus function called =SHEETNAME() that outputs the sheet name of the active sheet (courtesy of Mr. Excel)
8. Learn how to share your LAMBDA functions with others

[patrickschardt]

Watching the final video in this mini series. So far, you are the only one I've seen show this trick

[trondolsen]

Is it possible to place the lambdas in PERSONAL.XLSB and then have them globally?

[wsj]

Great! Very helpful 🙏 would u plz do one for sensitive table especially when the financial model is big and complex with multiple sheets. I always suffer when I do sensitive table in another sheet and my inputs are in a different one. Searched all the vids on YouTube none are helpful. They are very few actually, and are based on very very simple one sheet one input models. It will be great help. If u wish, I can email u the sample financial model . Thanks in advance for considering my request.