Ukuhlanganiswa kwedatha ku-Excel - ukuthi kwenziwa kanjani, futhi yiziphi izidingo zamathebula

Ukuhlanganiswa Kwedatha kuyisici ku-Excel, ngenxa yokuthi abasebenzisi banethuba lokuhlanganisa idatha esuka kumathebula amaningana baye kwelinye, kanye nokuhlanganisa amashidi akumafayela afanayo noma ahlukene abe elilodwa.

Izidingo ezisemthethweni zamathebula adingekayo ukuze kuqedelwe ukuhlanganisa

Inketho ebizwa ngokuthi "Hlanganisa" ngeke isebenze uma amathebula engahlangabezani nezidingo. Ukuze uqedele ngempumelelo inqubo yokuhlanganisa idatha, kufanele:

• hlola ithebula ukuze uthole imigqa/amakholomu angenalutho bese uwasusa uma ekhona;
• sebenzisa izifanekiso ezifanayo;
• landela amagama amakholomu, akufanele ahluke.

Izindlela Zokuhlanganisa Eziyisisekelo ku-Excel

Lapho uhlanganisa idatha evela emibikweni ehlukene, amathebula, ububanzi bohlobo olufanayo kufayela elilodwa elivamile, ungasebenzisa izindlela ezimbalwa ezihlukene. Izindlela ezimbili eziyinhloko zokufingqa idatha zizoxoxwa ngezansi: ngesikhundla nangesigaba.

• Kokuhlukile kokuqala, idatha esezifundeni zangempela ilandelana okufanayo lapho kusetshenziswa khona amalebula afanayo. Goqa ngesikhundla ukuze uhlanganise idatha esuka kumakhasi angu-3-4 asekelwe kusifanekiso esifanayo, isibonelo, izitatimende zezimali zifanelekile ukuhlola le ndlela.
• Okukhethwa kukho kwesibili: idatha ihlelwe ngokungahleliwe, kodwa ibe namalebula afanayo. Hlanganisa ngesigaba ukuze uhlanganise idatha evela kumakhasi okusebenzela amaningi anezakhiwo ezihlukene kodwa amalebula edatha afanayo.

Kubalulekile! Le ndlela inokuningi efana ngayo nokwakhiwa kwethebula le-pivot. Nokho, ungakwazi ukuhlela kabusha izigaba ku-PivotTable. 

• Kukhona nendlela yesithathu yokuhlanganisa idatha - lokhu ukuhlanganisa usebenzisa amafomula. Yiqiniso, akuvamile ukusetshenziswa ekusebenzeni, ngenxa yokuthi kuthatha isikhathi esiningi kumsebenzisi.

Imiyalo yesinyathelo ngesinyathelo yokwenza ukuhlanganiswa ku-Excel

Okulandelayo, sizocabangela indlela elula neshesha kakhulu yokuhlanganisa.

Ngakho, indlela yokujoyina amathebula amaningi:

1. Okokuqala udinga ukudala ishidi elisha, ngemva kwalokho isofthiwe izolengeza ngokuzenzakalelayo ngakwesokudla. Uma kunesidingo, ungadonsela ishidi kwenye indawo (isibonelo, kuze kube sekugcineni kohlu) usebenzisa inkinobho yegundane engakwesokunxele.
2. Ishidi elingeziwe, yima kuseli ozosebenza ngalo. Bese uye kuthebhu ethi "Idatha", thola isigaba "Ukusebenza ngedatha", chofoza entweni ebizwa ngokuthi "Ukuhlanganisa".
3. Iwindi lezilungiselelo elincane lizovela kumonitha.
4. Okulandelayo, uzodinga ukukhetha umsebenzi ofanelekile ukuze uhlanganise idatha.
5. Ngemva kokukhetha umsebenzi, yiya kunkambu ethi “Xhumanisa” ngokuchofoza ngaphakathi kwayo. Lapha uzodinga ukukhetha uhla lwamaseli ngalinye ngalinye. Ukuze wenze lokhu, qala ushintshele eshidini elinepuleti lokuqala.
6. Bese ukhetha ipuleti kanye nonhlokweni. Qiniseka ukuthi yonke into yenziwe ngendlela efanele, bese uchofoza kusithonjana "Engeza". Ngendlela, ungabuyekeza / uguqule izixhumanisi ngokwakho usebenzisa ikhibhodi, kodwa lokhu akulungile.
7. Ukuze ukhethe ububanzi kudokhumenti entsha, qala uyivule ku-Excel. Ngemuva kwalokho, qala inqubo yokuhlanganisa encwadini yokuqala bese ushintshela kweyesibili, khetha ishidi elifanele kulo, bese ukhetha ingxenye ethile yamaseli.
8. Ngenxa yalokho, ukufakwa kokuqala kuzokwakhiwa kokuthi “Uhlu Lwezinhlanga”.
9. Buyela kunkambu ethi "Xhuma", susa lonke ulwazi oluqukethe, bese wengeza izixhumanisi zamapuleti asele ohlwini lobubanzi.
10. Khetha amabhokisi aseduze kwemisebenzi elandelayo: “Amalebula Omugqa Ophezulu”, “Amanani Ekholomu Yesokunxele”, “Khiqiza Izixhumanisi Eziya Kudatha Yomthombo”.
11. Bese uchofoza u- "KULUNGILE".
12. I-Excel izokwenza inqubo futhi idale idokhumenti entsha ngokuya ngamapharamitha asethiwe kanye nemisebenzi ekhethiwe.

Esibonelweni, ukuxhumanisa kukhethiwe, ngakho okukhiphayo kwaqoqwa ukusiza ukukhombisa/ukufihla imininingwane.

Ulwazi olwengeziwe mayelana nokusebenzisa ububanzi, ukungeza nokukhipha izixhumanisi

• Ukuze usebenzise ububanzi obusha bokuhlanganisa idatha, uzodinga ukukhetha inketho ethi "Qoqa", chofoza inkambu ethi "Xhuma" bese ukhetha ububanzi noma ufake isixhumanisi. Ngemva kokuchofoza inkinobho ethi "Engeza", isixhumanisi sizovela ohlwini lobubanzi.
• Ukuze ususe isixhumanisi, sikhethe bese uchofoza kokuthi "Susa".
• Ukuze ushintshe isixhumanisi, sikhethe ohlwini lobubanzi. Izovela kunkambu ethi "Xhuma", lapho ingabuyekezwa khona. Ngemuva kokwenza izinguquko, chofoza inkinobho ethi "Engeza". Bese ususa inguqulo endala yesixhumanisi esilungisiwe.

Ukuhlanganiswa kwedatha kusiza ukuhlanganisa ulwazi oludingekayo olukhona hhayi kuphela kumathebula namashidi ahlukahlukene, kodwa nakwamanye amafayela (izincwadi). Inqubo yokuxuba ayithathi isikhathi esiningi futhi kulula ukuqala ukusebenzisa imiyalelo yesinyathelo ngesinyathelo.