130 programming Excel applications

Today we will study macro programming in Excel and then add controls to a spreadsheet for some VBA — Visual Basic for Applications. What we do in Excel will indicate how to use VBA for other Microsoft Office applications.

To continue your learning of Excel and everything else computing-related, I cannot recommend heartily enough Safari, which you can use through the NVCC library. Such a deal!

Examples:

first, macros

then a one-button app
then a comparatively snazzy app for statistics from a book by David Birnbaum, Microsoft Excel Programming for the Absolute Beginner

then a mathematical application filled with things we wouldn't (OK, I wouldn't) suspect that Excel can do

The last is one of a lot of mathematics apps from Professor Jesse Williford at Wake Technical Community College in North Carolina. (Scroll down the page, third column.)

Here are a few concise how-tos from Professor Norm Jones at Brigham Young. Besides the Birnbaum book at Safari, I also get a kick out of the O'Reilly book Excel Hacks by Hawley & Hawley. Plenty of the hacks don't require programming or macros.