http://studio.adobe.com/tips/main.jsp is the place where you'll find tutorials for Photoshop and other Adobe products... includes pdf and video based tutorials!

http://share.studio.adobe.com/ is where you'll be able to find every preset you have ever dreamed of... for Photoshop and your other Adobe products