Okuqukethwe
Ngamafuphi: Funda indlela yokudala ishadi lebha elisebenzisanayo (noma isakhiwo sokusabalalisa) ukuze libonise ulwazi olwengeziwe lapho ukhetha ikholomu ethile.
Izinga lobunzima: isilinganiso.
Ishadi lebha elisebenzisanayo
Nansi indlela i-histogram eqediwe ebukeka ngayo:
Bonisa ulwazi olwengeziwe lapho ikholomu ethile ikhethwa
I-histogram yokusabalalisa inhle ngoba ikuvumela ukuthi uqonde ngokushesha ukuthi idatha etholakalayo ihlakazwa kanjani ngobuningi obujwayelekile.
Esibonelweni sethu, sibheka idatha yenkokhelo yocingo yesisebenzi yenyanga. Ishadi lebha liqoqa abasebenzi ngamaqembu ngokusekelwe kusayizi we-akhawunti bese libonisa inani labasebenzi eqenjini ngalinye. Ishadi elingenhla libonisa ukuthi izisebenzi ezingama-71 zinesikweletu socingo sanyanga zonke phakathi kuka-$0 no-$199.
Ngaphezu kwalokho, siyabona ukuthi izisebenzi eziyi-11 zinesikweletu socingo esidlula u-$600 ngenyanga. Blimey! Yilokhu okwenzekayo uma uchitha isikhathi esiningi ku-Facebook! 🙂
Umbuzo uvela ngokushesha:Obani laba abanezikweletu ezinkulu kangaka???»
I-PivotTable engakwesokudla kweshadi ibonisa amagama abasebenzi kanye nenani lesikweletu sabo senyanga. Isihlungi sidalwa kusetshenziswa izisiki futhi silungiselwe ukubonisa kuphela lezo zisebenzi ezingamalungu eqembu elikhethiwe ohlwini.
Lisebenza kanjani leli shadi?
Isisiki esinemingcele yeqembu siboniswa ngaphezu kwamalebula e-eksisi evundlile yeshadi. Ngenxa yalokho, kubukeka sengathi amalebula e-eksisi avundlile, kodwa empeleni ucezu nje.
Isisiki sixhunywe ku-PivotTable kwesokudla futhi siqala ukuhlunga egameni leqembu. Isifunda Imigqa (Imigqa) yaleli thebula le-pivot liqukethe amagama abasebenzi, nendawo Amanani (Amanani) – inani le-akhawunti.
Idatha yokuqala
Idatha yokuqala iqukethe umugqa ohlukile womsebenzi ngamunye onolwazi mayelana nomsebenzi kanye nosayizi we-akhawunti yakhe. Kuleli fomu, idatha ngokuvamile inikezwa izinkampani zocingo.
Kukholomu G ithebula liwumsebenzi VPR (I-VLOOKUP) ebuyisela igama leqembu. Le fomula ibheka inani elivela kukholomu Inani leBill etafuleni tblGroups futhi ibuyisela inani elisuka kukholomu igama leqembu.
Qaphela ukuthi i-agumenti yokugcina VPR (VLOOKUP) kuyalingana TRUE (IQINISO). Lena yindlela umsebenzi ozobheka ngayo ikholomu Iqembu elincane ngifuna inani elivela kukholomu Inani leBill futhi ume kunani eliseduze elingeqi inani elifunekayo.
Ngaphezu kwalokho, ungakha amaqembu ngokuzenzakalela usebenzisa amathebula e-pivot ngaphandle kokusebenzisa umsebenzi VPR (I-VLOOKUP). Nokho, ngithanda ukusebenzisa VPR (I-VLOOKUP) ngoba lesi sici sikunikeza ukulawula okwengeziwe kumagama weqembu. Ungenza ngokwezifiso ifomethi yegama leqembu ngendlela othanda ngayo futhi ulawule imingcele yeqembu ngalinye.
Kulesi sibonelo, ngisebenzisa amathebula e-Excel ukuze ngigcine idatha yomthombo kanye nethebula lokubheka. Akunzima ukubona ukuthi amafomula aphinde abhekisele kumathebula. Kuleli fomu, amafomula kulula kakhulu ukufunda nokubhala. Akudingekile ukusebenzisa amaspredishithi e-Excel ukwenza lolu hlobo lomsebenzi, lokhu kungukukhetha kwami siqu.
I-Histogram ne-PivotTable
Lesi sibalo sibonisa i-PivotTable esetshenziswe ukudala ishadi lebha. Isifunda Imigqa (Imigqa) iqukethe amagama eqembu asuka kukholomu IQEMBU amathebula anedatha yomthombo, kanye nendawo Amanani (Amanani) aqukethe amanani asuka kukholomu Isibalo Segama. Manje singabonisa ukusatshalaliswa kwabasebenzi ngendlela ye-histogram.
Ithebula le-Pivot elinolwazi olwengeziwe
I-PivotTable, etholakala kwesokudla seshadi, ibonisa ulwazi olwengeziwe. Kuleli thebula le-pivot:
- Indawo Imigqa (Imigqa) iqukethe amagama abasebenzi.
- Indawo Amanani (Amanani) iqukethe ibhili yefoni yanyanga zonke.
- Indawo ehlunga (Izihlungi) ziqukethe amagama eqembu.
Isisiki sohlu lweqembu sixhunywe ku-PivotTable ukuze kuboniswe amagama asuka eqenjini elikhethiwe kuphela. Lokhu kukuvumela ukuthi ubonise ngokushesha uhlu lwabasebenzi abafakwe eqenjini ngalinye.
Ukuhlanganisa konke kusuka ezingxenyeni
Manje njengoba zonke izingxenye sezidaliwe, okusele nje ukusetha ukufometha kwe-elementi ngayinye ukuze kubukeke kukuhle ekhasini. Ungenza ngendlela oyifisayo isitayela sokusika ukuze usenze sibukeke sicocekile ngaphezulu kweshadi.
Yini enye esingayisebenzisela le nqubo?
Kulesi sibonelo, ngisebenzise idatha kuzikweletu zefoni zabasebenzi. Ngokufanayo, noma yiluphi uhlobo lwedatha lungacutshungulwa. Ama-histograms mahle ngoba akuvumela ukuthi uthole ngokushesha ulwazi mayelana nokusatshalaliswa kwedatha, kodwa ngokuvamile udinga ukuthola ulwazi oluningiliziwe mayelana neqembu elilodwa. Uma ungeza izinkambu ezengeziwe kuthebula le-pivot, ungabona amathrendi noma uhlaziye isampula yedatha ewumphumela ujule nakakhulu.
Shiya imibono yakho futhi ubuze noma yimiphi imibuzo. Unentshisekelo yokwazi ukuthi uyisebenzisa kanjani noma uhlela ukuyisebenzisa kanjani indlela ebonisiwe?
Ngiyabonga!