Skip to content
Last updated: Monday, 19 October 2020
Formatting documents in Word can be extremely frustrating. Often Word completely disregards the ‘repeat header row’ setting – leaving you...
The following steps show how to use a footnote in Word 2016 twice – using a “cross-reference”. To insert a...
If you need to create a pivot table chart on a range that includes blank rows you’ll end up with...
The following steps show how to remove the link between a Word document and a mail merge data source. When...
Problem When running a mail merge in Microsoft Word some merge fields change format. For example, the font or size...
Problem: When Microsoft Outlook is connected to an Exchange server it prompts for a username and password. When your username...
I use Microsoft Word’s mail merge feature often. It works great for connecting into a database and spitting out all...
The following steps show how to create a pivot table and chart that has two values (value and percent of...
Problem When updating an Excel spreadsheet, formulas do not update automatically as values are entered or updates. Instead – the...
In Outlook when you send an email the address is remembered and added to an ‘auto-complete’ list. The next time...
The following formulas show how to calculate an age group from an age. This may be useful if you need...
Problem When copying and pasting a table in Microsoft Word, the pasted table seems to not appear. When looking closer...
By default, when you open an attached image in Microsoft Outlook you are unable to use the rotate buttons, this...
By default when saving a CSV file in Excel, each column will be separated using a comma as the delimiter...
The following steps show how to remove empty rows from an Excel spreadsheet using Excel 2016. Note: this process does...
The following table shows the version number for the last few versions of Microsoft Office. This is useful if you...
The following steps show how to remove empty columns from an Excel spreadsheet using Excel 2016. Note: this process does...
One of the many subtle changes in Office 2013 is removing the split window option from the toolbar in Word...
Problem When viewing emails in Outlook, embedded images do display. Instead a square and a red X are seen. Solution The...
If you’ve over used a trial install of Office you’ll find that it goes into a limited usage mode –...
The following steps show how to split comma separated values from one column into many. In this example we’ll focus...
By default images added inside Word documents are not compressed, this can result in documents with embedded images getting extremely...
The following steps show how to add ALT text (alternative text) to images using Word 2016. The process is different...
When Outlook is misbehaving – perhaps loading slow or a feature isn’t working as it should one of the first...
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...
The following steps show how to edit a worksheet header/footer in Microsoft Excel. With the Excel document open, click on...
The following formulas show how to calculate current age from a date of birth. Calculate age in years This formula...
Outlook has always been missing one important feature – the ability to see which folder an email is stored in....
Microsoft Word has the ability to restrict a document so only existing styles can be applied to content – with...
The following steps show how to recover an unsaved document in Word 2016. Open Word 2016 At the bottom left...
Unlike previous versions of Microsoft Word, the on screen page ruler is not enabled by default. To enable it you...
The following keyboard commands can be used to display merge tags. How to show a specific merge tag Select the...
Inserting a video into a PowerPoint slideshow allows you to create a single presentation file without having to keep the...
Word has a handy keyboard command which allows you to change the text case of selected text. It allows you...
The following steps show how to set an embedded video to automatically play when the slide is loaded. If you...
Problem Any Word document opened that has merge fields – displays the full merge field code. For example, a field...
The steps below will show how to hide data from a pivot table based on the value. In this example...
The #DIV/0! error message means “divide by zero” – a division which is mathematically impossible, hence the error. When you see...
The following formulas show how to calculate the difference between two dates. The difference can be measured by: days months...
The following steps show how to bulk convert negative or positive numbers. Negative numbers (-1) become positive numbers (1) Positive...
Cell references in Excel formulas typically use their position in the worksheet – e.g. A2 for a single cell or...
The following steps show how to format a table in a Word document so that the table does not split...
Problem In an Excel document, you’re unable to insert a new row. The ‘Insert’ option is greyed out. Solution This...
Problem One of the more frustrating features in Excel is its ability to automatically change a cells format – based...
In these examples we’re going to show how to calculate the percent of a total using Microsoft Excel. The basic...