excel_pivot_tables.pdf

《excel_pivot_tables.pdf》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、UseaPivotTableinExcel2007forDataOrganizationPivottablesareanExcelfeaturethatyoushouldlearnhowtouse.Insteadofanalyzingrowsuponrowsofrecords,apivottablecanaggregateyourdataandshowanewperspectiveandfewclicks.Youcanalsomovecolumnstorowsorviceversa.Theproblemispeoplebelievecreatingapivottableistoodifficu

2、lttolearn.Grabaseatandwe’llwalkyouthroughthisminitutorialusingExcel2007.WhatisaPivotTableYoumightthinkofapivottableasausercreatedsummarytableofyouroriginalspreadsheet.Youcreatethetablebydefiningwhichfieldstoviewandhowthedatashouldbedisplayed.Basedonyourfieldselections,Excelaggregatesandorganizesthed

3、atasoyouseeadifferentviewofyourdata.Asexample,I’veuploadedasamplespreadsheetof4000fictitiousvoters,whichincludesthefollowingdatafields:VoterIDPartyAffiliationTheirprecinctAgegroupWhentheylastvotedYearsthey’vebeenregisteredBallotstatus1Lookingatthefirst20datarecords,youcanseethedataisboring.It

4、’senoughtomakeyourollyoureyesandfallasleep.Inthisformat,thekeyquestionitanswersishowmanyvotersexistinalltheprecincts.UsingExcelpivottables,youcanorganizeandgroupthesamedatainwaysthatstarttoanswerquestionssuchas:Whatisthepartybreakdownbyprecinct?Dovotersusepermanentabsenteeballots?Whichprecinctshavet

5、hemostDemocrats?HowmanyvoterpamphletsdoIneedforPrecinct2416?Do18-21yearoldsvote?Apivottablesallowyoutogroupthespreadsheetorexternaldatasourcebyanyofyourdatafields.Thethumbnailbelowshowsacountofvotersbypartybyprecinct.2Usingapivottable,IcancontinuetoslicethedatabyselectingadditionalfieldsfromthePivot

6、TableFieldList.Forexample,Icantakethesamedataandsegmentbyvoteragegroup.UnderstandingthePivotTableStructureInthethumbnailabove,I’velabeledthemainareasofthepivottable.(1)PivotTableFieldList–thissectioninthetoprightdisplaysthefieldsinyourspreadsheet.Youmaycheckafieldordragittoaquadrantinthelowerportion

7、.3(2)Thelowerrightquadrants-thisareadefineswhereandhowthedatashowsonyourpivottable.Youcanhaveafieldshowineitheracolumnorrow.Youmayalsoindicateifthedatashouldbecounted,summed,averaged,filteredandsoon.(