Microsoft Excel update could change the way you build formulas forever
LAMBDA beta allows you to create custom functions in Excel, Microsoft says
When you purchase through links on our site, we may earn an affiliate commission.Here’s how it works.
Making the most out ofMicrosoft Excelcould get a lot easier thanks to a new upgrade from the software giant.
The process of learning how to effectively use a spreadsheet isn’t exactly what we would call beginner-friendly, but withMicrosoft’s latest announcementon December 3, things are set to get easier.
The new LAMBDA feature will allow you to create your own customized functions usingMicrosoft Excel’s formula language, removing the need to write them in a programming language like JavaScript.
Custom re-usable functions
Confused? What this will mean for many office users is that you can take any formula you’ve built in Excel, wrap it up in a LAMBDA function, and give it a name (for example =GETLOCATION as below). If your role requires you to perform repetitive formulas, this will streamline your spreadsheet process without you having to resort to copy and paste, or recording macros.Reusable functions are reason enough to get excited for the new possibilities of Excel, but there’s another interesting advantage to LAMBDA: you can do recursion, repeating over a set of logic at a dynamically defined interval. This is something that was only previously possible in Excel through manually running a script like VBA or JavaScript.
To create your own customized functions or recursions you’ll need to sign up to theMicrosoft Office Insider programand select the Beta Channel to get early access to LAMBDA, and this is available onMicrosoftWindows and Mac builds of Excel.You can also post feedback from your experience to theExcel Tech Community, to help improve and develop these new Excel features as they’re being rolled out.
ViaMSPowerUser
Are you a pro? Subscribe to our newsletter
Sign up to the TechRadar Pro newsletter to get all the top news, opinion, features and guidance your business needs to succeed!
Jess is a former TechRadar Computing writer, where she covered all aspects of Mac and PC hardware, including PC gaming and peripherals. She has been interviewed as an industry expert for the BBC, and while her educational background was in prosthetics and model-making, her true love is in tech and she has built numerous desktop computers over the last 10 years for gaming and content creation. Jess is now a journalist at The Verge.
Best secure file transfer solution of 2024
Best lightweight Linux distro of 2024
New No Man’s Sky PS5 Pro details reveal 8K support
