Making the most out of Microsoft Excel could 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 with Microsoft's latest announcement on December 3, things are set to get easier.
- Check out our list of the best productivity tools out there
- Office 365 vs G Suite: Which is the best office software?
- Here's our list of the best accounting software right now
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.
To create your own customized functions or recursions you'll need to sign up to the Microsoft Office Insider program and select the Beta Channel to get early access to LAMBDA, and this is available on Microsoft Windows and Mac builds of Excel.
You can also post feedback from your experience to the Excel Tech Community, to help improve and develop these new Excel features as they're being rolled out.
- Here's our list of the best Microsoft Office alternatives available
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.