Microsoft says that it is bringing a powerful new feature to the Excel spreadsheet app on Windows and Mac. Microsoft Excel users on those platforms (desktop apps) will get a new Automate tab. This section makes it much easier to handle repetitive tasks on the app.
According to the company, Automate in Microsoft Excel offers the ability to set up automation for repetitive tasks without needing programming knowledge.
You may remember that Microsoft first put this ability into the Microsoft 365 Roadmap in September. A new Record Action button helps to convert recorded actions into a script that can be used across workbooks.
Office Scripts are incredibly useful for large spreadsheets with loads of repetitive tasks. That makes them popular for workplace projects where organizations can automate day-to-day spreadsheeting tasks.
Windows and Mac Excel users that repetitive spreadsheet tasks will be handled automatically. Users can edit, create, and run Office Scripts in Excel via the Code Editor and All Scripts pane. Of course, users can continue to input tasks manually if they want.
To access the feature you will need a Microsoft 365 Education of E3/E5. On Windows, you will need to have Microsoft Edge WebView2.
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. Furthermore, it is also possible to carry on with individual workloads or link to others on a document.
Tip of the day: Tired of Windows´s default notification and other system sounds? In our tutorial we show you how to change windows sounds or turn off system sounds entirely.