Excel remains a staple in the business toolkit, adept at facilitating quick analyses, reporting, and data entry. Beyond its prowess for on-the-fly, "back-of-the-envelope" tasks, Excel also offers …
How to refresh all Excel workbook connections with Office Scripts and Power Automate
In a previous post we explored the relationship between Power Automate and Power Query, explaining that Power Automate and Power Query serve different purposes in workflow automation and data …
How to run an Office Script on all Excel workbooks in a folder with Power Automate
In a previous post, we explored how to use Office Script to automate formatting and enhance features in an Excel workbook: But how do you extend this automation to multiple Excel workbooks? …
Office Scripts for Excel: How to share your scripts
Sharing your Office Scripts in Excel can greatly enhance collaboration and efficiency, whether you're working within your team or across different organizations. In this post, we'll explore how to …
Continue Reading about Office Scripts for Excel: How to share your scripts →
How to understand console.log() in Office Scripts for Excel
Office Scripts provide an exciting new way to automate solutions for Excel workbooks using a variant of the TypeScript programming language. As with any programming language, it's crucial to know how …
Continue Reading about How to understand console.log() in Office Scripts for Excel →
How to understand function main() in Office Scripts for Excel
If you're an Excel user aiming to streamline your workflow and that of your coworkers, Office Scripts are an exciting new tool to explore. These scripts can automate repetitive tasks, making your …
Continue Reading about How to understand function main() in Office Scripts for Excel →