The course shows how to connect and consolidate data sources to power PivotTables, sort and filter records, display data in a PivotChart, print tables and charts, and also introduces the DAX language for performing advanced summaries in PowerPivot. Exercise files are included with the course. Topics include: * Formatting data for use in a PivotTable * Connecting to an external data source * Refreshing a data source * Adding, removing, and positioning subtotals and grand totals * Creating a calculated field * Grouping PivotTable fields * Clearing and reapplying PivotTable filters * Applying field styles * Formatting cells * Creating a PivotChart * Printing PivotTables and PivotCharts * Creating relationships between tables in a PowerPivot model * Using the DAX language for advanced summaries in PowerPivot