Excel offers a rich programming language underneath the hood called VBA, Visual Basic for Applications.
Some of you may be using it without knowing by recording or using macros.
There are books out there (we think the best are the ones by Walkenbach) but in general we think they spend too much time going underneath the hood of the car instead of teaching you how to drive.
Still to start, let's give you a feel for the language. It works with objects.
Suppose there was a ball and I wanted to get it from you. We would say throw us the ball.
In the programming language, we twist the language around. We would say ball throw.
In other words, you start with the object and then mention the action.
The same would apply if we were describing the ball. Instead of it being the red ball, it would be ball color red.
So much for getting technical. Next we will get you going on something simple.