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

In my previous post, I showed you how to create a clickable button in Excel. That button displayed a simple message box. Now, I want to show you how to use the button to kick off 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 ...

A virtual currency mining script is embedded immediately by exploiting the JavaScript custom function added to Excel Microsoft announced May 7, 2018 that adding JavaScript custom functions to Excel ...

I have a set of spreadsheets where the data (text) is color-coded by row. Would it be feasible to write a formula or script to count how many of what color rows are spread across the workbooks in my ...

Y Combinator Winter Summer 2012 graduate Data Nitro (formerly known as IronSpread) has a simple proposition: it enables you to to use the popular programming language Python in Microsoft Excel. The ...