This is one of the best tutorial sites that I’ve found, and it covers a variety of packages, like Adobe Premiere, After Effects and Photoshop, as well as some of the high-end 3D programs.
This site taught me everything I know (which isn’t that much yet) about Adobe After Effects. It offers fantastic video tutorials that are free to watch online – professionals let you into their secrets and show you how to do a project from start to finish. Actually seeing things being done, rather than following a step-by-step guide really helps you to understand how it works. You can also download the program files to try it yourself.
Andrew Kramer is an After Effects legend and offers free video tutorials and plugins that are really mind-blowing. You can learn a lot here and it’s just fascinating watching effects being created from scratch.
Professional editors on hand 24/7 to help you with any kind of technical issues. I had a real headache converting all my videos for progressive downloading, and they helped me out really quickly and all for free. Any kind of coding or software issues, this is the place to go.
Along with Vimeo, Motionspire is a great place to check out cutting edge visuals. Motionspire tips itself as the home of motion graphics inspiration – you won’t find fanvids here, but you’ll find professional editing, creative uses of shapes, types, colours and concepts that, with a little imagination, can take fanvids to the next level. Either that, or you can just enjoy looking at the prettyness of it all 
Sometimes its just nice to see what other vidders are doing, and every once in a while to come across something that moves you and makes you rewind, rewatching as you wish you’d created it first. I didn’t watch many fanvids when I first started editing as I was too busy working on my own style to download other people’s work (this was pre-YouTube!) so I was very select about what I watched. Now though, it’s easy to spend hours indulging in a little shippy goodness. Youtube politics do annoy me though, such as the assumption from many vidders that the number of subscribers denotes how good the vidder is… but that’s another rant altogether!