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 →
How to get started with Power Automate for Excel
As an Excel user, you likely engage in routine workflows week after week. Perhaps you need to consolidate files from a specific email into a folder each week, create approval workflows for budgets and …
Continue Reading about How to get started with Power Automate for Excel →