How-To
How to Use PowerShell Try Catch Finally for Error Handling
A PowerShell Try Catch block is used to handle errors in PowerShell scripting. When using PowerShell Try Catch block for scripting you…
Every guide
The whole library, newest first.
How-To
How to Count Objects in PowerShell
Do you need to count objects using your PowerShell script? This guide covers several ways to do this. Overview There are so…
Explained
PowerShell Not Equal Operator: Applications, Examples
Do you want to test for negative equality in your PowerShell script? You need the Not Eqla (NE) operator and this guide…
How-To
How to Extract a PowerShell Substring From a String
I have had multiple occasions when I needed to extract sub-strings from strings in PowerShell scripts. This article is my attempt to…
Explained
Advanced PowerShell Function Explained with Examples
Do you want to take your PowerShell scripting to the next level by building functions? Come with me on this ride as…
How-To
How to Calculate Variance in Excel
Variance measures the spread between numbers in a data set. You can calculate variance in Excel using the VAR, VAR.S, VARP or…
How-To
How to Calculate Standard Deviation in Excel
Standard Deviation is a measure of how dispersed values are from their mean (average). You can calculate standard deviation in Excel with…
How-To
How to Merge Cells in Excel in 2 Easy Ways
Introduction You can merge two Cells in Excel using CONCATENATE function or the “&” (ampersand) operator. Though Excel has a merge tool,…
How-To
How to Make a Pivot Table in Google Sheets
Introduction You can make a Pivot Table in Google Sheets to simplify analysis of complex data. A Pivot Table allows you to…