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

Microsoft Excel offers Visual Basic for Application (VBA) as a scripting tool to let you add additional functionality to your Excel spreadsheets. You can use VBA to prompt the user to enter a filename ...

Macros are the timesaving magic trick for Office applications because they automate repetitive tasks that gobble time. This week’s feature, which spotlights Excel, is one of several articles featuring ...

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

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.