PowerPivot also sports its own formula language, DAX (short for Data Analysis Expression). DAX is syntactically similar to the formula expressions we've been crafting in Excel for years now, but it's designed to work with data columns and entire tables rather than ranges and individual cells. It's a way to perform some analysis that would normally be done in a SQL statement (such as comparing relational values across multiple columns) in an environment that many number crunchers are more familiar with. Note that DAX isn't a substitute for the old formula language, but a complement to it; odds are you'll still be using all of your existing Excel macro tricks in conjunction with PowerPivot.
A chart created in Excel by slicing and dicing data stored in PowerPivot. The results are interactive, but only in PowerPivot-connected versions of Excel 2010.
More great free stuff for Windows:
This article, "PowerPivot for Excel 2010: Power to Excel people," was originally published at InfoWorld.com. Follow the latest developments in Windows, Microsoft Office, and applications at InfoWorld.com.