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,…
Office 365
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…
Word 2016 – How to keep whole table together on one page
The following steps show how to format a table in a Word document so that the table does not split across multiple-pages (when it can fit in one page). For…
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…
Word 2016 – How to update a cross-reference
Cross-references in Word are useful for using the same footnote multiple times. However, they don't automatically update when new footnotes are inserted. For example - the footnote 'A type of…
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…
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…
Office 365 – How to disable inbox ‘Other’ folder
By default the Outlook web app in Office 365 has an 'Other' folder. This is similar to the Gmail's category tabs - where emails are automatically categorised and shown in…