Inserting rows and columns in pivot tables
There are five different ways to insert rows or columns into a pivot table. This article explains them all.
Excel formula to get working days between two dates excluding holidays
This article shows you how to calculate the number of working days between two dates in Excel using the NETWORKDAYS function.
Applying a unique constraint in Excel
This article shows how to impose a unique constraint in Excel, preventing duplicate items from being accidentally entered.
Remove dashes from ssn, keep zeros
This article shows you how to remove dashes from social security numbers by using Excel’s SUBSTITUTE function, with a downloadable example.