Near the end of each month, Microsoft publishes a changelog of all the new features it added to Excel and Teams in the four weeks prior. The firm already released a list of capabilities it added to Teams in January 2023 yesterday, and today, it has done the same for Excel.
Starting with Excel for the web, we have a single feature but one that's been highly requested by customers. It is the ability to view the source data for a value cell in a PivotTable. This is especially useful if you spot a seemingly anomalous value in a PivotTable and want to investigate the underlying data further. Now you can do so by double-clicking the cell or right-clicking it and pressing "Show Details". This will open a new sheet with more details about the cell so you can validate the numbers and the calculations.
Coming over to Excel for Windows and Excel for the Mac, we have an identical changelog for both. Office Scripts can now be automated through Power Automate by leveraging a dedicated "Automate" tab. This is something we already covered in detail a few weeks ago.
While the changelog certainly isn't as extensive this time around, there are certainly some productivity enhancements that will likely be appreciated by those looking to automate monotonous workbook activities.
0 Comments - Add comment