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…
Problem By default bullet and numbered lists have a 'tab' indent before each item. However, this can be customised on a per-item basis. Often this is done in existing documents…
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…
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…
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…
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…