## 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…

Skip to content
## Excel

## Excel – How to convert negative/positive numbers

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

## Excel 2016 – How to filter pivot table data

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

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

## How to create named cell references in Excel 2016

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

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

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

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…