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

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