## How to use ipconfig /display dns to view internet history

Did you know Windows 10 keeps a record of the websites you view? It doesn't matter which browser you use, if you use "in private" or "incognito" mode, or if…

## Excel 2016 – How to select smallest of multiple dates

The following examples show how to use an Excel formula to select the smallest date from a table. This may be useful where you have a table with duplicate information,…

## Excel wont allow insert new rows

Problem In an Excel document, you're unable to insert a new row. The 'Insert' option is greyed out. Solution This issue generally happens for two reasons - the document is…

## Excel 2016 – How to force a value in a formula

Problem One of the more frustrating features in Excel is its ability to automatically change a cells format - based on it's content. For example - a cell a currency…

## How to calculate percent of total using Microsoft Excel

In these examples we're going to show how to calculate the percent of a total using Microsoft Excel. The basic formula to do this is Part / Whole = Percent…

## Excel – How to calculate days until, between or after dates

The following Excel formulas show how to calculate the number of days for: Days until date Days between dates Days after date Days until date This formula shows how to…

## Excel 2016 – How to edit worksheet header/footer

The following steps show how to edit a worksheet header/footer in Microsoft Excel. With the Excel document open, click on 'View' in the ribbon In the 'Workbook Views' group click…

## Office 2016 – How to reset activation grace period

If you've over used a trial install of Office you'll find that it goes into a limited usage mode - basically making it so documents are read only and not…

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