More small business owners than you might think are creating and writing their own software programs, and many times their first programming baby steps involve the use of Visual Basic for Applications ...

I've been treating Excel like a glorified calculator for most of my life. Sure, formulas made doing more complex calculations easier and automatically updated data, and there are free Excel templates ...

Macros can help you save precious time while performing repetitive tasks for your business in Microsoft Excel. Suppose, for example, that you want to change the color of spreadsheet cells to red if ...

Can Excel send Alerts? Yes, but with some limitations. Excel cannot email an alert to you automatically unless you write a macro in the Visual Basic (VBA) editor to perform this function. And, the ...

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 ...