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

PowerPivot queries the database and retrieves the information, bringing it in-memory, where it is compressed and can then be accessed in full by Excel workbook, with a tab created for each element.

Microsoft Excel users can now rename tables, columns and calculate fields within the Power Pivot and take advantage of PivotTables adjustments to the new names in the Data Model.