Come to think of it, another important bit of knowledge to have when using EQ is an understanding of sound theory. I'll try my best to summarize:
(My apologies if you already know this.)
There's only one waveform in the physical universe: sine wave.
Complex sounds are made up of multiple sine waves.
Pitched sounds have sine waves organized along the harmonic series. For example, if the funadmental frequency is 100 Hz, the second harmonic is 200 Hz, the third is 300 Hz, the fouth 400 Hz, etc. Vowels are examples of pitched sounds, as are musical instruments that can play notes on a scale. Furthermore, not all harmonics have to be present for the sound to be pitched. Most woodwinds (with transverse flutes being a notable exception) only create the odd harmonics. In our above example that would mean a pattern of 100 Hz, 300 Hz, 500 Hz, etc.
Non-pitched sounds are random noise, and often contain far more individual sine waves. However, despite their "random" nature, they can still have shape, such as favouring higher frequencies, different attack, sustain, decay rates, etc. Consonants are an example of non-pitched sounds, as are cymbals. Note that consant sounds, such as "s" sounds, tend to remain in the same range for each person's voice. This is in contranst with pitched sounds that move with, well, pitch.
Most real world sounds are a mix of pitched and non-pitched. Voiced consonants are an example. Transverse flutes are another obvious example, as the flautist's breath noise can easily be heard over the flute's pitched sounds. Piano hammer noises, however, are much queiter and require more concentration to hear.
Occasionally checking out a spectrum analyzer whilst working on a song can be very informative when learning to mix. Prism by TDR is free, and I do use this plugin:
A modern spectrum analyzer with a focus on human audio perception, easy to use and configurable.
www.tokyodawn.net