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.

But have you ever thought that these casually dragged formulas are actually "writing code"? The driving force behind turning ...

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

<br><br>If that's not clear, here's a screenshot of what I mean. I happen to be viewing that in Excel 2007 but they're using E2k3. This grouping/"outline" is an Excel thing.<br><br>This was generated ...

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

I've been working on a Windows Scripting Host/VBS script to grab some logfiles from disparate remote servers, and then dissect/parse/report those logs into an Excel spreadsheet. (roll your own ...

AI isn't changing everything. Spreadsheet whizzes are still competitive in the current job market.