The Black Box Workbook: Why Your Most Trusted Spreadsheet May Be Your Biggest Risk There is a particular kind of spreadsheet that I encounter regularly in financial services
- Home
- |
- Archives: Uncategorized
The Spreadsheet Key Person Risk
The Operational Risk Nobody Talks About Every financial services firm I’ve worked with has one. The person who “knows” the spreadsheet. They built it, or inherited it, or
Why Are You (Still) Emailing Data for Excel?
Replacing VBA with Excel’s Dynamic Array Formulas
Why use VBA when Excel's Dynamic Array Formulas do the heavy–lifting for you?... I’ve been working on a small Excel project for a large FMCG (Fast Moving Consumer
Checkboxes on UserForms
How to create attractive checkboxes for Excel and Word UserForms Custom vs. Native Checkbox I love UserForms, really I do. I develop a lot of add-ins for both
Power Query Blows Away 29 Years of VBA Data Access
As an Excel VBA developer in the corporate world, you spend a lot of time simply shuffling data around. Pull data from a database here. Send it to
How To Share Excel Data in a Small Team
The benefits of keeping your data in a separate workbook from your reports and processes. Separation of Concerns In a previous post we spoke about the benefits of
How to Create Option Buttons in Excel
How to let your Excel users select one item with custom option buttons By now, you’re probably familiar with Excel’s checkboxes. From the Insert ribbon tab, select Checkbox,
How to Create Single Select Checkboxes in Excel
How to make Excel checkboxes work like option buttons Custom Checkboxes in Excel Some time ago – pre “in-cell” checkboxes in Excel – I needed to provide a
3-Tier Architecture in Excel
There’s an old Excel aphorism that says, “Excel’s greatest strength is its flexibility and its greatest weakness is its flexibility.” One result of this flexibility is that far