Skip to content
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

excel-logo-2013

INDEX MATCH instead of VLOOKUP

G22nd January 2015 

C1 comment

INDEX MATCH represents a much better way to search for data in Excel tables than VLOOKUP because this combination is much more versatile.

Read the full story

excel-logo-2013

Automatically add columns and formulae then fill-down in Excel

G21st January 2015 

CNo comments

Some simple VBA code to add columns in Excel, insert specific formulae at the top then fill-down to the bottom of the sheet.

Read the full story

silverstripe-logo

Adding search to SilverStripe

G3rd January 2015 

CNo comments

Whilst it’s relatively easy to add a site search function to SilverStripe, quite a bit of tweaking is required to make it perform as it should. Here are some simple instructions.

Read the full story

excel-logo-2013

VLOOKUP in Excel with multiple criteria

G3rd December 2014 

CNo comments

An alternative to VLOOKUP in Excel that permits a search based on multiple criteria.

Read the full story

excel-logo-2013

Sum of Column B, based on values in Column A

G28th November 2014 

CNo comments

Use an array formula to calculate selected values in one column, based on parameters in another.

Read the full story

power-shell

Automatically delete files listed in a CSV

G26th September 2014 

CNo comments

A PowerShell script that reads a list of files in a CSV and deletes them from a computer drive automatically.

Read the full story

google-chrome

Fix the ‘Gill Sans’ font bug in Chrome

G25th September 2014 

C2 comments

Bug fix: A quick CSS remedy to ensure that Google Chrome 37 displays the Gill Sans font correctly.

Read the full story

power-shell

Script to list image files by size and resolution, export to Excel

G24th September 2014 

CNo comments

Instructions for using PowerShell to export a list of images and their properties to Excel as a tab-delimited CSV.

Read the full story