Here is a link to Andrew Price's tutorial. There are hundreds of Blender templates on the internet.
http://www.blenderguru.com/tutorials/how-to-create-a-professional-logo-animation/
This is an older one: http://www.blenderguru.com/tutorials/create-a-sizzling-title-intro/
