Izikhala ezingeziwe kumbhalo azifaki umbala. Ikakhulu akufanele bavunyelwe kumatafula anikezwe abaphathi noma umphakathi. Kodwa noma ngabe uzosebenzisa idatha kuphela ngezinjongo zomuntu siqu, izikhala ezingeziwe zingakhuphula ivolumu yedokhumenti, okuyisici esingesihle. Ngaphezu kwalokho, ukuba khona kwezinto ezinjalo ezingeziwe kwenza kube nzima ukusesha ifayela, ukufaka izihlungi, ukusebenzisa ukuhlunga namanye amathuluzi. Ake sibheke ukuthi yiziphi izindlela ezingatholakala ngokushesha futhi zisuswe.
Isifundo: Ukususa izikhala ezinkulu eMicrosoft Word
Ubuchwepheshe wokususa izikhala
Kufanele usho khona lapho ukuthi izikhala ezise-Excel zingaba zezinhlobo ezahlukahlukene. Kungaba izikhala phakathi kwamagama, isikhala ekuqaleni kwenani ekugcineni, abahlukanisi phakathi kwamadijithi ezinkulumo ezinezinombolo, njll. Ngokufanelekile, i-algorithm yokuqedwa kwabo kulezi zimo ihlukile.
Indlela yoku-1: Sebenzisa ithuluzi Lokubuyisela esikhundleni
Ithuluzi lenza umsebenzi omuhle kakhulu wokushintsha izikhala eziphindwe kabili phakathi kwamagama anezikhala ezizodwa e-Excel Faka esikhundleni.
- Ukuba kuthebhu "Ikhaya"chofoza inkinobho Thola nokugqamisaelibekwe endaweni yethuluzi "Ukuhlela" ekhasethini. Kuluhlu olwehliswayo, khetha Faka esikhundleni. Ungakwazi futhi esikhundleni sezenzo ezingenhla vele uthayiphe isinqamuleli sekhibhodi kwikhibhodi I-Ctrl + H.
- Kunoma yikuphi ukukhetha, iwindi lokuthola nokuLayisha esikhundleni kuvula kuthebhu Faka esikhundleni. Ensimini Thola setha isikhombisi bese uchofoza kabili enkingeni Ibha yesikhala kwikhibhodi. Ensimini "Faka esikhundleni no" faka isikhala esisodwa. Bese uchofoza inkinobho Esikhundleni Sonke.
- Uhlelo lubuyisela isikhala esikabili ngesikhala esisodwa. Ngemuva kwalokho, kuvela iwindi elinombiko womsebenzi owenziweyo. Chofoza inkinobho "Kulungile".
- Okulandelayo, kuvela iwindi futhi Thola bese Ufaka esikhundleni. Senza ngqo lezo zenzo kule windi njengoba kuchaziwe esigabeni sesibili salo myalezo kuze kufike umyalezo lapho usho ukuthi imininingwane oyifunayo ayitholakalanga.
Ngakho-ke, sisuse izikhala ezengeziwe eziphindwe kabili phakathi kwamagama asencwadini.
Isifundo: Ukufakwa Kwenhlamvu ku-Excel
Indlela 2: khipha izikhala phakathi kwamadijithi
Kwezinye izimo, izikhala zibekwa phakathi kwamadijithi ngezinombolo. Lokhu akulona iphutha, ukubona nje okubonakalayo kwezinombolo ezinkulu lolu hlobo lokubhala lungelula. Kepha, noma kunjalo, lokhu kude neze kwamukeleka. Isibonelo, uma iseli lingafakwanga ngefomethi yezinombolo, ukwengeza ohlukanisayo kungathinta kabi ukunemba kokubala ezinhlotsheni. Ngakho-ke, impikiswano yokususa abahlukanisi enjalo iba efanele. Lo msebenzi ungenziwa usebenzisa ithuluzi elifanayo. Thola bese Ufaka esikhundleni.
- Khetha ikholamu noma ibanga ofuna ukususa kulo ukwahlukanisa phakathi kwezinombolo. Leli phuzu libaluleke kakhulu, ngoba uma ibanga lingakhethwanga, ithuluzi lizosusa zonke izikhala kudokhumenti, kufaka phakathi kwamagama, okungukuthi, lapho kudingeka khona impela. Okulandelayo, njengangaphambili, chofoza inkinobho Thola nokugqamisa ebhokisini lamathuluzi "Ukuhlela" kubambo kuthebhu "Ikhaya". Kumenyu eyengeziwe, khetha Faka esikhundleni.
- Iwindows liqala futhi Thola bese Ufaka esikhundleni kuthebhu Faka esikhundleni. Kepha kulokhu sizokwethula amanani ahlukile emasimini. Ensimini Thola setha indawo eyodwa, nensimu "Faka esikhundleni no" shiya kungenalutho nhlobo. Ukuze uqiniseke ukuthi azikho izikhala kulo mkhakha, beka ikhesa kuyo bese ubamba inkinobho yokubuyisela emuva (ngendlela yomcibisholo) kwikhibhodi. Bamba inkinobho kuze kube ikhesa liphumule emngceleni wesokunxele wensimu. Ngemuva kwalokho chofoza inkinobho Esikhundleni Sonke.
- Uhlelo luzokwenza umsebenzi wokususa izikhala phakathi kwezinombolo. Njengasekuqaleni kwendlela, ukuze uqiniseke ukuthi umsebenzi uqediwe ngokuphelele, cinga okwesibili kuze kufike umlayezo lapho ivelu oyifunayo ingatholakalanga.
Ukwahlukaniswa phakathi kwamadijithi kuzosuswa, futhi amafomula azoqala ukubalwa kahle.
Indlela 3: khipha abahlukanisi phakathi kwemithi ngokufomatha
Kepha kunezimo lapho ubona ngokucacile ukuthi ephepheni amadijithi ahlukaniswa ngamanani izikhala, futhi ukusesha akuniki imiphumela. Lokhu kuphakamisa ukuthi kulokhu, ukwahlukana kwenziwa ngokufometha. Inketho yesikhala esinjalo ngeke iphazamise ukunemba kokuboniswa kwamafomula, kepha ngasikhathi sinye, abanye abasebenzisi bakholelwa ukuthi ngaphandle kwayo itafula lizobukeka lingcono. Ake sibheke ukuthi ingayisusa kanjani le ndlela yokuhlukanisa.
Njengoba izikhala zenziwa kusetshenziswa amathuluzi wokufometha, kungamathuluzi afanayo kuphela angasuswa.
- Khetha uhla lwezinombolo nge-delimiters. Chofoza ekukhetheni ngenkinobho yegundane elifanele. Kumenyu evelayo, khetha "Ifomethi yeseli ...".
- Ukuqalisa ukufometha kuqala. Iya kuthebhu "Inombolo"uma ukutholwa kwenzeke kwenye indawo. Uma ukwahlukaniswa kuchaziwe kusetshenziswa ukufomatha, khona-ke kububanzi bepharamitha "Amafomethi ezinombolo" inketho kumele ifakwe "Inombolo". Uhlangothi olungakwesokudla lwewindows luqukethe izilungiselelo eziqondile zale fomethi. Mayelana nephuzu "Umhlukanisi weqembu () udinga nje ukungahloli. Ngemuva kwalokho, ukuze izinguquko ziqale ukusebenza, chofoza inkinobho "Kulungile".
- Iwindi lokufomatha liyavalwa, futhi ukwahlukana phakathi kwamadijithi ezinombolo ezikhethiwe kususiwe.
Isifundo: Ifometha amatafula ku-Excel
Indlela 4: khipha izikhala usebenzisa umsebenzi
Insimbi Thola bese Ufaka esikhundleni Kuhle ngokususa izikhala ezingeziwe phakathi kwezinhlamvu. Kepha kuthiwani uma zidinga ukususwa ekuqaleni noma ekugcineni kwesisho? Kulokhu, umsebenzi ovela eqenjini lombhalo wabasebenza uzokusiza GAPS.
Lo msebenzi ususa zonke izikhala embhalweni wobubanzi obukhethiwe, ngaphandle kwesikhala esisodwa phakathi kwamagama. Lokho wukuthi, iyakwazi ukuxazulula inkinga ngezikhala ekuqaleni kwegama esitokisini, ekugcineni kwegama, futhi kususe izikhala eziphindwe kabili.
I-syntax yalokhu ku-opharetha ilula kakhulu futhi inempikiswano eyodwa kuphela:
= IQINISO (umbhalo)
Njengokuphikisana "Umbhalo" isisho esingumbhalo singabonakala ngqo, kanye nesixhumanisi seseli okuso. Okwethu, kuzokhethwa inketho yokugcina.
- Khetha iseli elibekwe ngokufana nekholamu noma umugqa lapho izikhala kufanele zisuswe. Chofoza inkinobho "Faka umsebenzi"etholakala kwesobunxele sebha yefomula.
- Iwindows Workiz Wizard iyaqala. Esigabeni "Uhlu oluphelele lwe-alfabhethi" noma "Umbhalo" ngifuna into ISZPROBELY. Khetha bese uchofoza inkinobho. "Kulungile".
- Iwindi lokuphikisana komsebenzi liyavula. Ngeshwa, lo msebenzi awunikezeli ngokusetshenziswa kwalo lonke uhla esiludingayo njengengxabano. Ngakho-ke, sibeka isikhombisi enkombeni yokuphikisana, bese sikhetha iseli lokuqala lobubanzi esisebenza nabo. Ngemuva kokuthi ikheli leselula liboniswe endle, chofoza inkinobho "Kulungile".
- Njengoba ukwazi ukubona, okuqukethwe kuseli kuyakhonjiswa endaweni lapho kutholakala khona umsebenzi, kepha ngaphandle kwezikhala ezingeziwe. Senze ukususwa kwezikhala zento eyodwa kuphela yebanga. Ukuwasusa kwamanye amaseli, udinga ukwenza isenzo esifanayo namanye amaseli. Vele, ungakwazi ukwenza umsebenzi ohlukile neseli ngalinye, kepha lokhu kungathatha isikhathi esiningi, ikakhulukazi uma ububanzi bukhulu. Kukhona indlela yokushesha kakhulu inqubo. Faka ikhesa ekhoneni elingezansi kweseli esele liqukethe ifomula. Isikhombisi siguquka sibe yisiphambano esincane. Ibizwa ngokuthi umaki wokugcwalisa. Bamba inkinobho yegundane kwesobunxele bese uhudula umaki wokugcwalisa uhla lapho ufuna ukususa izikhala.
- Njengoba ubona, ngemuva kwalezi zenzo kwakhiwa ibanga elisha eligcwele, lapho kutholakala khona konke okuqukethwe kwendawo yasekuqaleni, kepha ngaphandle kwezikhala ezingeziwe. Manje sibhekene nomsebenzi wokubuyisela esikhundleni amanani asebangeni loqobo nedatha eguquliwe. Uma senza ikhophi elula, ifomula izokopishwa, okusho ukuthi ukunamathisela ngeke kusebenze kahle. Ngakho-ke, sidinga kuphela ukukopisha amanani.
Khetha ibanga ngamanani aguquliwe. Chofoza inkinobho Kopishaetholakala kubambo kuthebhu "Ikhaya" eqenjini lamathuluzi Ibhodi yokunamathisela. Ngenye indlela, ngemuva kokugqamisa, ungathayipha ukuhlanganiswa kwezinkinobho I-Ctrl + C.
- Khetha ibanga ledatha yoqobo. Chofoza ekukhetheni ngenkinobho yegundane elifanele. Kumenyu yokuqukethwe ebhlokini Faka Izinketho khetha into "Amanani". Kuboniswa njenge-pictograph eyisikwele enezinombolo ngaphakathi.
- Njengoba ukwazi ukubona, ngemuva kwezinyathelo ezingenhla, amanani anezikhala ezingeziwe athathelwa indawo ngedatha efanayo ngaphandle kwawo. Lokho wukuthi, umsebenzi usuphelile. Manje usungasusa isifunda sokuhamba esasisetshenziselwa ushintsho. Khetha ibanga lamaseli aqukethe ifomula GAPS. Sichofoza kukho inkinobho yegundane elifanele. Kumenyu evuliwe, khetha Sula okuqukethwe.
- Ngemuva kwalokho, imininingwane eminingi izokhishwa eshidini. Uma kunamanye amabanga ethebula aqukethe ezinye izikhala, kuzodingeka ubhekane nazo usebenzisa i-algorithm efanayo njengoba kuchaziwe ngenhla.
Isifundo: Umsebenzi Wizard e-Excel
Isifundo: Ungayenza kanjani ngokuzenzakalela i-Excel
Njengoba ukwazi ukubona, kunezindlela eziningi zokususa ngokushesha izikhala ezingeziwe ku-Excel. Kepha zonke lezi zinketho zenziwa ngamathuluzi amabili kuphela - amawindi Thola bese Ufaka esikhundleni no-opharetha GAPS. Esimweni esithile, ukufometha nakho kungasetshenziswa. Ayikho indlela yendawo yonke engaba lula kakhulu ukuyisebenzisa kuzo zonke izimo. Esimweni sinye, kuzoba okulungile ukusebenzisa inketho eyodwa, futhi kwesibili - enye, njll. Isibonelo, ukususa isikhala esikabili phakathi kwamagama kungenzeka kube yithuluzi Thola bese Ufaka esikhundleni, kepha umsebenzi kuphela ongasusa izikhala ngokufanelekile ekuqaleni nasekupheleni kweseli GAPS. Ngakho-ke, umsebenzisi kufanele anqume ngokusetshenziswa kwendlela ethile ngokwesisekelo sesimo.
