MS Excel — My LAMBDA Function Compilation

Coming to Microsoft 365 (I Hope) Soon!

A new function introduced on December 3, 2020 by the Excel team at Microsoft is getting rave reviews. 🔥

And it appears warranted.

It is essentially VBA (Visual Basic) without needing Macros to create User-Defined Functions (customized calculations) within plain Excel (.xlsx) files.

Review the content below to start to get a sense of why this is a big deal!

LAMBDA function

Announcing LAMBDA: Turn Excel formulas into custom functions

Liam Bastick on LinkedIn: #excel #newfunctions | 16 comments

“Microsoft has just announced a brand new function for Excel (Office 365 Beta / Insider version) — LAMBDA.

The power of this latest addition to the Excel family of functions cannot be overstated. This is going to REVOLUTIONISE how you build formulae in Excel, allowing you to create custom functions without code.” — Liam Bastick

John MacDougall YouTube video share on LinkedIn

“New LAMBDA Function [the Most POWERFUL Function in Excel]”

Mike “ExcelIsFun” Girvin YouTube video share

Bill “MrExcel” Jelen YouTube video share

Leila Gharani review on YouTube

Microsoft: Turning Excel into a Turing-complete programming language

Excellent article on TechRepublic by Mary Branscombe. Worth a read!

More to come!