Welcome, my friends, to the second installment of Macro Anatomy. In this episode we'll be going over some basic macro commands and I'll introduce some simple macros for you to learn and play with ...

While macros can be created using code, they can also be created by having Excel record your actions. It is very simple. I illustrate, in the accompanying video, how to record a macro in Excel using ...

I use a macro pad as a Stream Deck alternative on Mac, and here's how you can do it with the help of a simple and easy-to-use utility too.

To help you learn how to define your own macros, this section presents a few examples you can model your own macros after. Each of these examples is fairly simple; by mixing and matching the various ...

In this example, we applied only one simple rule, but the feature is much more robust. Access' conditional formatting feature is just as comprehensive, flexible, and powerful as Excel's.