Spreadsheet Controls and Compliance

Patrick O'Beirne provides quality training and consulting in Excel/VBA development, training, testing, model review, analytics, and spreadsheet auditing.

He is the author of the "Spreadsheet Check and Control" book on Best Practice skills in spreadsheet development for end-users. He also developed the XLTest spreadsheet addin for auditing and spreadsheet inventory for compliance projects.

XLTest 1.74 Sept. 2021

Spreadsheet auditing addin for Excel 2010 to 2016

XLTest menu XLTest helps you to check the integrity of your spreadsheets far more quickly than with tedious cell-by-cell inspection. Its colour maps of the worksheets give you a visual overview that enables you to very quickly see inconsistencies. Its detailed listings are ideal for audit record purposes. The ability to compare versions and run test cases facilitate compliance with spreadsheet controls.

Latest blog post

Patrick's Wordpress blog on Excel VBA automation