Excel 2010 Training Pivot Tables in Depth Lynda.com
Excel 2010 Training Pivot Tables in Depth Lynda.com
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
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
http://www.lynda.com/Excel-2010-training/Pivot-Tables-in-Depth/77968-2C.html
Quote:
http://www.filesonic.com/file/980464194/
http://www.filesonic.com/file/980548311/
Excel 2010 Training Pivot Tables in Depth Lynda.com
0 comments:
Post a Comment