Lynda com Excel 2010 Pivot Tables in Depth 英文版 CD

InExcel2010:PivotTablesinDepth,authorCurtFryeprovidescomprehensive,hands-ontutorialsonExcelPivotTables,includingmoreadvancedtechniquessuchasusingmacrosandthenewPowerPivotadd-in.
ThecourseshowshowtoconnectandconsolidatedatasourcestopowerPivotTables,sortandfilterrecords,displaydatainaPivotChart,printtablesandcharts,andalsointroducestheDAXlanguageforperformingadvancedsummariesinPowerPivot.Exercisefilesareincludedwiththecourse.

Topicsinclude:
*FormattingdataforuseinaPivotTable
*Connectingtoanexternaldatasource
*Refreshingadatasource
*Adding,removing,andpositioningsubtotalsandgrandtotals
*Creatingacalculatedfield
*GroupingPivotTablefields
*ClearingandreapplyingPivotTablefilters
*Applyingfieldstyles
*Formattingcells
*CreatingaPivotChart
*PrintingPivotTablesandPivotCharts
*CreatingrelationshipsbetweentablesinaPowerPivotmodel
*UsingtheDAXlanguageforadvancedsummariesinPowerPivot