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

Skip to content
## Office 2016

## 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 – How to have pivot chart show only some columns

## How to export Outlook auto-complete to Excel list

## Outlook 2013/2016 – Where is the auto-complete list stored?

## Microsoft Office version numbers

## Word 2013 – How to enable the page ruler

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 steps show how to create a pivot table and chart that has two values (value and percent of total) but the chart only displays one value. This process…

In Outlook when you send an email the address is remembered and added to an 'auto-complete' list. The next time you type the email address into the 'to' field (as…

The file that stores the auto-complete list can be found in the user profile using this path: %USERPROFILE%\AppData\Local\Microsoft\Outlook\RoamCache This will translate to something like C:\Users\UserName\AppData\Local\Microsoft\Outlook\RoamCache

The following table shows the version number for the last few versions of Microsoft Office. This is useful if you need to identify the installed version of Office using the…

Unlike previous versions of Microsoft Word, the on screen page ruler is not enabled by default. To enable it you need to open the 'VIEW' menu in the ribbon and in…