Amatafula e-Pivot ku-Excel yithuluzi lokubika elisebenzelana nezimo ezenza kube lula ukukhipha ulwazi kusuka kumatafula amakhulu yedatha ngaphandle kokusebenzisa amafomula.
Amatafula we-Pivot asebenziseke kakhulu ngokwenza lokho ngokuhambisa, noma ukuguqula, amasimu wedatha kusuka kwenye indawo kuya kwenye usebenzisa ihudula bese uphonsa singabuka idatha efanayo ngezindlela eziningi ezahlukene.
Lesi sifundo sihlanganisa ukudala nokusebenzisa itafula le-pivot ukuze lisuse ulwazi oluhlukile kusuka kwisampula eyodwa yedatha (sebenzisa lolu lwazi ukuze uthole ulwazi).
01 ka-06
Faka idatha yePivot Table
Isinyathelo sokuqala ekudaleni ithebula le-pivot ukufaka idatha kushidi lokusebenzela .
Uma wenza kanjalo, gcina izingqondo ezilandelayo engqondweni:
- Okungenani amakholomu amathathu wedatha adingekayo ukudala ithebula le-pivot.
- Kubalulekile ukufaka idatha ngendlela efanele. Amaphutha, abangelwa ukungena kwedatha okungalungile, angumthombo wezinkinga eziningi ezihlobene nokuphathwa kwedatha.
- Shiya imigqa noma amakholomu angenalutho uma ufaka idatha. Lokhu kuhlanganisa ukungashiyi umugqa ongacacile phakathi kwezihloko zekholomu kanye nomugqa wokuqala wedatha.
Faka idatha kumaseli A1 kuya ku-D12 njengoba kuboniswa esithombeni ngenhla.
02 ka 06
Ukudala ithebula le-Pivot
- Gqamisa amaseli A2 kuya ku-D12.
- Chofoza ku-Faka ithebhu ye-ribbon.
Chofoza umcibisholo ophansi phansi kwe-Pivot Table inkinobho ukuze uvule uhlu lokudonsa phansi. - Chofoza ku- Pivot Table ohlwini ukuze uvule ibhokisi lengxoxo ye- Pivot Table .
Ngaphambi kokukhetha uhla lwamafayela A2 kuya ku-F12, umugqa weThebula / Uhlu ebhokisini lebhokisi kumele ligcwaliswe kithi. - Khetha ishidi lokusebenzela elikhona endaweni yetafula le-pivot.
Chofoza kulayini wendawo ebhokisini lengxoxo. - Chofoza kuseli D16 kushidi lokusebenzela ukuze ufake leyo reference yeselula endaweni yendawo.
Chofoza OK.
Ithebula le-pivot elingenalutho kufanele livele ephepheni lokusebenzela ngekhoneni eliphezulu lesobunxele letafula le-pivot kuseli D16.
Iphaneli ye- Pivot Table Field Field kufanele ivule ngakwesokudla ngakwesokudla kwewindi le-Excel.
Phezu kwepaneli ye- Pivot Table Field List kukhona amagama ensimu (izihloko zekholomu) ezivela kuthebula lethu lemininingwane. Izindawo zedatha ezansi kwephaneli zixhunywe kuthebula le-pivot.
03 ka 06
Ukungeza idatha kudatha le-Pivot
Qaphela: Ukuze uthole usizo ngalezi ziqondiso bheka isibonelo sithombe ngenhla.
Unezinqumo ezimbili uma kuziwa ekwengezeni idatha kuThebula lePivot:
- Hudula amagama ensimu kuphaneli ye- Pivot Table Field Field bese uwaphonsa kuthebula le-Pivot ekhasini lokusebenzela.
- Hudula amagama ensimu phansi kwephaneli ye- Pivot Table Field Field bese uwaphonsa ezindaweni zedatha.
Izindawo zedatha ephaneli ye- Pivot Table Field List zixhunywe ezindaweni ezihambelana netafula le-pivot. Njengoba ufaka amagama ensimu ezindaweni zedatha, idatha yakho ingeziwe kuthebula le-pivot.
Kuye ngokuthi yiziphi izinkambu ezibekiwe endaweni yedatha, imiphumela ehlukene ingatholakala.
Hudula amagama ensimu kulezi zindawo zedatha:
- Ukuthengiswa okuphelele endaweni yendawo yokuhlunga
- Isifunda endaweni yelabula lamakholomu
- Indawo yokuthengisa endaweni yendawo ye- Row Labels
- I-oda ukuya endaweni yama- Values
- Uma usuqediwe, i-Pivot Table kufanele ibe nedatha ehlelwe ngendlela efanayo nesibonelo esiteji soku-1 salesi sifundo.
04 ka 06
Ukuhlunga idatha ye-Pivot Table
Ithebula le-Pivot lenze amathuluzi wokuhlunga ngaphakathi ngaphakathi angasetshenziswa ukuhlehlisa imiphumela eboniswa i-Pivot Table.
Ukuhlunga idatha kuhilela ukusebenzisa izindlela ezithile zokunciphisa ukuthi iyiphi idatha eboniswa yi-Pivot Table.
- Chofoza umcibisholo ophansi oya esiFundazweni esiya etafuleni le-Pivot ukuze uvule uhlu lokuhlunga lokuhlunga.
- Chofoza ebhokisini lokuhlola eduze kweNketho Yonke Yonke ukuze ususe uphawu lokuhlola kusuka kuwo wonke amabhokisi alolu hlu.
- Chofoza amabhokisi okuhlola eduze nezinketho zaseMpumalanga naseNyakatho ukwengeza amamaki amasheya kulawa mabhokisi.
- Chofoza OK.
- Ithebula le-Pivot kufanele libonise kuphela inani le-oda le-reps yokuthengisa esebenza ezindaweni zaseMpumalanga naseNyakatho.
05 ka 06
Ukushintsha idatha yePivot Table
Ukuze ushintshe imiphumela eboniswe i-Pivot Table:
- Hlela kabusha itafula le-pivot ngokudonsa amasimu wedatha kusuka endaweni eyodwa yedatha kuya kwelinye iphaneli ye-Pivot Table Field Field.
- Faka isicelo sokuhlunga ukuze uthole imiphumela oyifunayo.
Hudula amagama ensimu kulezi zindawo zedatha:
- I-oda kuya endaweni yokuhlunga umbiko
- I-Sales Rep eya endaweni yelebula lamakholomu
- Isifunda esifundeni se- Row Labels
- Ingqikithi Yokuthengisa kuya endaweni yama- Values
- Chofoza umcibisholo ophansi oya esiFundazweni esiya etafuleni le-Pivot ukuze uvule uhlu lokuhlunga lokuhlunga.
- Chofoza kabili ebhokisini lokuhlola eduze kwenketho ye- Khetha Yonke ukufaka kuqala bese ususa amaki amasheke kuzo zonke amabhokisi alolu hlu.
- Chofoza ebhokisini lokuhlola eduze neNtshonalanga yokukhetha ukwengeza uphawu lokuhlola kuleli bhokisi.
- Chofoza OK.
- Ithebula le-Pivot kufanele libonise ukuthengiswa okuphelele kwalezo zinsuku zokuthengisa kuphela ezisebenza esifundeni saseNtshonalanga.
06 ka-06
Isibonelo se-Pivot Table
Nasi isibonelo sendlela ithebula lakho le-pivot lingabuka ngayo.