Excel 2010: Pivot Tables in Depth

Provides comprehensive, hands-on tutorials on Excel PivotTables, and more advanced techniques such as using macros and the new PowerPivot add-in.In Excel 2010: Pivot Tables in Depth, author Curt Frye provides comprehensive, hands-on tutorials on Excel PivotTables, including more advanced techniques such as using macros and the new PowerPivot add-in. 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