Microsoft’s making Excel’s formulas even easier

Illustration of Microsoft’s Windows logo
It’s only a matter of time before Excel can take over my job. | Alex Castro / The Verge

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…



source https://www.theverge.com/2022/12/27/23523281/excel-formula-suggestions-by-example-microsoft-365

Comments

Popular posts from this blog

In a world first, China lands a spacecraft gently on the Moon’s far side

Snap suspends two anonymous messaging apps after cyberbullying lawsuit