Modules (Gists)

PvtSumByPrdλ - custom function creates filtered PivotTables that do not need refreshing in under 20 seconds.

Model errors can kill our careers. Reducing them is one of my top priorities. A proven way to reduce errors by as much as 50% is through component reuse which was made possible when LAMBDAs were introduced. The example above creates a transaction summary by period and account in one cell in under 20 seconds. Expands automatically. No refresh required.

LAMBDAs can create custom functions specifically designed for reuse in multiple Excel projects - just like Excel's functions. Imagine trying to create models without Excel's functions - without SUM(), IF(), XLOOKUP() etc. It would take forever and increase error chances tremendously. Excel provides over 500 time savings, error free functions. But sometimes, we need functions Excel doesn't have. We can create them with LAMBDA.

If we create LAMBDA functions using standards proven to produce error free components, we can then use those pre-tested, pre-built LAMBDAs to assemble models quicker and with fewer errors. The standards are grouped under the name CBSE which is an acronym for Component Based Software Engineering. 

You can use my CBSE compliant LAMBDAs in your projects now. They are freely available on GitHub which Microsoft's free Advanced Formula Environment add-in uses to pull modules (Microsoft' term for a collection of related LAMBDAs) directly into Excel projects. 

GitHub Gist - A free online repository supporting LAMBDA modules.