In the direction of the top of every month, Microsoft publishes a changelog of all the brand new options it added to Excel and Groups within the earlier 4 weeks. The corporate already launched an inventory of capabilities it added to Groups in January 2023 yesterday, and at this time it did the identical for Excel.

Beginning with Excel for the online, we’ve got a single function that has been extremely requested by prospects. That is the flexibility to show the supply information of a worth cell in a PivotTable. That is particularly helpful when you spot a worth that appears misplaced in a PivotTable and need to discover the underlying information additional. Now you can do that by double-clicking the cell or right-clicking on it and clicking “Present Particulars”. It will open a brand new sheet with extra particulars concerning the cell so you’ll be able to confirm the numbers and calculations.

Relating to Excel for Home windows and Excel for Mac, we’ve got Same change log to each of them. Workplace scripts can now be automated utilizing Energy Automate by leveraging a devoted “Automation” tab. That is one thing we already lined intimately a couple of weeks in the past.

In the meantime, for Insiders, there are two new capabilities on Home windows and Mac. The previous makes automation even simpler. As an alternative of writing Workplace scripts by way of JavaScript or TypeScript, you’ll be able to merely use the “report actions” performance, which does precisely what it says on the tin. You possibly can navigate and carry out actions within the UI your self and the script to imitate your actions can be mechanically generated within the backend. The opposite Insider function is comparatively minor and provides a tooltip for validating your parameters in an Excel formulation.

Whereas the changelog is actually not as intensive this time round, there are actually some productiveness enhancements that may possible be appreciated by these seeking to automate monotonous workbook actions.