Whether your company uses Excel for payroll and accounting purposes, project management or data collection, being able to automate common processes is hugely beneficial. Excel features a macro ...

The recent integration of Python into Microsoft’s Excel spreadsheet software has opened up a new realm of possibilities for data analysis and manipulation. This article aims to provide a comprehensive ...

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 ...

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 ...