Wes James (AKA the NLE Ninja) has produced a set of nine tutorials wrapped up into a 40 minute video. No FCPX, no Motion, just layers, effects and rendering!
Full credit to Wes for continuing with FCP7 whilst everyone around him seems to be kicking out FCPX tutorials. He seems to have hedged his bets slightly with Premiere & Avid ones coming up shortly!
Magnifying Wipe w/ Lens Flares- starts @ 3:27