Here are two fun tutorials you can follow that think outside the box about potential real world PowerPivot applications:
On Kasper de Jonge's blog (the best resource for PowerPivot information, IMO): Gain insight into your music taste using Last.fm, PowerPivot and the PivotViewer
On Chris Webb's BI Blog: Using PowerPivot to Analyse Windows Search Results