Useful Photoshop Tutorial Sites

http://psd.tutsplus.com/tutorials/photo-effects-tutorials/how-to-make-a-dark-post-apocalyptic-city-illustration/

http://kalaalog.com/tutorials/

http://www.tutorialquest.com/tutorials/photoshop/digital-painting/

Color Theory

I just stumbled upon something very interesting that takes most of the work out of color theory. It actually generates a color scheme for you based upon whether you want the use a monochromatic color scheme or complementary and so on. Any way check it out:

http://colorschemedesigner.com/