Old friends looking at photos

Some old friends from Purchase were in town this weekend and we had them over for dinner. Amanda took some pictures of us all laughing over old college snapshots (that I won’t ever be posted here!). Editing them today made me realize how bad our Canon 40D is at ‘Auto White Balance’ in tungsten. With some levels, hue & saturation and color balance adjustements, I got it as close as my laptop screen can get. Anyone got any tips on quick color adjustment in camera settings, or in photoshop? I know that ‘Aperture’ has a nice ‘temperature’ adjustment.