Microsoft Excel''s desktop version will soon include a handy task automation tool previously available to web users, according to the report.
As per a fresh entry into the Microsoft 365 roadmap, a new update for the spreadsheet software will soon allow desktop users to program and execute scripts that simplify repetitive repetitive task.
With this update, you may now create, modify, and run Office scripts in Excel for Windows, using the taskpane for Code Editor and All Scripts.
Microsoft Excel automation
Although the formula-phobic among us has just mastered the basics of Microsoft Excel, advanced users have long sought ways to improve their workflows, especially when it comes to repetitive data entry tasks.
The aim of the next update, which will begin at some point in October, is to provide to users willing to enter the initial stage a platform for automating tedious manual tasks and improving their productivity.
Employees across the organization may be able to automate workflows as well as the work of a single user; once programed, scripts may be freely shared across Microsoft 365 accounts.
Office Scripts in Excel allow you to automate your day-to-day tasks. Inside Excel, you can record your actions with the Action Recorder. This creates a TypeScript language script that may be renewed anytime, according to a Microsoft support document.
With the Code Editor, you may also create and edit scripts. Your scripts can be then shared across your organization, so that your coworkers may also automate their tasks.
The introduction of Office Scripts for the Excel desktop client represents the most recent feature in a series of recent enhancements designed to assist users improve their productivity.
Microsoft recently revealed that it will soon be possible to launch into Excel documents from within Microsoft Teams calls. Instead of stoking out to work on a shared spreadsheet, collaborations will be able to make edits in real-time over a video conference.
A new resizeable version of the Excel formula bar has been announced by the company, making it much easier to use longer formulas, as well as a feature designed to assist in formula troubleshooting.