Some of Excel's most common "best practices" aren't actually best practices at all. Believing the wrong advice can lead to bloated workbooks, broken formulas, and unnecessary manual work. Here are six ...

This is the story of migrating a nutrition management application built with Excel VBA to a multi-user system using VB.NET and SQL Server. The reason for changing the technology was not because I ...

Even if you are a non-engineer with almost no programming experience, with the help of an excellent 'AI partner' called Cursor, you can decipher the logic of even the most massive and complex VBA ...

Annoyingly, many of the tools I use most in Excel aren't available as single-step commands in the ribbon or Quick Access Toolbar (QAT). That's why I built a personalized command layer that works in ...