Microsofts making Excels formulas even easier

Microsoft has announced it’s making Excel’s autocomplete even smarter, at least in the web version that comes with Microsoft 365 (formerly known as Office 365). Last week it announced formula suggestions and formula by example, both of which may help automate some things that you had to do manually.

Formula suggestions are pretty much what they say on the tin: if you type the equal sign into a cell, Excel for web will try to intelligently suggest what type of formula you should be using, given the data that’s around it. For example, if you have a full of quarterly sales numbers and a column at the end labeled “total,” Excel might suggest summing the range of cells. According to a blog post from Microsoft, the feature currently only works...

Continue reading…