Personally, I like iMovie, if you have a newer Mac.
It is very simple to make decent videos with catchy effects.

Im not as familiar with Windows movie maker, but it does a fairly decent job as well.

Both programs are free, and there are tutorials galore online.