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…
Office 2013
Word 2016 – Fix random list items indented
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 2016 – How to change text case
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…
Word 2016 – How to show merge tags
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…
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…
Word – Table won’t paste in new location
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…
Word – how to mail merge many records to individual documents
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…
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…
Excel 2016 – Fill in missing numbers in a range
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…