Iitafile zePivot kwi-Excel zixhobo ezixhamlayo zokubika ezenza kube lula ukukhipha ulwazi oluvela kwiitheyibhile ezinkulu zeedatha ngaphandle kokusetyenziswa kwamafomula.
Iitafile zePivot zixhamla kakhulu ngomsebenzisi kuloo nto ngokuhambisa, okanye ukujikeleza, iindawo zedata ukusuka kwindawo enye ukuya kwelinye usebenzisa ukudonsa nokuphonsa singakhangela idatha efanayo kwiindlela ezahlukeneyo.
Le tutorial iquka ukudala nokusebenzisa itafile ye-pivot ukuze ikhuphe ulwazi oluhlukileyo kwisampuli enye yedatha (sebenzisa le ngcaciso kwi-tutorial).
01 ngo-06
Faka idatha yePivot Table
Isinyathelo sokuqala ekudaleni itafile yepivot kukufaka idatha kwiphepha lokusebenzela .
Xa wenza njalo, gcina iingongoma ezilandelayo engqondweni:
- Ubuncinane iikholomu zedatha zifunekayo ukudala itafile yepivot.
- Kubalulekile ukungena idatha ngokuchanekileyo. Iimpazamo, ezibangelwa ukungena kwedatha engafanelekanga, ziyimvelaphi yeengxaki ezininzi ezinxulumene nokuphathwa kwedatha.
- Shiya akukho miqolo okanye iikholam ezingenanto xa ufaka idatha. Oku kubandakanya ukushiya umgca ongagqibekanga phakathi kwezihloko zekholomu kunye nomqolo wokuqala wedatha.
Faka idatha kwiiseli A1 ukuya kwi-D12 njengoko kuboniswa kumfanekiso ongentla.
02 we-06
Ukudala iTable Pivot
- Gqamisa iiseli ezi-A2 ukuya kwi-D12.
- Cofa kwi-Insert ithebhu yebhebhoni.
Cofa kwinqolo engezantsi kwiqhosha le Pivot Table ukuvula uluhlu lokuhlahla. - Cofa kwi- Table yePivot kwoluhlu ukuvula ibhokisi yencoko yebhokisi ye- Pivot Table .
Ngaphambi kokukhetha udidi lweedatha A2 ukuya ku-F12, umgca wetafile / Udidi kwibhokisi yencoko kufuneka izaliswe kuthi. - Khetha iWindows Worksheets for the place table of pivot.
Cofa kwi Indawo yendawo kwibhokisi yencoko. - Cofa kwiseli D16 kwiphepha lokusebenzela ukuze ufake eso saziso sesalathisi kwindawo yomda.
Chofoza OK.
Itafile ye-pivot engenanto kufuneka ibonakale kwiphepha lokusebenzela kunye nekona eliphezulu lasekhohlo letafile ye-pivot kwiseli D16.
Ipaneli yeePivot yeeLebhu zePivot kufuneka ivule kwicala lasekunene leWindows window.
Kuphezulu kwipaneli yoLuhlu lweePivot yeThala lweeDivama zeziNdawo ngamagama ensimu (izihloko zekholomu) ezivela kwitheyibhile yethu yedatha. Iinkalo zeenkcukacha ezantsi kwepaneli zidibene netafile yepivot.
03 we-06
Ukongeza idatha kwiTable Table
Qaphela: Ukuze uncedo ngale miyalelo ubone umzekelo wesentla apha.
Unokukhetha ezimbini xa kuziwa ekongezeni idatha kwiTable Table:
- Dragula amagama ensimi kwiPaneli yeeLuhlu lweePivot yeeLuhlu lweeDwecwe uze uwaye kwiTable Pivot kwiphepha lokusebenzela.
- Dragula amagama ensimu kwizantsi lePivot Table List Uhlu lweeNdawo zePivot kunye nokuwayeka kwiindawo zeenkcukacha.
Iindawo zeenkcukacha kwiPaneli yePivot Table List List zidibaniswe kwiinkalo ezihambelana netafile yepivot. Njengoko ungeze igama lamasimu kwiindawo zeenkcukacha, idatha yakho ifakwe kwitafile yepivot.
Ngokuxhomekeke kwiziphi iindawo ezibekwa kuyo indawo yedata, iziphumo ezahlukeneyo ziyafumaneka.
Udonsa amagama enkundla kule mimandla yedatha:
- Intengiso Yonke kwiNgingqi yeFayile yeNgxelo
- Ummandla kwiNgingqi zeLebhankile
- Indawo yokuThengisa kwiNgingqi yeeLebhethi
- Amanqaku kummandla weeMilinganiselo
- Xa sele igqityiwe, iThebula lePivot kufuneka libe nedatha echazwe kwimiyalelo efanayo njengoko umzekelo kwisinyathelo soku-1 sale khokelo.
04 we-06
Ukucoca idatha yePivot Table
Ithebula lePivot liye lazakhela izixhobo zokucoca ezingasetyenziselwa ukuhlaziya iziphumo eziboniswe yiTable Pivot.
Idatha yokucoca ibandakanya ukusetyenziswa kweendlela ezichanekileyo zokunciphisa ukuba yeyiphi idatha eboniswa yiTable Table.
- Cofa kwinqolo ephantsi kwinqanaba elibhekise kwiPivot Table ukuze uvule uluhlu lokuhlahla kwenhlawulo.
- Cofa kwibhokisi yokukhangela ecaleni kwindlela yokukhetha Yonke inokukhupha uphawu lokukhangela kuzo zonke iibhokisi eziluhlu.
- Cofa kwiibhokisi zokutshekisha ezantsi kwindlela ongakhetha kuyo kwi- East nakwiNtshonalanga ukuze ungeze uphawu lokujonga kwiibhokisi.
- Chofoza OK.
- Ithebula lePivot kufuneka libonise kuphela ixabiso leemali zokuthengiswa kwee-reps ezisebenza kwimimandla yaseMpuma nakumaMntla.
05 ka 06
Ukutshintsha idatha yePivot Table
Ukutshintsha iziphumo eziboniswe yiTable Pivot:
- Hlela kwakhona itafile ye-pivot ngokudonsa iinkcukacha zeenkcukacha ukusuka kwindawo enye yedatha ukuya kwelinye kwipaneli ye-Pivot Table Field List.
- Faka isicelo sokuhlunga ukufumana iziphumo ezifunwayo.
Udonsa amagama enkundla kule mimandla yedatha:
- Imiyalelo kwiNgingqi yeFayile yeNgcaciso
- Indawo yokuThengisa kwiindawo zokuLebhala zeeLowuni
- Ummandla kwiNgingqi yeeLebhu zeRow
- Intengiso yokuThengisa kwiiMilinganiselo
- Cofa kwinqolo ephantsi kwinqanaba elibhekise kwiPivot Table ukuze uvule uluhlu lokuhlahla kwenhlawulo.
- Cofa kabini kwibhokisi yokubhekisa ecaleni kwindlela yokukhetha Yonke ukongeza okokuqala uze ususe amanqaku okutshekisha kuzo zonke iibhokisi eziluhlu.
- Cofa kwibhokisi yokubhekisa ecaleni kweNtshona ukukhetha ukongeza uphawu lokukhangela kule bhokisi.
- Chofoza OK.
- Ithebula lePivot ngoku kufuneka libonise ukuthengiswa kwee-total sales reps kuphela ezisebenza kwindawo yesentshona.
06 we-06
Umzekelo wePivot Table
Nasi umzekelo wendlela ithebula lakho lokubheka lingabonakala ngayo.