We're going to build off my previous series to show how to further the communication channel between Excel and PowerShell. In a recent series of posts, I explained how to launch a PowerShell script ...

Within Power Automate, it has been possible to run scripts in Excel using the Run Script action. Did you know that there is a Run Scripts from SharePoint library action too? Office scripts are similar ...

Let’s be honest— Microsoft Excel is a powerhouse, but it can also feel like a time sink. Whether you’re formatting endless tables, sorting mountains of data, or generating the same reports over and ...

Microsoft recently announced that they are adding a feature to Excel that will allow Python code to be embedded and used for advanced analytics. That made me wonder if it might be possible to create ...