This is a very useful site offering Photoshop tutorials for many different effects and styles. If you are trying to polish up your skills or just want to see what can be achieved then psd.tutsplus.com/category/tutorials/ is for you. Give it a go there is some great stuff on here.