|
|
| 商品编号: |
xdvd3282c |
|
| 商品名稱： |
Lynda com Excel 2010 Pivot Tables in Depth 英文版 CD |
|
| 碟片數量： |
1片 |
|
| 銷售價格： |
200 |
|
| 瀏覽次數： |
23221 |
|
【轉載TXT文檔】 |
|
| Lynda com Excel 2010 Pivot Tables in Depth 英文版 CD |
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
|
|
|
專業軟體光碟