Khiqiza ibhakhodi ku-Excel igxathu negxathu

I-Excel uhlelo lokusebenza olunenombolo engapheli yemisebenzi ekhethekile, kwesinye isikhathi esingayazi, njengoba kunjalo nge Khiqiza ibhakhodi ku-Excel. Uma ufuna ukwazi ukuthi ungazenaba kanjani igxathu negxathu, sikumema ukuthi ufunde i-athikili elandelayo futhi ufunde kabanzi ngale ndaba.

Khiqiza ibhakhodi ku-Excel: Amayelana nani la makhodi?

Ngaphambi kokubuka izinyathelo okufanele sizisebenzise ukulungisa ibhakhodi, kufanele sazi ukuthi lawa masethi amancane olayini aqukethe imininingwane eningiliziwe ngento noma umkhiqizo, okwenza kube lula ukuyibona lapho kulungiswa uhlu lwezimpahla noma kuthintwa izici.

Inqubo yokwakha lamakhodi ngezinhlelo ezifana ne-Excel, imvamisa ibonakala ingumsebenzi ongenakwenzeka, kodwa-ke, ilula kakhulu.

Izinyathelo zokukhiqiza ibhakhodi ku-Excel

1. Landa iphakethe lefonti yebhakhodi ye-Excel.
2. Qonda ku-Excel bese uvula ispredishithi esisha.
3. Bhala ifomula yebhakhodi kukholamu A. (Kufanele ibe nezinhlamvu noma izinombolo nezikhala phakathi kwazo kuphela).
4. Yandisa ikholomu B, ukuze ukwazi ukufaka isithombe sebhakhodi.
5. Chofoza kusithonjana ukufaka izithombe ndawonye kukholamu B.
6. Qhafaza kwesokudla ifomula obuyibeke ngaphambilini kukholamu A bese uyikopisha.
7. Bese unamathisela ifomula kukholamu B.
8. Iya kumenyu bese ukhetha "ifonti", lapho kufanele uthole bese ukhetha ifonti oyifunayo kubhakhodi.
9. Uzobona ukuthi ifomula yenzeka kanjani ukwenza ibhakhodi.
10. Khetha bese ulungisa usayizi ofuna ukuthi ube.
11. Hlola ngokucophelela ukuthi iyibhakhodi elungile ngokuya ngefomula, ngoba ivame ukudala amaphutha.

Amasu wokufaka ama-barcode ku-Excel

Faka isithombe njengebhakhodi ku-Excel

Kungathathwa njengeqhinga elilula ukufaka ibhakhodi kuspredishithi sakho, ngoba ngemuva kokusebenzisa izinyathelo esabelane ngazo ngenhla ukudala ibhakhodi, uzokwazi ukuzitholela kukholamu lapho ufuna ukusibeka khona bese ufaka isithombe. Lokhu kufanele kuphindwe ngawo wonke amakhodi uze ufake onke owadingayo.

Sebenzisa ikhodi yomthombo nge-bar ye-Excel

Ukuze usebenzise lobu buqili, kufanele ulande ifonti ye-Bar-Code 39 noma ye-Code 39 kwelinye lamakhasi anconywe yinjini yokusesha. I-Excel inenketho yokukwazi ukufaka inketho yokuthayipha noma yefonti kumenyu bese ungeza ibhakhodi ebhokisini lohlelo lokusebenza.

Uma ifonti isifakiwe, kunconywa ukuthi uqale kabusha ikhompyutha yakho ukuze uqiniseke ukuthi isebenza kahle. Ngemuva kokuqala ikhompyutha futhi, kufanele uvule idokhumenti entsha ku-Excel ukuze uqale ukudala uhlu lwamathebula alandelayo:

• Inombolo yomkhiqizo, okumele ifane nebhakhodi.
• Ibhakhodi.
• Ubuningi noma amayunithi.
• Intengo yocezu ngalunye.
• Inani eliphelele lomkhiqizo, ngokuya ngobuningi noma amayunithi akhonjisiwe.

Lapho usunayo yonke imininingwane yomkhiqizo ngamunye, iya kukholamu B bese usebenzisa ifonti oyifakile phambilini, kungaba yi-Bar-Code 39 noma i-Code 39.

Faka ibhakhodi ku-Excel ngosizo lwama-macros

Kungenzeka ukuthi awuzwanga nge-Excel macros, kepha lawa amanye amakhodi wokuhlela asetshenziselwa ukwenza imisebenzi ishidi lolu hlelo lokusebenza. Ngolimi lohlelo lwe-VBA, kungenzeka ukudala imiyalo ehlukile noma ukusebenza kuspredishithi, kukusebenzisa ngokuzenzakalela.

Leli qhinga imvamisa liyinkimbinkimbi kunazo zonke, kepha imvamisa lisebenza kakhulu uma kukhulunywa ngokulisebenzisa. Ukuqala, kufanele usebenzise inketho kanjiniyela kumenyu ye-Excel, usebenzise lezi zinyathelo ezilandelayo:

1. Iya kuthebhu "Ifayela".
2. Bese ukhetha "izinketho", kulandelwe "Yenza ngokwezifiso iribhoni".
3. Chofoza ku- "Unjiniyela". Ngale ndlela izobe isivele isebenza.

Uma ngabe le ndatshana ikusizile, sikumema ukuba ufunde kabanzi mayelana nokuthi kanjani Ngenisa idatha kusuka ku-PDF kuya ku-Excel ngokuphepha nangokushesha?, lapho ungathola khona yonke idatha yokwenza.