Microsoft adds 14 new functions to Excel and more in August

As we approach the end of the month, Microsoft has rounded up the new features it added to Excel in August. These summaries include features for Stable Channel users, as well as Insider Channels, and they cover all the platforms Excel is available on. One of the highlights of this month is the general availability of 14 new functions, mainly focused on text manipulation and dynamic tables.

Starting with these new features – which are available on the web, Windows, macOS, and mobile versions of Excel – they’ve been available to Insiders since March, but are now rolling out to everyone. Two new functions are TEXTBEFORE and TEXTAFTER, which allow you to output text from a cell only up to or from a specific point, simplifying the information they contain. There is also a TEXTSPLIT function that allows you to split text from one cell into two or more cells.

Other functions are related to dynamic tables, which are also a relatively new feature of Excel. These new functions let you combine, reshape, or resize tables, so you can organize your data in a way that’s easier to understand.

Other than that, the bulk of the changes seem to be in Excel for the web. The most significant changes include support for editing spreadsheets with legacy shared workbook functionality, as well as legacy data connections. Excel for the web now also supports Power Queries for groups, and you can also create PivotTables that link directly to Power BI datasets. This last feature is also available in Excel for Windows if you’re in the Office Insider Beta channel.

The web version of Excel also has a multi-line formula bar and supports rich text formatting in cells, so you can only apply formatting changes to specific parts of it. ‘a cell. Microsoft has also made it easy to remove data series from a chart by simply clicking on the data series and pressing the backspace key on your keyboard. Finally, you can also now sort rows by color or by icon.

On other platforms, most changes are exclusive to Office Insiders. If you are in the current channel preview on Windows, you can also use the new Show Changes which allows you to see the history of changes made to the entire workbook.

A screenshot of an Excel spreadsheet where one cell contains a link to an image file, and another cell uses the IMAGE function to display that image.

On Windows, macOS, Android, and iOS, you can now display images directly in a cell using the new IMAGE function to link to an image asset, while in the beta channel.

And that’s about it for the new Excel features that Microsoft added in August. If you’re not an Office Insider, most of these features will likely be available in a month or two, but we’ll have to wait to be sure. Of course, as we mentioned, the new features of Excel on the web are now available to everyone.


Source: Microsoft