资源描述:
《数据透视表教程.ppt》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、PivotTable-TrainingGESJ/APA-DataMgt&ValueCreation7/27/20211PivotTable-TrainingPivotTableReports101Let'ssupposeyou'vecompiledalargelistofdata-forexample,salesfiguresforeveryproductyourcompanymakes.Butnowyou'rereadytodistillsomemeaningfulinformationfromthedata.Forexample,youmightwanttoanswerthefollow
2、ingquestions:·Whatisthetotalsalesforeachproductbyregion?·Whichproductsaresellingbestovertime?·Whoisyourhighest-performingsalesperson?Fortheseandotherquestions,youcancreateaPivotTable®report.PivotTabledefinition:Aninteractivetablethatautomaticallyextracts,organizes,andsummarizesyourdata.Youcanthenus
3、ethereporttoanalyzethedata-forexample,MakecomparisonsDetectpatternsandrelationshipsAnalyzetrends7/27/20212PivotTable-Training7/27/20213PivotTable-TrainingAnatomyofaPivotTableReportYoumayhavenoticedthatExcelusesspecifictermstoidentifythepartsofaPivotTablereport.Ifyou'renotfamiliarwiththeseterms,read
4、thissectionforaquickprimer.RowfieldAfieldfromthesourcedatathatyouassigntoaroworientationinaPivotTablereport.Forexample,RegionandSalespersonarerowfields.ColumnfieldAfieldfromthesourcedatathatyouassigntoacolumnorientationinaPivotTablereport.Forexample,Typeisacolumnfield.PagefieldAfieldfromthesourceda
5、tathatyouassigntoapage(orfilter)orientationinaPivotTablereport.Forexample,Yearisapagefield.YoucanusetheYearfieldtodisplaysummarizeddataforonly1997,1998,andsoon.ItemAsubcategoryofarow,column,orpagefield.Forexample,theTypefieldcontainsthefollowingitems:Beverages,Dairy,Meat,andProduce;theSalespersonfi
6、eldcontainsthefollowingitems:Buchanan,Davolio,Dodsworth,andSuyama.DatafieldAfieldfromthesourcedatathatcontainsdatatobesummarized.Forexample,SumofSalesisadatafield.Note:Youcanchoosehowtosummarizedata(forexample,bysum,average,orcount).Adatafieldusuallysummarizesnumericdata,butitcanalsosummarizetext.F
7、orexample,youcancountthenumberoftimesaspecifictextentry(suchasYesorNo)appearsinafield.DataareaThecellsinaPivotTablereportthatcontainsummarydata.Forexample,thevalueincellC5summarizesBuchanan'sbeveragesalesfo