The following formulas show how to calculate the difference between two dates. The difference can be measured by: days months years days - ignoring years days - ignoring months and…

Word has a handy keyboard command which allows you to change the text case of selected text. It allows you to switch between uppercase, lowercase and title case. To use…

The following keyboard commands can be used to display merge tags. How to show a specific merge tag Select the merge tag and press Shift + F9 How to show all…

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…

Problem When copying and pasting a table in Microsoft Word, the pasted table seems to not appear. When looking closer you see it was pasted exactly on top of the…

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…