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