Microsoft Excel update will give power users plenty to dig their teeth into
Microsoft Excel will soon do most of the heavy lifting for you
When you purchase through links on our site, we may earn an affiliate commission.Here’s how it works.
The desktop version ofMicrosoft Excelwill soon support a handy task automation feature previously only available to users of the web application, it has been revealed.
As per anew entryto theMicrosoft 365roadmap, an update for thespreadsheet softwarewill soon allow desktop users to program and run scripts that automate repetitive manual tasks.
“With this update, you can now create, edit, and run Office Scripts in Excel for Windows using the Code Editor and All Scripts taskpane,” explainedMicrosoft.
Microsoft Excel automation
Although the formula-phobic among us have only just about mastered the basics of Microsoft Excel, advanced users have long looked for ways to optimize their workflows, particularly when it comes to repetitive data entry tasks.
The objective of the upcoming update, which will roll out at some point in October, is to give users willing to put in the initial groundwork a platform for automating time-consuming manual tasks and improving their productivity.
The work of a single user can also help employees across an organization automate workflows; once programmed, scripts can be shared freely across Microsoft 365 accounts.
“Office Scripts in Excel let you automate your day-to-day tasks. Inside Excel, you can record your actions with the Action Recorder. This creates a TypeScript language script that can be run again any time,” explains a Microsoft support document.
Are you a pro? Subscribe to our newsletter
Sign up to the TechRadar Pro newsletter to get all the top news, opinion, features and guidance your business needs to succeed!
Microsoft Teams pricing changes will be a gift for some, but not others>Our list of the best productivity tools out there>Microsoft Outlook update will bring back much-loved retro visuals
“You can also create and edit scripts with the Code Editor. Your scripts can then be shared across your organization so your coworkers can also automate their workflows.”
The arrival of Office Scripts for the Excel desktop client represents the latest in a series of recent additions designed to help users bolster their productivity.
For example, Microsoft recently revealed it will soon be possible to launch into Excel documents from withinMicrosoft Teamscalls. Instead of tabbing out to work on a shared spreadsheet, collaborations will be able to make edits in real-time overvideo conference.
Separately, the company announced a new resizeable version of the Excel formula bar, making it much easier to work with longer formulas, as well as a feature designed to help with formula troubleshooting.
Joel Khalili is the News and Features Editor at TechRadar Pro, covering cybersecurity, data privacy, cloud, AI, blockchain, internet infrastructure, 5G, data storage and computing. He’s responsible for curating our news content, as well as commissioning and producing features on the technologies that are transforming the way the world does business.
7 myths about email security everyone should stop believing
Best Usenet client of 2024
3 reasons why PIA fell in our best VPN rankings
