Excel 2010: Pivot Tables in Depth

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