This infographic/cheat sheet from Zippi might be helpful for those looking to get out of auto mode and gaining more control over their cameras. While section 1 is much more for those shooting with film the rest is relevant for digital photography.

PGA Tour Player's Golf Swing Secret Can Now Be Tested

Trick, Photography Book - Lens Length comparison shots, by Lynne Rigby at The Photographer Within - Now YOU Can Create Mind-Blowing Artistic Images With Top Secret Photography Tutorials With Step-By-Step Instructions!