The best bits of advice I have are to reiterate Traci's comment on a tripod being worth it, and to remember never to try to use a flash.
I get what I consider decent but not spectacular results with and without macro mode. (Some of my shots I want to get my whole tank in and those, of...