Note: This book review was conducted as an audio interview of macros expert John Dukovich, by Phil Shapiro, using Audacity, the free sound recording and editing software. The review is available ...

In addition, many spreadsheet applications have built-in macro languages you can use to create your own data query and report applications.

If you do a lot of boring, repetitive tasks on a computer, the programs you use may have some built-in automation capabilities. Here's how to use them.

When you create a macro, make sure to run and test it a couple of times to ensure that it’s working as expected. Aside from these macros, I also follow these tips to give my spreadsheets a ...

How to create Excel macros and automate your spreadsheets Use macros to combine multiple tasks into a single, one-second transaction.

However, using the Excel macro recorder, you can program your spreadsheets to download data and insert it into cells automatically.