Automate tasks in Excel Desktop

The Automate tab is growing beyond your web browser and onto your desktop! Starting today, the Automate tab is now available for all eligible users in Excel for Windows and Mac. Previously, this tab was only available in Excel on the web.

With this new tab, create and modify scripts that automate your repetitive tasks using Office Scripts. Enhance your workbook by connecting popular applications like Microsoft Teams or SharePoint to build workflows with Power Automate. Combine these productivity technologies to have Power Automate schedule your Office Script. This tab represents the first stage of uniting automation solutions across platforms.

https://techcommunity.microsoft.com/t5/excel-blog/automate-your-tasks-with-the-automate-tab-now-in-excel-for/ba-p/3705856

Damien Bird has a lot of great content on the topic of Office Scripts

“I’ve got 15 videos on my Office Script playlist https://lnkd.in/dchNDWz and I share a few different Excel Automation tips and tricks in the following post https://lnkd.in”