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.