Here's another in my KelbyOne.com series where I start off with a very flat-looking original file out of the camera and bring it to life in Lightroom. No plug-ins, no presets, no HDR - just really simple moves that have a big effect. However, I think the most valuable part is the thinking process behind it and how it relates to Lightroom.
If you dig Lightroom stuff, we have ton (loads, piles, etc.) of in-depth online training courses on every aspect of Lightroom so you can become an absolute shark in no time. Take the 10-day free trial at http://kelbyone.com and start learning immediately.