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

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

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

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

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

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

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.

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

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

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