Photoshop, iPhoneography and lots of free online tools: These are tutorials and user-friendly, resources on how to edit photos and/or videos in a creative way.
Want to learn how to make something like this? Here's my fast-paced screencast tutorial using Photoshop CS5 Extended. It can be done in any "extended" version of Photoshop, CS3 Extended or higher.