Bill Jelen, aka MrExcel has written the first book on Microsoft’s new PowerPivot. PowerPivot is a the Office 2010 solution to link Excel to millions of rows of data held on databases or large text files.

PowerPivot will ensure that Excel remains a useful, and perhaps even more serious, dashboard tool. I found this video he made to be a useful introduction to PowerPivot.