Skip to content
power-shell

Use PowerShell to copy all files with a certain name or extension

G2nd September 2015 

CNo comments

Use this simple PowerShell script to batch copy files from one location to another on your computer.

Read the full story

power-shell

Batch extract zip files with PowerShell

G19th August 2015 

CNo comments

Use this simple PowerShell script to batch unzip large numbers of files at once.

Read the full story

silverstripe-logo

Blog headlines on the SilverStripe HomePage

G3rd August 2015 

CNo comments

Insert your blog headlines and excerpts from the SilverStripe Blog Module into the front page of a SilverStripe website.

Read the full story

icon_microsoft_word_2013

Format mail-merge date fields in Microsoft Word

G16th July 2015 

CNo comments

Microsoft Word will format dates as mm/dd/yyyy as the default in mail merge documents. The field codes can be changed to enable dates in any format.

Read the full story

excel-logo-2013

Identifying and ranking repeat values in an Excel data series

G9th July 2015 

CNo comments

Use Excel to develop a running tally of how many times each particular value in a data series has been repeated.

Read the full story

excel-logo-2013

VBA: List all formulae in an Excel workbook

G2nd July 2015 

CNo comments

Described is a convenient method for using VBA scripts to extract every formula from a Microsoft Excel workbook and create a list of them in a separate sheet for later reference or backup.

Read the full story

power-shell

Managing files with PowerShell

G4th June 2015 

CNo comments

Use these simple PowerShell commands in Windows to batch-organise files on your computer.

Read the full story

barcode

Easily generate Code 128 barcodes in Excel

G29th May 2015 

CNo comments

This simple methodology can be employed to reliably generate Code 128 barcodes in Excel.

Read the full story

excel-logo-2013

Combining R1C1 and A1-style cell referencing in Excel

G11th May 2015 

CNo comments

Use R1C1 cell referencing in Excel equations whilst the programme is still set to A1-style.

Read the full story

metadata

VPN for beginners

G8th May 2015 

CNo comments

A layperson’s experience in signing up for a Virtual Private Network (VPN) in Australia. It isn’t as tricky as it seems!

Read the full story