Excel now lets users create custom functions with LAMBDA

[Karlston]

Excel now lets users create custom functions with LAMBDA

 

Microsoft has been releasing some major updates for Excel recently, such as support for custom data types. Today, another one is making its way to Office Insiders in the Beta channel. Microsoft has announced LAMBDA, a new feature in Excel that allows users to create custom functions based on Excel formulas.

 

Until now, it was possible to create custom functions in Excel, but only by using other languages such as JavaScript. LAMBDA allows functions to be created using the Excel formula language, and they can then be saved under custom names, making them reusable. On top of that, the functions support recursion, meaning that a function can call itself in its definition. This was only possible in Excel by using scripts, such as VBA or JavaScript.

 

There are a few benefits to this approach, according to Microsoft. For one thing, using a saved custom function means that, should you find an error in the formula, you can fix the function, and that will fix the result for every cell where the function is used. It can also be easier to read for those that didn't create the formulas, because functions can be identified by names, thus it's easier to understand their purpose.

 

Recursion is also useful because it allows formulas to automatically update when necessary. A function can call itself if a change is detected in the data, updating the result of the function based on those changes. As an example, Microsoft uses the following GIF to demonstrate how recursion keeps the resulting cells updated to offer the desired result.

 

Of course, these formulas support more than just text and numbers, and they can be used with data types like locations, and they also support dynamic arrays.

 

This feature is only available in the Beta channel of the Office Insider program for now, and it's not clear when it will roll out to more users.

 

 

Excel now lets users create custom functions with LAMBDA

[BimBamSmash]

<Joke Mode Enabled>

 

That inverted "Y"....

 

Ah, I recognize it now! Ain't that the good, old Lagrange multiplier from my youth's optimization courses, here to haunt me once more? I missed ya, buddy. You sure gave me a hard time at college though (*trembles in fear*). So I don't see you again for, what, twenty years, and then you pop up in the form of a marketing term for a feature in a spreadsheet software? The years haven't been terribly kind? What was the point of you in all those nasty compulsory modules at college, again?

 

<Joke Mode Disabled>

 

Okay, wow. Used to get asked to make Macros for stuff like this in the past, I think. (and you'd think your company's Finance folks should be on top of Excel already. But nooooo, anything to do with computers and coding is for the IT guy.)

 

The Ability to write VBA scripts used to be a part of the job for many vacancies. The way MS is going about it though, they are making those pretty pointless with each and every one of these upgrades of theirs. I won't complain, I'd prefer to use this Lambda thing over Macros myself, but things like this are making "winning" skill sets harder to build, and Jobs even harder to land.

 

I mean, come to think of it, stuff like Machine Learning used to be hardcore computer science $h!t, limited to a few job titles and positions, aimed at absolute nerds. But nowadays it's popping up in so many job descriptions, as if i is basic asthmatics or ICDL. Scarrrrrry.