Excel macros use Visual Basic code to perform functions unavailable through the program's graphical controls. For example, macros can extract data from a sheet, perform string operations on them and ...

If you ever wanted to click a magic button and make complex business tasks happen automatically, macros can make that wish come true. Macros are small programs that execute commands you specify. Write ...

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.

As a power Excel user, I am always on the lookout for ways to streamline my workflow. After all, nobody prefers spending ...

This book is a resource for professors. It explains how the Excel files on this web site can be used in a variety of ways to help students learn. The files are standalone and freely available. They ...