Microsoft Excel is finally making formulas smarter, and easier
Users now have less of an excuse to use formulas in Microsoft Excel
When you purchase through links on our site, we may earn an affiliate commission.Here’s how it works.
MicrosoftExcel hasannounceda handful of changes that are set to make formulas easier to use and even more powerful.
Thespreadsheet softwareupdates are centered around web users, which covers allMicrosoft 365(formerly Office 365) users, even those without access to the full desktop clients, with a few updates padding out the list of Windows and macOS client features, too.
The first change for web users is the introduction of formula suggestions, which takes into account contextual data to suggest a handful of supported formulas, including SUM, AVERAGE, COUNT, COUNTA, MIN, and MAX.
Excel formula suggestions
For now, it will only be available to accounts set up in English. Microsoft hopes this will not just save its users time, but allow them to “learn more about Excel formulas as [they] use them.”
The second major change is what the company calls formula by example, and resembles a type of autofill. After a user completes a series of similar entries, the web version of Excel can now suggest content for remaining cells based on their previous actions.
We’ve also featured the best online collaboration software>Microsoft Excel has unveiled an absolutely mind-blowing new feature>Microsoft Excel threats could be a major security risk to your business
Further improvements to the way Excel can now handle data include a tool that can detect broken cloud workbook links so that the data in your spreadsheet remains up-to-date and functioning, and a new search bar in the queries pane for quicker navigation.
Finally, Excel web now supports images inside cells, whereas they previously floated on top of the sheet: a change that was first spotted on the company’sroadmapin early November 2022. Pulling an image from a source location brings metadata like alternative text, too. This is now available on Windows and macOS versions of the Excel desktop client, too.
Are you a pro? Subscribe to our newsletter
Sign up to the TechRadar Pro newsletter to get all the top news, opinion, features and guidance your business needs to succeed!
According to the blog post, the features are rolling out which means that some users may not be able to use the updates just yet, and some features are just reserved for Windows Insiders.
With several years’ experience freelancing in tech and automotive circles, Craig’s specific interests lie in technology that is designed to better our lives, including AI and ML, productivity aids, and smart fitness. He is also passionate about cars and the decarbonisation of personal transportation. As an avid bargain-hunter, you can be sure that any deal Craig finds is top value!
7 myths about email security everyone should stop believing
Best Usenet client of 2024
Your doctor may have an AI assistant taking notes during your next Zoom call
