Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.

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

In Part 1 of this blog, we looked at the way that Excel can help generate an equation that describes a curve based on collected data. Then, that curve can be linearized. We left off noting that the ...

Microsoft Excel, part of the Office software suite, allows you to create business-oriented worksheets composed of columns, rows and cells. Within these containers, characters – including special ...

Excel, part of Microsoft Office, is a spreadsheet application used for almost infinite projects. Individuals often use Excel in the home for organizing personal data. Business incorporate Excel for ...

If you get the You can’t change part of an array error in Microsoft Excel, this post will help you fix the error. An array is essentially a collection of items ...

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.

In the first part of this blog, Using Solver in Excel, Part 1, we started looking at what we can do with the Solver add-in to the Excel spreadsheet program. We looked at using Solver for the design of ...