With the growth of the internet it has become extremly easy to share information with one another, as such a huge number of people have started to post tutorials on the internet to share their knowledge and to help others. A quick look at any sort of video sharing site will reveal that there are copius amounts of tutorials explaining how Motion graphics as a whole works, then ones to show how individual softwares operate, how various sections within the software work, how sound works, literally everything, any problem that you have there is very probably a tutorial to explain it in simple, user friendly, terms. The site below has a long list of tutorials to show you how to do various cool things within various software.
http://www.smashingmagazine.com/2009/05/25/the-ultimate-motion-graphics-tutorials-round-up/