Izikhala ezengeziwe embhalweni azibalahle noma iyiphi idokhumenti. Ikakhulukazi akudingeki ukuba avunyelwe ematafuleni anikezwa kubaphathi noma emphakathini. Kodwa noma ngabe uzosebenzisa idatha kuphela ngezinhloso zomuntu siqu, izikhala ezengeziwe zifaka ukwanda kwamasayizi wedokhumenti, okuyinto engalungile. Ngaphezu kwalokho, ukuba khona kwalezi zakhi ezingadingekile kwenza kube nzima ukucinga ifayela, ukusebenzisa izihlungi, ukusetshenziswa kokuhlunga kanye namanye amathuluzi. Ake sithole ukuthi ungawathola ngokushesha futhi ususe kanjani.
Isifundo: Susa izikhala ezinkulu ku-Microsoft Word
Ubuchwepheshe bokususa i-Gap
Masinyane kufanele ngithi izindawo eziku-Excel zingaba nezinhlobo ezahlukene. Lezi zingaba izikhala phakathi kwamagama, isikhala ekuqaleni kokubaluleka futhi ekupheleni, abahlukanisi phakathi kwamadijithi ezinkulumo zenombolo, njll. Ngakho-ke, i-algorithm yokuqedwa kwabo kulezi zimo ihlukile.
Indlela 1: Sebenzisa Ithuluzi Lokubuyisela
Ithuluzi lenza umsebenzi omkhulu wokushintsha izindawo ezimbili eziphakathi kwamazwi nabangashadile ku-Excel "Faka esikhundleni".
- Ukuba ngaphakathi kuthebhu "Ikhaya", chofoza inkinobho "Thola futhi uqokomise"esitholakala kwibhulogi yamathuluzi Ukuhlela kwi-tape. Kuhlu lokudonsa phansi, khetha into "Faka esikhundleni". Ungase futhi esikhundleni sezenzo ezingenhla nje uthayiphe isinqamuleli sekhibhodi Ctrl + H.
- Kuzo zonke izinketho, i-"Find and Replace" iwindi ivula ithebhu "Faka esikhundleni". Ensimini "Thola" setha isikhombisi bese uchofoza kabili inkinobho Ibha yesikhala kwikhibhodi. Ensimini "Faka esikhundleni" faka isikhala esisodwa. Bese uchofoza inkinobho "Faka konke".
- Lolu hlelo lufaka indawo yesikhala esiphindwe kabili. Emva kwalokho, iwindi livela ngombiko ngomsebenzi owenziwe. Sicindezela inkinobho "Kulungile".
- Bese ifasitela ivela futhi. "Thola futhi ushintshe". Senza kule festile ngokuqondile izinyathelo ezifanayo njengoba kuchazwe esigabeni sesibili sale mfundiso kuze kube khona umlayezo obonakala uveza ukuthi idatha oyifunayo ayitholakalanga.
Ngakho-ke, sichithile izikhala ezimbili ezengeziwe phakathi kwamazwi asedokhumenti.
Isifundo: I-Excel Character Replacement
Indlela 2: susa izikhala phakathi kwamadijithi
Kwezinye izimo, izikhala zibekwe phakathi kwamadijithali ngezinombolo. Lokhu akuyona iphutha, kuphela ukubona okubukwayo kwezinombolo ezinkulu nje lolu hlobo lokubhala lungcono kakhulu. Kodwa nokho, lokhu akude kutholakale njalo. Isibonelo, uma iseli ingafomethiwe njengefomethi yenombolo, ukungezwa kwehlukanisi kungaphazamisa ukufaneleka kwezibalo emafomulini. Ngakho-ke, inkinga yokususa abahlukanisi abanjalo iba yiphuthumayo. Lo msebenzi ungafezwa usebenzisa ithuluzi elifanayo. "Thola futhi ushintshe".
- Khetha ikholomu noma ububanzi lapho ufuna ukukhipha khona ama-delimiters phakathi kwezinombolo. Lo mzuzu ubaluleke kakhulu, ngoba uma ngabe ibanga lingakhethiwe, ithuluzi lizosusa zonke izikhala kusuka kudokhumenti, kufaka hlangana namagama, okungukuthi, lapho kudingekile khona. Ngaphezu kwalokho, njengoba ngaphambili, chofoza inkinobho "Thola futhi uqokomise" ebhodini lamathuluzi Ukuhlela kwi-Ribbon kuthebhu "Ikhaya". Emenyu eyengeziwe, khetha into "Faka esikhundleni".
- Ifasitela iqala futhi. "Thola futhi ushintshe" kuthebhu "Faka esikhundleni". Kodwa manje sizofaka amanani ahlukile emasimini. Ensimini "Thola" setha isikhala esisodwa nensimu "Faka esikhundleni" sishiya ngokuvamile singenalutho. Ukuze uqiniseke ukuthi ayikho izikhala kule nsimu, setha isikhombisi kuso bese ubamba inkinobho yangemuva (ngesimo somcibisholo) ekhibhodi. Bamba inkinobho kuze kube yilapho isikhombisi sihlasela umkhawulo wesokunxele wensimu. Emva kwalokho, chofoza inkinobho "Faka konke".
- Uhlelo luzokwenza ukusebenza kokususa izikhala phakathi kwamadijithi. Njengendlela yangaphambilini, ukuqinisekisa ukuthi umsebenzi usuqedile ngokugcwele, senza usesho oluphindaphindiwe kuze kube yilapho umlayezo ubonakala ukuthi inani elifunayo alitholakali.
Ukuhlukana phakathi kwamadijithali kuzosuswa, futhi amafomula azoqala ukubalwa ngokufanele.
Indlela 3: susa abahlukanisi phakathi kwamadijithi ngokufometha
Kodwa zikhona izimo lapho ubona ngokucacile ukuthi kumadijithali wezashi ahlukaniswa ngezinombolo ngezikhala, futhi ukusesha akunikezi imiphumela. Lokhu kusikisela ukuthi kulokhu ukuhlukaniswa kwenziwa ngokufometha. Le nketho yesikhala ayithinti ukufaneleka kokuboniswa kwamafomula, kodwa ngesikhathi esifanayo, abanye abasebenzisi bakholelwa ukuthi ngaphandle kwalo, itafula lizobukeka lingcono. Ake sibheke indlela yokususa okukhethwa kukho okunjalo.
Njengoba izikhala zenziwe ngokusebenzisa amathuluzi wokufometha, kuphela ngamathuluzi afanayo angasuswa.
- Khetha ububanzi bezinombolo ezinezihlukanisi. Chofoza ekukhethweni ngenkinobho yegundane efanele. Emenyu evelayo, khetha into "Fometha amaseli ...".
- Ifasitela lokufometha iqala. Iya kuthebhu "Inombolo", uma kwenzeka ukuvulwa kwenzeka kwenye indawo. Uma ukuhlukaniswa kusetshenziswe ngokusebenzisa ukufometha, bese ku-block parameter "Amafomu Amanani" inketho kufanele ifakwe "Numeric". Endaweni efanele yefasitela yizilungiselelo eziqondile zale fomethi. Indawo eseduzane "I-group separator group") " udinga nje ukuyihlola. Khona-ke, ukuze izinguquko zisebenze, chofoza inkinobho "Kulungile".
- Iwindi yokufometha ivala, futhi ukuhlukaniswa phakathi kwamadijithi wezinombolo ebangeni elikhethiwe kuzosuswa.
Isifundo: Ukufometha kwethebula kwe-Excel
Indlela 4: Susa izikhala nomsebenzi
Ithuluzi "Thola futhi ushintshe" Kuhle ukukhipha izikhala ezengeziwe phakathi kwezinhlamvu. Kodwa kuthiwani uma badinga ukususwa ekuqaleni noma ekugcineni kwezwi? Kule ndaba, umsebenzi uvela eqenjini labathengi. I-CUTS.
Lo msebenzi ususa zonke izikhala kusukela embhalweni okhethiwe, ngaphandle kwezikhala ezilodwa phakathi kwamazwi. Okusho ukuthi, ukwazi ukuxazulula inkinga ngezikhala ekuqaleni kwegama esitokisini, ekupheleni kwegama, futhi nokususa izikhala ezimbili.
I-syntax yalolu opharetha ilula futhi inokuphikisana okulodwa kuphela:
= TRIMS (umbhalo)
Njengengxabano "Umbhalo" ingaba njengendlela yokubhala umbhalo, noma njengokubhekisela esitokisini lapho iqukethe khona. Esimweni sethu, kuphela ukukhetha okuzocatshangelwa.
- Khetha iseli elitholakala ngokuhambisana nekholomu noma umugqa lapho izikhala kufanele zisuswe khona. Chofoza inkinobho "Faka umsebenzi"itholakala ngakwesokunxele kwe-bar yefomula.
- I-Function Wizard iqala. Esikhathini "Uhlu oluphelele lwe-alfabhethi" noma "Umbhalo" ngifuna into "SZHPROBELY". Khetha bese uchofoza inkinobho. "Kulungile".
- Iwindi lempikiswano yokusebenza ivula. Ngeshwa, lo msebenzi awuhlinzeki ngokusetshenziswa kobubanzi obuyidingayo njengengxabano. Ngakho-ke, sibeka isikhombisi enkampanini ye-argument, bese ukhetha ilanga lokuqala lobubanzi esisebenza ngalo. Ngemuva kokuthi ikheli leseli likhonjiswe ensimini, chofoza inkinobho "Kulungile".
- Njengoba ubona, okuqukethwe kweseli kuboniswa endaweni lapho umsebenzi ukhona khona, kodwa ngaphandle kwezikhala ezengeziwe. Sisuse izikhala zento eyodwa kuphela yebanga. Ukuze ususe kwezinye amaseli, udinga ukwenza izenzo ezifanayo namanye amaseli. Yiqiniso, kungenzeka ukwenza umsebenzi ohlukile ngeseli ngalinye, kodwa lokhu kungathatha isikhathi esiningi, ikakhulukazi uma ibanga likhulu. Kunendlela yokusheshisa kakhulu inqubo. Setha isikhombisi ekhoneni elingaphansi kwesokudla leseli, esivele liqukethe ifomula. I-cursor iguqulwa ibe isiphambano esincane. Ibizwa ngokuthi uphawu lokugcwalisa. Bamba inkinobho yegundane lesokunxele bese uhudula isibambo sokugcwalisa ngokuhambisana nobubanzi ofuna ukususa izikhala.
- Njengoba ubona, ngemuva kwalezi zenzo kuhlanganiswa ibanga elisha eligcwele, lapho konke okuqukethwe kwendawo yomthombo kutholakala, kodwa ngaphandle kwezikhala ezengeziwe. Manje sibhekene nomsebenzi wokufaka amanani amanani okuqala ngedatha eguquliwe. Uma senza ikhophi elula, ifomula izokopishwa, okusho ukuthi ukufakwa kuyokwenzeka ngokungalungile. Ngakho-ke, sidinga kuphela ukwenza ikhophi yamagugu.
Khetha ibanga ngamanani aguqulwe. Sicindezela inkinobho "Kopisha"itholakala ku-ribbon kuthebhu "Ikhaya" eqenjini lamathuluzi "Ibhodi lokunamathisela". Ngokunye, ungathayipha isinqamuleli ngemuva kokukhethwa Ctrl + C.
- Khetha ibanga ledatha langempela. Chofoza ekukhethweni ngenkinobho yegundane efanele. Emenyu yomongo ku-block "Izinketho zokufaka" khetha into "Amanani". Kuboniswa njenge-pictogram esinezinombolo ngaphakathi.
- Njengoba ubona, ngemuva kwezinyathelo ezingenhla, izindinganiso ngezikhala ezengeziwe zithathwe esikhundleni sedatha efanayo ngaphandle kwabo. Okusho ukuthi, umsebenzi usuphelile. Manje ungasusa indawo yokuthutha eyasetshenziselwa ukuguqulwa. Khetha ububanzi bamaseli aqukethe ifomula I-CUTS. Sichofoza kuso ngenkinobho yegundane kwesokudla. Emenyu esebenziwe, khetha into "Sula okuqukethwe".
- Emva kwalokho, idatha eyengeziwe izosuswa kushidi. Uma kunezinye izigaba etafuleni equkethe izikhala ezengeziwe, kuzomele uqhubeke nazo usebenzisa i-algorithm efanayo njengoba kuchaziwe ngenhla.
Isifundo: I-Excel Function Wizard
Isifundo: Indlela yokwenza ngokuzenzekelayo ku-Excel
Njengoba ubona, kunezindlela eziningi zokususa ngokushesha izikhala ezengeziwe ku-Excel. Kodwa zonke lezi zikhetho zenziwa ngamathuluzi amabili nje - amawindi "Thola futhi ushintshe" kanye nomqhubi I-CUTS. Kwesinye icala, ungasebenzisa futhi ukufometha. Ayikho indlela yonke eyobe elula kakhulu ukuyisebenzisa kuzo zonke izimo. Ngesinye isikhathi, kuyoba ngempumelelo ukusebenzisa okukhethwa kukho, futhi okwesibili - enye, njll. Isibonelo, ukususa isikhala esiphakathi kwamagama cishe kungenzeka kwenziwe ithuluzi. "Thola futhi ushintshe", kodwa kuphela umsebenzi ongasusa ngokufanele izikhala ekuqaleni nasekupheleni kweseli I-CUTS. Ngakho-ke, umsebenzisi kufanele enze isinqumo mayelana nokusetshenziswa kwendlela ethile ngokuzimela, ecabangela isimo.
