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

Have you ever found yourself stuck in the endless loop of repetitive tasks in Excel—manually formatting rows, cleaning up data, or applying the same calculations over and over again? It’s frustrating, ...

Word macros can take almost any repetitive word-processing task and do it for you faster, in just a few keystrokes. Here’s a classic example: You’ve received a document with incorrect formatting ...

Click to download a workbook and open in Excel; make sure to enable macros for full functionality. The workbooks contain screencasts that explain what to do and include tasks that can be assigned.

From lens focal lengths and fill-flash to portraits, macro or stunning landscapes there are techniques for everyone. Learn how to use metering, considering composition and shoot everything from ...

The Excel Workbooks, Excel Add-ins, and screencasts on this site will be updated and corrected regularly so head there if you are merely looking for the latest versions of a file. As far as mistakes ...