How-To
How to Make a Pivot Table in Excel
Ever wondered if Excel has tools you can use to analyze relationships between large sets of data? Yes, it does and this…
Every guide
The whole library, newest first.
Explained
RAID 3 (Redundant Array of Independent Disks) Explained
What is RAID 3? RAID 3 is a RAID implementation that uses striping with a dedicated parity disk. Data is striped into…
Explained
RAID 5 vs RAID 6 Compared: Which is the Better RAID?
Do you want to know which is better between the RAID 5 and RAID 6 disk arrays? To find out you’re welcome…
How-To
How to Concatenate Columns and Strings in Excel
Do you want to join data in Excel? You need the Concatenate function and in this guide, I’ll show you how to…
How-To
How to Sum in Excel with Examples
There are different ways to add numbers in Excel. You could simply select the cells containing the data. Use AutoSum or Excel…
How-To
How to Count in Excel with Examples
Excel COUNT Function is used for counting items in a worksheet. Excel COUNT also has the conditional function, COUNTIF. COUNTIF counts if…
Explained
Powershell.exe Command: Syntax, Parameters, and Examples
As you progress in your PowerShell scripting skills, you soon realize that you need to use Powershell.exe Command. In this Itechguide, you…
How-To
How to Move Columns to Rows and Rows to Columns in Excel
If you receive some Excel data in columns, you can easily move the columns to rows in Excel with paste special, transpose.…
How-To
Excel “Not Equal” Comparison Operator: Syntax, Examples
Excel “Not Equal” is a Comparison operator that compares two values. “Not Equal” will return TRUE if the values are NOT equal.…