Qhathanisa amashidi amabili e-Excel Kungaba nzima uma zombili zifana ncamashi. Ngenhlanhla, asikho isidingo sokuthi sihlole idatha ngayinye ngayinye, ngoba lolu hlelo lusinika izindlela ezilula nezisheshayo zokwenza iziqhathaniso.
Ngaphezu kwalokho, kukhona amathuluzi angaphandle kweMicrosoft angasisiza futhi emsebenzini wokuqhathanisa. Qhubeka ufunde futhi uthole ukuthi ungaqhathanisa kanjani idatha ngendlela ephumelela kakhulu nelula ngangokunokwenzeka.
Kungani kungase kudingeke siqhathanise amashidi amabili e-Excel?
Lona umsebenzi ovame kakhulu ezindaweni ezifana nokubalwa kwezimali noma ukuphathwa kwephrojekthi. Ngayo sifuna ukuhlonza umehluko, sithole amaphutha futhi siqinisekise imininingwane ukuze kamuva senze izinqumo ezinolwazi.
Kunezizathu eziningi zokuthi kungani singadinga ukuqhathanisa amashidi e-Excel, kodwa sizokutshela avame kakhulu:
- Thola amaphutha noma ukungezwani. Uma siqhathanisa amasethi amabili edatha singathola okufakiwe okungalungile, izibalo eziyiphutha, noma amanani ayimpinda. Lokhu kubalulekile uma sifuna ukuqinisekisa ukunemba kolwazi.
- Yenza ucwaningo. Ngokuqhathanisa inguqulo yamanje yesipredishithi nenguqulo yaso yangaphambili singabona ukuthi yiziphi izinguquko ezenziwe futhi sihlole ukuthi awekho yini amaphutha enzekile kule nqubo.
- Qinisekisa idatha. Uma siqhathanisa idatha eseshidini elilungiswe yithi naleyo equkethwe eshidini elilungiselelwe umuntu wesithathu, singabheka ulwazi esinalo futhi siqinisekise ukunemba nokuvumelana kwalo.
- Hlaziya amathrendi. Ngokuqhathanisa idatha yezikhathi ezahlukene singakwazi ukubona amaphethini namathrendi asisiza ekwenzeni izinqumo.
Ezinye izibonelo ezisebenzayo zokuqhathanisa amashidi e-Excel
- Ukubika Ukuqhathanisa izinkokhelo noma ukuqinisekisa ama-invoyisi asazokhokhwa.
- Abasebenzi Ingasetshenziselwa ukuhlola ukubakhona kwabasebenzi noma ukuhlaziya inzuzo yabasebenzi.
- Ukuthengisa. Kulo mkhakha womsebenzi usetshenziselwa ukuqhathanisa imiphumela yemikhankaso ehlukene futhi uhlaziye imbuyiselo ekutshalweni kwezimali.
- Ukukhiqiza. Okunye ukusetshenziswa kwayo kungaba ukuqhathanisa izinhlelo zokukhiqiza nokukhiqizwa kwangempela.
Singaqhathanisa kanjani amashidi amabili e-Excel
Ithuluzi leMicrosoft lisinikeza amathuba amaningi okwenza isiqhathaniso:
Ukufuduka okuhambisanayo
Ngalo msebenzi obonakalayo singaqhathanisa amaspredishithi amabili ngesikhathi esisodwa, siskrole kuwo womabili ngesikhathi esisodwa. Lokhu kwenza kube lula ukubona ukufana nokungafani.
Okufanele ukwenze ukusebenzisa lolu hlelo:
- Vula amaspredishithi amabili ofuna ukuwaqhathanisa encwadini yokusebenzela ye-Excel efanayo.
- Iya kuthebhu ethi "Buka" futhi eqenjini elithi "Iwindi" khetha "Iwindi elisha".
- Ngaphakathi kwefasitela lencwadi ngayinye phindela kokuthi “Buka” > “Iwindi” kanye nokuthi “Buka eceleni”.
- Khetha inketho ethi "Ukuskrola Okuvumelanayo".
Uma lokhu sekwenziwe, lapho uhamba ne-pointer yegundane eshidini lokuqala, ukunyakaza kuzokwenziwa ngendlela efanayo kwesibili.
Yabelana ngamavelu futhi uthole idatha elinganayo
Lokhu kusivumela ukuthi sibone idatha efana nawo womabili amashidi. Ukufeza lokhu sinezinketho ezimbalwa:
sebenzisa amafomula
Ifomula ethi “VLOOKUP” inesibopho sokusesha inani kukholomu yokuqala yethebula ngalinye futhi ibuyisele inani kumugqa ofanayo wekholomu eshiwo.
Isibonelo, uma unamagama kukholamu A kuwo womabili amashidi, ungasebenzisa i-VLOOKUP ukuze uhlole ukuthi elinye lamagama avela eshidini 1 nalo likushidi lesi-2 yini.
umsebenzi wokufanisa
Ibuyisela indawo ehlobene yenani phakathi kwamalungu afanayo. Ngokusebenzisa okuthi MATCH uhlelo luthola umugqa lapho inani livela kuwo womabili amashidi.
Qhathanisa amanani
Uma esikudingayo kuwukuqhathanisa amanani emashidini amabili ahlukene futhi sazi ukuthi ayalingana, makhulu, angaphansi noma ahlukile kunevelu yokuqhathanisa, singasebenzisa amafomula alandelayo:
= Ilingana no (A1=B1)
> Kukhulu kuno-(A1>B1)
= Mkhulu noma ulingana no (A1>=B1)
Ngaphandle kokuthi (A1B1)
Ifomethi enemibandela
Kusivumela ukuthi sazi ukuthi yimaphi amaseli aqukethe amanani ahlukene. Khetha lonke ithebula ekhasini lokusebenzela bese uvula “Ukufometha Okunemibandela” kuthebhu ethi “Ekhaya” ngaphakathi kwenketho ethi “Izitayela”.
Khetha uhlobo lomthetho ozosetshenziswa bese ufaka ifomula kokuthi “Ifomethi”. Ungasebenzisa lokhu: = A1 Sheet1! A1. Bese ukhetha umbala lapho umehluko uzogqanyiswa khona bese uchofoza okuthi “Yamukela”.
Qhathanisa izincwadi zokusebenza ezimbili ze-Excel
Ezinye izindlela esizibonile zisivumela ukuthi siqhathanise amashidi amabili e-Excel asencwadini yokusebenzela efanayo. Enye inketho kungaba ukuqhathanisa amashidi ezincwadi ezahlukene.
Kufanele uye kokuthi “Qala futhi Qhathanisa Amafayela” bese uchofoza isithonjana sefolda eluhlaza okwesibhakabhaka esivela eduze kwebhokisi elithi “Qhathanisa”. Ukusuka lapho bheka indawo yencwadi yokuqala. Bese uye kusithonjana sefolda eluhlaza eduze kokuthi "Kuya" futhi uthole indawo yencwadi yesibili. Chofoza okuthi “Yamukela”.
Kuphaneli engakwesokunxele, khetha izinketho ofuna ukuzibona emiphumeleni yokuqhathanisa noma uyitshele ngokuqondile ukuthi iqhathanise yonke into. Uhlelo luzokwenza umsebenzi walo futhi likugqamise izinto ezahlukene.
Qhathanisa amashidi amabili e-Excel namathuluzi angaphandle
Uma ufuna ukwenza ukuqhathanisa kalula futhi ngokushesha, kukhona amathuluzi angaphandle awusizo kakhulu kuleli cala.
I-synchronizer Excel
Iqhathanisa idatha nokunemba okukhulu futhi ikunikeza umbiko ophelele ukuze wazi ukuthi imaphi amakholomu, imigqa, amaseli namavelu aqukethe idatha ehlukile. Ngaphezu kwalokho, ungakwazi lungisa ithuluzi ukuze linembe njengoba udinga.
I-drawback yayo kuphela ukuthi ikhokhelwe. Ikunikeza isilingo samahhala, kodwa uma kufanele uqhathanise amaspredishithi njalo, ungase ube nentshisekelo yokuthenga ilayisense.
I-Ultimate Suite
Le nkundla iqukethe izicelo ezingaphezu kuka-60 ze-Excel futhi, vele, ungenza ukuqhathanisa phakathi kwamashidi. Okuthile okuphawuleka kakhulu ukuthi isibonisa imiphumela ngendlela ebonakalayo kakhulu, ngoba igqamisa amaseli anedatha eguquliwe ngokuluhlaza. Imigqa eseshidini elilodwa kodwa hhayi kwelinye igqanyiswe ngokuluhlaza okwesibhakabhaka, futhi lezo ezengezwe eshidini lesibili zikhonjiswe ngokubomvu.
I-GroupDocs Comparison
Kuyithuluzi lamahhala elingadingi ukuthi ubhalise njengomsebenzisi kuwebhusayithi yalo. Okufanele ukwenze nje ukulayisha izincwadi zokusebenza ezimbili ze-Excel ukuze uziqhathanise futhi uyeke yenze umsebenzi wayo. Ngemva, ungahlanganisa womabili amafayela ukuze ubone umehluko phakathi kwakho kokubili bese ulanda imiphumela.
Njengoba ubonile, kunezinketho eziningi zokuqhathanisa amashidi amabili e-Excel. Kufanele nje uthole leyo evumelana kangcono nalokho okudingayo.