Microsoft 365 or Office 2021: What should you choose?

Microsoft 365 or Office 2021: What should you choose?

Office 2021 or Microsoft 365? Why are there two competing products by Microsoft? What to look for when considering the best choice for you? A brief history of Office software provisioning and consumption Historically, Microsoft dominated the personal computing...
Developing Business Applications with Excel VBA and MySQL Server

Developing Business Applications with Excel VBA and MySQL Server

Turn Excel into a powerful information systems development platform * Enjoy the power of a relational Database in your Excel VBA applications * Business applications like you never thought possible with Excel * Today we write SQL queries from Excel VBA to MySQL DB Be...
Excel VBA User Forms – A Game Changer

Excel VBA User Forms – A Game Changer

What separates an Excel model from a professional business application? Besides good programming practices it’s the user experience * Excel VBA User Forms allow you to deliver mission-critical business applications that will make your customer WOW. Today I launched my...
The Full Dev to QA to Prod Cycle with Excel VBA Projects

The Full Dev to QA to Prod Cycle with Excel VBA Projects

When developing, delivering and maintaining software solutions, you need to manage the Dev-QA-Prod cycle. This is no different when developing an Excel based application * Here’s how I do it The Basics of Development Lifecycle After you finish developing a scoped...