Become an Excel —and Google Sheets—master by studying with this $35 course pack.

Data Analysis eXpressions (DAX) includes more powerful functions for BI type data manipulations, including iterative expressions, grouping, linking, and filtering. The full promise of PowerPivot is ...

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.

PowerPivot is Microsoft's new self-service business intelligence (BI) product that seeks to make peace between IT and Excel users. PowerPivot is a component of SQL Server 2008 R2 that works with Excel ...