So far in this series, we have looked at querying systems using WMI to pull the drive space and then spent some time looking at sending that data to a SQL server database where it can be saved for ...

Sometimes you need to scan some files for a piece of data like a string, phrase or some number, and one of those files just happens to be an Excel spreadsheet. You could open up the file, launch the ...

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 Office's Excel application allows users to store, model and manipulate data sets. Excel spreadsheets organize this data into worksheets, each with a number of rows and columns. Each row or ...

Viewing the distribution of related values from one entity to another is a frequent request, and that’s where Microsoft Excel floating bar charts can help. Instead of starting from the X axis, the low ...

How to Hide and Handle Zero Values in Excel Charts Your email has been sent Charted zero values can have unintended results you can easily miss. Here are a few techniques you can use to hide and ...