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…
VALUE
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…
How to uninstall Meet Now in Windows 10 taskbar
The Windows 10 October 2020 update introduced a new feature - Meet Now. For the casual observer it's easily overlooked - but for others it's another annoying icon that sits…
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…
Squiz Matrix – How to create breadcrumbs with Microdata schema
The following code shows how to create breadcrumb navigation with Microdata schema in Squiz Matrix. For example, a page of example.com/level-1/level-2/page Would generate Home > Level 1 > Level 2…
Word 2016 – Merge field codes always displayed
Problem Any Word document opened that has merge fields - displays the full merge field code. For example, a field link will show { HYPERLINK } and a merge field…
How to install 7-Zip silently
The following process shows how to setup a 7-Zip silent installer that will work with 32-bit and 64-bit versions of Windows. It can be used to distribute 7-Zip to computers…
T-SQL – How to reset auto increment to next available number
The following T-SQL shows how to reset a tables identity auto increment back the last available number. This may be useful if you have removed a bulk amount of data…
SQL – How to copy column data to another column
The following SQL statement shows how to copy the data from one column to another. It will replace any existing values in the destination column - so be sure to…