You would be able to make photo albums, office presentations, fan music videos, intros, etc. Although, I am a Pr0gramm3r, I always wanted to learn editing, and it took me a lot of time to get up to speed. I'll be happy to use my experience to teach others who always wanted to learn this skill.
EDIT: Another thing I'd like to add is that (at least for the initial lessons) I would be emphasizing exclusively on the basics of video editing (irrespective of the software). You can then apply that knowledge to any program you want. All the important principles will apply equally to any Editor.
Following is the kind of video that you'll be able to make with the skills learned in the first few weeks
An example of something you can create after becoming proficient (i.e. couple of months)
Movie Trailer example (by the end of course)