Insights That Drive Performance

At de Havilands, we don’t just solve Excel problems—we help financial services firms unlock their full potential through clarity, control, and intelligent automation.

These brief articles offer practical insights, client stories, and strategic commentary on how better spreadsheet systems can save time, reduce risk, and deliver measurable results.

Whether you're a looking to streamline operations or a striving for reporting accuracy or automation in Excel, you'll find articles here that speaks directly to your challenges—and the solutions that work.

Why Are You (Still) Emailing Data for Excel?

Why use VBA when Excel's Dynamic Array Formulas do the heavy–lifting for you?...I’ve been working on a small

read More
Replacing VBA with Excel’s Dynamic Array Formulas

How to create attractive checkboxes for Excel and Word UserFormsCustom vs. Native CheckboxI love UserForms, really I do.

read More
Checkboxes on UserForms

As an Excel VBA developer in the corporate world, you spend a lot of time simply shuffling data

read More
Power Query Blows Away 29 Years of VBA Data Access

The benefits of keeping your data in a separate workbook from your reports and processes.Separation of ConcernsIn a

read More
How To Share Excel Data in a Small Team

How to let your Excel users select one item with custom option buttonsBy now, you’re probably familiar with

read More
How to Create Option Buttons in Excel

How to make Excel checkboxes work like option buttonsCustom Checkboxes in ExcelSome time ago – pre “in-cell” checkboxes

read More
How to Create Single Select Checkboxes in Excel

There’s an old Excel aphorism that says, “Excel’s greatest strength is its flexibility and its greatest weakness is

read More
3-Tier Architecture in Excel

Dynamically viewing Word Documents in Excel with a UserForm to expand the functionality of your Excel solutions.Embedding Applications

read More
Viewing Word Documents in Excel

Page [tcb_pagination_current_page] of [tcb_pagination_total_pages]

>