Annette,
Welcome to the forum.
You asked:
I don't want to sound discouraging, but that is really the wrong approach. If you want to become a good photographer, you can't look for a handful of tips and tricks. You need to practice and study, a few topics at a time, and you will see improvements as you do so. It is far to complicated a process to handle without systematic learning. I think this is what Altay is getting at as well, although I would not give you such a prescriptive list. For example, you can do just fine without Photoshop. Here are the major categories of things that you need to learn. It sounds overwhelming, but it isn't if you take your time.
1. How does your camera work? Read the manual, probably more than once.
2. Learn about exposure--the relationship between ISO, aperture, and shutter speed. Along with this, learn about the effects of enlarging or decreasing aperture and ISO, so you will have a basis for trading off between these three settings.
3. With this, learn how to meter using your camera's metering options.
4. Read some on lighting and composition
5. Learn about postprocessing. This is IMHO by far the hardest, but again, take it a step at a time.
6. Practice, practice, practice. Then practice some more. Ask people
specific questions about your images.
The tutorials on this site are superb, so you can make a lot of headway with them. There are also resources on a number of other sites, such as photo.net.
Re macro: this is the type of photography I most enjoy (I'll post a few of mine below), and I hope you decided to try it. However, I would recommend that you NOT try it until you have the basics under control. Macro is technically by far the most demanding photography I do, and unless you are already comfortable with the basics, there is a good chance that you will be so frustrated that you won't persist with it. Once you are comfortable with the basics, then it won't seem so hard to learn all the additional stuff that successful macro requires.
So, my advice is: read a little, and then go practice. Then read some more, and go practice again. Have fun doing it. Persist, and the results will be gratifying. But don't expect instant results--that just sets you up for being discouraged.
Dan