Office Scripts with the ability to automate routine tasks in Excel is now available on the web
Example: Let's say your workday starts with opening .csv files from the accounting page in the Excel sheet. Then you have to spend a few minutes deleting unnecessary columns, formatting the table, adding formulas, and creating a PivotTable in a new worksheet. These tasks are not difficult but daily repetition is very time consuming and boring.
For automation, you only need to record repetitive daily actions with the Action Recoder feature once. Next, you use Office Scripts to set up performing those actions daily or hourly depending on business needs.
Automating repetitive actions saves you time and effort and avoids forgetting steps. In addition, Microsoft allows you to share automation processes with others without having to teach them how.
All users with Microsoft 356 educational or commercial licenses with access to Microsoft 365 Office desktop applications will have access to the Office Scripts feature.
In fact, Office Scripts launched in 2019 on the Excel application with the ability to create scripts to automate repetitive tasks. You can even combine Office Scripts with Power Automate to create a complete day-to-day workflow between multiple Windows applications.
You should read it
- Link Download Microsoft Office 2019
- Complete guide to Excel 2016 (Part 1): Get familiar with Microsoft Excel
- Guide to full Excel 2016 (Part 2): Learn about OneDrive
- Four reasons do not need to upgrade to new Microsoft Office
- Microsoft released Gemini Office in the Fall
- How to install Word and Excel in Office 2016 only
- Microsoft Office Web Apps: Not as expected
- Test your understanding of Excel
- Set AutoSave feature in Office 2016
- How to Change the Theme on Microsoft Office
- How to automate Photoshop with Photoshop Scripts
- New points in Microsoft Office Excel 2007