Microsoft's Making Excel's 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). The Verge reports: 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 in English, and will suggest sum, average, count, counta, min, and max formulas. It's not a groundbreaking feature, to be sure -- Google Sheets has had something similar for a while, and Excel's AutoSum has long been a quick way to apply formulas to data -- but for some use cases, it could be a nice timesaver.

Then there's Formula by Example, which is similar to the Flash Fill feature that can automatically detect patterns in data and fill out the rest of a column. The feature is a bit hard to explain succinctly, but this video from Microsoft gives you an idea of what it's about; detecting a pattern where you're combing information from cells and then automatically generating a formula that will save you some typing.

Microsoft's blog post also includes several other feature announcements. There's a function for adding images with alt-text into your tables coming to Windows, Mac, and web, and the company's also adding nested Power Query data types and the ability to get data from dynamic arrays to the Insider version of the Windows app for testing. One other potentially useful (and thankfully easy to understand) feature coming to the web is 'suggested links,' which will automatically help you fix broken links to other workbooks stored in the cloud.

Read more of this story at Slashdot.