A handy new tool for making it easier to use Excel functions, and therefore reduce mistakes
Microsoft has recently released "Formula Arguement Assistance" into Excel for the web.
This helpul new feature pops up a formula reference card when you start to write a function:
As well as walking you thorugh the function syntax as you write a formula it also highlights the relevant argument when you are editing a formula:
The card can be minimised back to just the core function syntax if you don't need assistance with the function.
[Images from Micosoft Tech Community post]
This feels like another great addition to Excel. Anything that can make the writing of formulae easier for Excel users, and thus reduce the risk of error, can only be a good thing.
The "Formula Arguement Assistance" feature is currently only available in Excel for the web. It will be added to Excel desktop versions.
See the full article from the Microsoft Tech Community here.
This series of articles focuses on new features soon to be released on Excel. This is based on announcements by the Microsoft Office Insider team.
See other articles in our Future of Excel series here.