Excel Expertise

Simplification

Clarity is key! Formulas should always flow top-down, left-to-right. Use styles so formats convey information, not just decoration. Design for Maintainability. These are just some of my principles.

VBA

Nothing is worse than seeing a bunch of nested IF functions. Proper use of well-coded VBA should make your spreadsheets a pleasure to use.

Automation

Press a button and watch magic happen. Let Excel write emails, Word documents, PDFs, or iterate calculations between spreadsheets…. automatically.