Tag Archives: excel

Quick Hits: Adding a Hyperlink to Excel Spreadsheet

I had a need a while back to add a few hyperlinks to a couple different excel cells that could be clicked on to take the user either to another portion of the excel spreadsheet or to open up a … Continue reading

Posted in powershell | Tagged , , | Leave a comment

Trend Reporting using PowerShell and SQL on MCPMag.com

I have a new series of articles that will be focusing on trend reporting using PowerShell and SQL. Be sure to check them out and let me know what you think! PowerShell Trend Reporting, Part 1: Data Gathering PowerShell Trend … Continue reading

Posted in powershell | Tagged , , , , | 4 Comments

PowerShell and Excel: Adding a Chart and Header Filter to a Report

In the previous articles I have shown you how to use Excel with PowerShell to make a nice disk space report, complete with color coded rows for disks that are running low on space. I am now going to take … Continue reading

Posted in Excel, Office, powershell | Tagged , , , | 13 Comments

PowerShell and Excel: Adding Some Formatting To Your Report

Continuing from my previous Excel article, I will now take the report that I created and make more pleasant to the eyes and really show why this is different from just piping the output into Export-CSV to a CSV file. … Continue reading

Posted in Excel, Office, powershell | Tagged , , | 12 Comments

PowerShell and Excel: Creating Your Initial Report

One of the most common methods to generating a report (at least for me) is to write out the data to a CSV file using Export-CSV. While this is a simple and effective method of getting most data out to … Continue reading

Posted in Excel, Office, powershell | Tagged , , , , | 21 Comments