You can by whole books on this subject. The Photoshop Wow Book is one that comes to mind. Moreover, you already can find countless tutorials all over the inter net. Just do a search and you should find something to serve your needs.