Power-Query-Editor-Microsoft-Excel
Power Query Editor

Like all Office apps, Microsoft Excel is on a treadmill of consistent updates and features. New tools are available regularly. With September coming to a close, Microsoft is rounding up all the new abilities that came to the spreadsheeting app during the month.

On Excel for the web, Microsoft has brought the ability to “Check Performance”. With this feature, Microsoft Excel will automatically find problems in formatting inside a project that may be causing performance issues for the app. Users can then apply recommendations for actions that the tool will then use to optimise the workbook.

This solution is available from Review > Check Performance.

Also on Excel for the web, it is now possible to share parts of a workbook. This is possible by highlighting required cells instead of simply sharing a whole project.

Other Changes

Over on Microsoft Excel for Windows, Modern Comments are now available in preview for Insiders on the Beta Channel. This integration brings more consistent commenting on the app. Microsoft says Modern Comments were built on the React Native framework.

Excel for Mac now has the Power Query Editor available within the app. Currently available in preview on the Insider Program. Furthermore, the ability to manage storage account like the Office for Mobile version of the app.

In other Microsoft Excel news, Microsoft has recently brought collaboration integration to Excel Live in Microsoft Teams. Thanks to this integration, users have tools to navigate documents and remain in meetings on Teams.

Microsoft also announced plans to bring Task Automation to Excel during October. This is possible by integrating Office Scripts into the desktop version of the app. Office Scripts are incredibly useful for large spreadsheets with loads of repetitive tasks.

Tip of the day: For the most part, Windows apps are stable, but they can still be still thrown out of whack by updates or configuration issues. Many boot their PC to find their Microsoft Store isn’t working or their Windows apps aren’t opening. Luckily Windows 11 and Windows 10 have an automatic repair feature for apps that can resolve such issues.