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

Download File Size:460.21 MB

---