For the first time, Microsoft PowerPivot 2010 now allows you to analyse large datasets within Excel (no need to learn complex software like Analysis Services any more - you can just build on your existing knowledge of pivot tables). For anyone who has complained that pivot tables are too slow - or not sufficiently powerful - PowerPivot is the way to go!
Official Website: http://www.wiseowl.co.uk/courses/powerpivot.htm
Added by sandiwiseowl on June 11, 2012