"Video Sequence Editor - Title slides and Callout Video" from CG Cookie on Vimeo.
In this tutorial, I import a video clip into the Video Sequence Editor as a "base" clip. Then I import a second video, which I show how to overlay onto the first one by using a "Transform" strip effect, resizing and positioning with the controls in the Properties Panel. Next I go into Gimp and create a title slide png, and import that back into Blender, and superimpose it on top of the first two video clips. Finally I bring in an audio clip, and export out to mpg.