Washington [US], December 28 (ANI): American tech giant Microsoft has announced that they are making Excel's autocomplete even smarter, at least in the web version that comes with Microsoft 365.

According to The Verge, an American technology news website, the company unveiled formula suggestions and formula by example last week. These two features may help automate various tasks that were previously required to be done manually.

Also Read | What is Your Favorite Era of All Time? – Latest Tweet by Pop Base.

The idea behind formula suggestions is very straightforward: whenever you enter the equals sign in a cell, Excel for Web will attempt to propose an appropriate formula based on the data that's around it.

For instance, Excel can suggest adding the range of cells if you have a column at the end of your spreadsheet named "total" and a row full of quarterly sales data, reported The Verge.

Also Read | Will Lionel Messi Play Tonight in PSG vs Strasbourg, Ligue 1 2022-23 Clash? Here's the Possibility of the Star Footballer Making the Starting XI.

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.

Then there's Formula by Example, which is similar to the Flash Fill feature that can automatically identify patterns in data and fill out the remaining columns.

Microsoft's blog post also includes several other feature announcements.

For testing purposes, the company is also bringing nested Power Query data types and the capability to access data from dynamic arrays to the Insider version of the Windows programme, in addition to a feature that will allow you to add photos with alt-text to your tables for Windows, Mac, and the web.

As per The Verge, another potentially useful web feature is "suggested links," which will automatically assist you in fixing broken links to other workbooks stored in the cloud. (ANI)

(The above story is verified and authored by ANI staff, ANI is South Asia's leading multimedia news agency with over 100 bureaus in India, South Asia and across the globe. ANI brings the latest news on Politics and Current Affairs in India & around the World, Sports, Health, Fitness, Entertainment, & News. The views appearing in the above post do not reflect the opinions of LatestLY)