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!
Liam Bastick on LinkedIn: #excel #newfunctions | 16 comments
BUILDING CUSTOM FUNCTIONS WITH LAMBDA Sorry it's so late in the day, but here is some great reading for the…
“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
Excel might be the world's most widely used programming language; Microsoft is on a journey to turn it into a better and…
Excellent article on TechRepublic by Mary Branscombe. Worth a read!