If you are on Windows and want to get down and dirty and use a powerful NLE and don't want to spend any money then lightworks is the business.
Exceptionally powerful and feature packed, and is free.
http://www.lwks.com
There is now a beta available for Linux as well.
There is a great community and online tutorials etc. and this is an industrial strength package. Well worth getting to know it.
If you are on a Mac though, iMovie will do all of what you have listed there, and is free.