The following steps show how to bulk convert negative or positive numbers. Negative numbers (-1) become positive numbers (1) Positive numbers (1) become negative numbers (-1) There are two ways…

I use Microsoft Word's mail merge feature often. It works great for connecting into a database and spitting out all sorts of documents - but it's kind of clunky when…

The steps below will show how to hide data from a pivot table based on the value. In this example we'll be hiding data where the value is 0. In…

The #DIV/0! error message means "divide by zero" - a division which is mathematically impossible, hence the error. When you see this it's because you have a formula which is trying…

If you need to create a pivot table chart on a range that includes blank rows you'll end up with a (blank) label. There are several suggested ways to remove…

Cell references in Excel formulas typically use their position in the worksheet - e.g. A2 for a single cell or A2:A4 for a range. But as formulas get more complicated…

The following formulas show how to calculate an age group from an age. This may be useful if you need to report by grouped ages instead of individual ages. The…

The following formulas show how to calculate current age from a date of birth. Calculate age in years This formula will calculate the current age in full years - for…

The following process shows how to fill missing numbers in a range. For example, if we had an excel table where the numbers 3, 4, and 6 were missing. Instead…