yeah layersmagazine.com got a lot of tutorials for creative suite, web design, 3d, etc.
vectortuts.com is filled to the brim for illustrator and other vector based programs.
lynda.com offers extensive software training and tutorials for pretty much every application. If you want real professional training, probally better than some colleges or art schools you should pay for an monthly or yearly account and soak up everything you can. But the site has hundreds of videos and freebies too without signing up.
lostandtaken.com is like a portal to free textures. check it out.