Curves for idiots

[miniman]

Idiots being me, of course

I see what the effect of playing with Curves is, but can someone give me a simple explanation as to the theory and how to use them effectively?