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…
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…
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…
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…
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…
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…
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…
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…
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…