Skip to content

Dear Internet Explorer user: Your browser is no longer supported

Please switch to a modern browser such as Microsoft Edge, Mozilla Firefox or Google Chrome to view this website's content.

Office rebranded to Microsoft 365

Posted 19th October 2022

No comments

Microsoft has announced that its iconic Office suite of programmes are to be re-branded as Microsoft 365 from November 2022.

Read the full story...

Remove sensitivity labels from Office files

Posted 14th October 2022

No comments

If your organisation utilises Microsoft Azure or Purview to apply “security labels” to your Office documents, you may be compelled to have unsightly headers and footers in your documents. There is a way around this, but it’s clunky.

Read the full story...

Creating a custom unique ID in a SharePoint list

Posted 3rd August 2021

6 comments

Use Power Automate with SharePoint to create a customisable unique ID number in a list that does not rely on secondary lists to work.

Read the full story...

Batch convert a folder of DOCX files to PDF

Posted 20th April 2016

11 comments

Use this handy PowerShell script to convert all Microsoft Word DOCX files in a directory into Adobe Acrobat PDF files.

Read the full story...

RGB to HEX in Excel

Posted 24th March 2016

16 comments

Use Microsoft Excel to convert Red-Green-Blue (RGB) values into hexadecimal colour codes and display the relevant colour graphically beside each output.

Read the full story...

Rearrange Excel columns via Visual Basic

Posted 16th March 2016

21 comments

A simple VBA script for rearranging the order of columns in an Excel spreadsheet.

Read the full story...

Convert CSV to XLSX via PowerShell

Posted 9th March 2016

50 comments

A nifty PowerShell script that will take a delimited CSV file and convert it to a XLSX file.

Read the full story...

VBA: Create a list of all external data references in Excel

Posted 15th September 2015

3 comments

Use this simple Visual Basic for Applications script to list every external link within an Excel workbook.

Read the full story...

Applying dates to normalised data in Excel

Posted 19th July 2015

No comments

Use this formula to apply dates to all variables in a normalised linear list data set in Excel.

Read the full story...

Format mail-merge date fields in Microsoft Word

Posted 16th July 2015

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