I won't spend a lot of time on motion graphics software because they tend to be a bit beyond the reach of a novice video maker. (According to Wikipedia, "Motion graphics are graphics that use video and/or animation technology to create the illusion of motion or a transforming appearance.")
However, while Adobe After Effects is the most popular program available, the ability to animate still graphics has crept into most non-linear editing programs.
Here's a great After Effects tutorial web site - rhys-works.com. The site was created by Rhys Enniks, a native of the UK.
In addition to being a gifted motion graphics artist, Rhys also has a knack for presenting complex technical information in an easy-to-understand way. And the fact that he's only 20 years old make his web site and work all the more impressive.