Excel 365: The Subtle Art of Overcomplicating LAMBDAs | Marco Filocamo

In this meetup, we welcome my friend Marco Filocamo, a passionate Excel trainer and consultant.

Description: You create a convoluted formula that gets the job done. You wonder—should this become a LAMBDA? Like that box of electrical cables in the basement covered by dust, you cannot miss the opportunity to create one “just in case this specific need arises again in the future.”

Dive into the labyrinthine world of Excel 365 with us as we explore the most comprehensive Excel function ever created. Friend or foe? Let’s discover it together by taking inspiration from training courses and consulting projects. If you like to overcomplicate your workbook to craft fantastic functions that none of your peers would care about, you cannot miss this one.

This is an online event and starts at 18:00 GMT + 1.

Join London Excel Meetup Events

Learn more Excel and Power BI

#powerquery #excel #londonexcelmeetup

[CraigHatmakerBXL]

Great presentation, Marco. Thanks for the shoutout. 😎

[sktneer]

Hurray! Alan is the new king of the United Kingdom. Thanks to LAMBDA!😊

[aquetongmedia]

I am trying to use LAMBDA to create an option implied volatility calculator, which is basically the replacement of a goal seek. Many / all the of the in depth LAMBA example videos on Excel involve text manipulation, which is not of interest to me. Any place to go to for more numerical centered examples?

[peterbartholomew]

I seem to have failed to subscribe somewhere along the line. I would have loved to attend this. For me any formula is a potential Lambda that has failed to dress properly, ready to be presented to the world. Without a named Lambda to wrap it, there is no 'statement of intent' to tell the user what it attempts to achieve.

Any Lambda function is 'just' programming and complexity versus over-simplicity is basically a balance to be struck with every formula and function. The Microsoft Excel development team must face this dilemma every time they release a new function. And then I bitch about the shortcomings