http://www.pixel2life.com/
Go there, it has quite a few tutorials to run through. Go to the category browser to narrow down which program you need help with. To be honest, there is a bunch of useless crap in there. But if you look you'll find plenty of helpful hints too.
If you all know any other awesome tutorial sites, slap them bad boys in here and we'll have an easier time locating them.