Video Editing and Movie Creation

For this there is really no easy alternative to
Apple's iMovie

free video tutorials can be seen here
http://www.atomiclearning.com/imovie3x

You will need a :

Macintosh Computer with a firewire port
A Digital Video Camera
And iMovie software (comes free with newer Macs)