Ok, here is my two or three cents;
1. Buy a copy of Doyle Brunsons Super system (preferably Volume one and two). This is the poker bible for good reason. Keep in mind it is heavily geared towards cash; that being said, it also covers MTT and other poker games
. Those other games can actually help your NLHE game as well. For example, I found Omaha to be particularly useful (I played the Carbon free games) as you see far more than just one and two pair hands at showdown. You get a good flavor of unexpected st8's and other hands you might only see on occasion in hold em.
2. Do not worry about individual hands so much as like-hand groups and hand ranges (especially of your opponents). So.....
Here are Sklansky hand groups; David Sklansky and Mason Malmuth assigned each hand to a group, and proposed all hands in the group could normally be played similarly. Stronger starting hands are identified by a lower number. Hands without a number are the weakest starting hands. As a general rule, books on Texas
hold'em present hand strengths starting with the assumption of a nine or ten person table. The table below illustrates the concept (again, O = offsuit, S = same suite):