Profile PictureGareth Stretton

Excel Lambda Library + Business & Helper Functions

$10+
0 ratings

This product is an Excel personal workbook. It allows you to write your own functions and re-use them in other other Excel workbooks.

Here's what they look like...

And here is how they are used:

=NOMINAL_RATE(2.5%, 1.5%)

In the formulae above, you can see the LAMBDA function take input variables (e.g. real_rate, inflation_rate) and the last argument is the actual equation that uses the input variables.

When you are familiar with this style of writing functions, they become easier to read and use than equations that work with cell references, e.g. 'real_rate' vs 'A1'.

I've described the detailed steps on how to build this from the ground up here.

The benefit of downloading it from Gumroad is:

  1. It is ready-to-go and doesn't require as much setup
  2. It provides business functions.
    Subjects include: Corporate Finance x21, Marketing x20, Investing x4, Real Estate x2, and Economics x1
  3. It provides helper functions to overcome the limitations of Excel
    An example: Show Formula but replace cell references with actual vaules
  4. It can serve as a set of examples for your own lambda functions

I'd still encourage reading over the article too.

Thank you for supporting my work!

$
Add to cart

Excel Lambda Library + Business & Helper Functions

Size
78.4 KB
Copy product URL
$10+

Excel Lambda Library + Business & Helper Functions

0 ratings
Add to cart