Go to the Adobe Exchange beta @ http://www.adobe.com/cfusion/exchange/index.cfm#view=sn710&viewName=Photoshop%20Exchange&loc=en_us&authorid=0&page=0&scrollPos=0&subcatid=0&snid=sn710&itemnumber=-1&extid=0&catid=0

After becoming a member go to the Photoshop Exchange and do a search for "Craig Campbell". He's posted a number of great tutorials for Photoshop including animating and working with video. You may need Photoshop CS3 Extended for more complex stuff.