## Excel – How to convert negative/positive numbers

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…

## Word – how to mail merge many records to individual documents

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…

## Excel 2016 – How to filter pivot table data

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…

## Excel 2016 – What is #DIV/0! error and how to fix it?

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…

## Excel 2016 – How to exclude (blank) values from pivot table

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…

## How to create named cell references in Excel 2016

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…

## Excel 2016 – Formula to calculate age group from age

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…

## Excel 2016 – How to calculate age from date of birth

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…

## Excel 2016 – Fill in missing numbers in a range

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…