Getting Started with Video Editing: Cheap Software
PC Mechanic has produced a good rundown of some entry level video editing software. While they've capped the cash limit to $100, there are some excellent free programs listed, such as VirtualDub and Jahshaka Effects.
Be warned though, free software doesn't always translate in to simple to use software.