Realist Painting Effect
A Painting from a Photo
A Classical Portrait Tutorial
Impressionist Painting Tutorial
Watercolor Tinted Drawing
Cool - Warm Sepia Tutorial
Photo Art Tutorials
Illustrating from Sketches in Photoshop - graphics.com
Transform your basic sketch idea into a professional piece of finished art. Adapted from Creative Photoshop: Digital Illustration and Art Techniques By Derek Lea
Creative Photoshop: Digital Illustration and Art Techniques, covering Photoshop CS3 (Digital Workflow)
Online Photo & Print Lab
Transform
your basic sketch idea into a professional piece of finished art. Adapted
from Creative Photoshop: Digital Illustration and Art Techniques By
Derek Lea 
Creative
Photoshop: Digital Illustration and Art Techniques, covering Photoshop
CS3 (Digital Workflow)