Indlela yoku-1: Sebenzisa isixhobo esizenzekelayo
I-Excel inesixhobo esizenzekelayo esenzelwe ukwahlula okubhaliweyo kwiikholamu. Ayisebenzi ngokuzenzekelayo, ke zonke iintshukumo ziya kufuneka zenziwe ngesandla, ukukhetha uluhlu lwedatha egqityiweyo. Nangona kunjalo, ukuseta yeyona ilula kwaye ikhawulezayo ekuphunyezweni.
- Ngeqhosha lasekhohlo le mouse, khetha zonke iiseli ezinombhalo ofuna ukwahlulahlula iikholamu.
- Emva koko, yiya kwi-TAB "Idatha" kwaye ucofe i "TOPE kwiKholamu" iqhosha ".
- "I-Wizard ye-Wholam" iwindows "iyavela, apho ufuna ukukhetha ifomathi yedatha" kunye ne-sarators ". Ukwahlula uninzi lwenza indawo, kodwa ukuba le yenye isiphawuli, kuya kufuneka siyicacisele kwinyathelo elilandelayo.
- Phawula ukhawulezisa isimboli okanye ukungena ngesandla, emva koko ufunde ukwahlukana okokuqala nesiphumo sefestile engezantsi.
- Kwinyathelo lokugqibela, unokuchaza ifomathi entsha yekholamu kunye nendawo ekufuneka ibekwe kuyo. Nje ukuba iseti igqityiwe, cofa u "Gqibezela" ukufaka lonke utshintsho.
- Buyela etafileni kwaye uqiniseke ukuba ukwahlulwa kudlule ngempumelelo.
Kule myalelo, sinokugqiba kwelokuba ukusetyenziswa kwesixhobo esinjalo kuso kula meko ukwenziwa komzimba kufuneka kwenziwe kube kanye, chaza igama ngalinye ikholamu entsha. Nangona kunjalo, ukuba idatha entsha ihlala ivela etafileni, lonke ixesha lokwahlulahlula-hlula-hlula ngale ndlela ingabi lula, ukuze njalo kwiimeko ezinjalo sicebisa ngale ndlela ilandelayo.
Indlela 2: Ukwenza ifomula ye-spliking
Kwi-Excel, ungayida ngokuzimela ifomula entsonkothileyo eya kukuvumela ukuba ubale izikhundla zamagama kwiseli, fumana izithuba kwaye wahlule nganye ibe nye kwiikholamu ezahlukeneyo. Umzekelo, siza kuthatha iseli equka amagama amathathu ahlukaniswe zizithuba. Kuwo ngamnye wabo, uya kuthatha eyabo ifomula, ngenxa yoko sahlulahlula indlela yamanqanaba amathathu.Inyathelo 1: Ukwahlula iLizwi lokuqala
Ifomula yegama lokuqala lelona lilula, kuba kuya kufuneka iphinde ifundwe kuphela ukusuka kumqolo omnye ukumisela isikhundla esichanekileyo. Cinga ngenqanaba ngalinye lendalo, ukuze umfanekiso opheleleyo wenziwe kutheni kufuneka ukubale ukubala okuthile kuyafuneka.
- Ukuze ube lula, yenza iikholamu ezintathu ezintsha ezinamasikishi apho siya kongeza khona isicatshulwa. Unokwenza okufanayo okanye utsibe lo mzuzu.
- Khetha iseli apho ufuna ukubeka khona igama lokuqala, ubhale phantsi ifomula = i-intertimv (.
- Emva koko, cinezela iqhosha "lokukhetha", ngaloo ndlela uye kwifestile yokuhlela yefomula.
- Njengombhalo wengxoxo, chaza iseli ngombhalo ngokunqakraza kuyo ngeqhosha lasekhohlo kwitafile.
- Inani lemiqondiso kwisithuba okanye enye eyahlula-nye kuya kufuneka ibala, kodwa asizukuyenza le nto, kodwa siya kusebenzisa enye ifomula-ndlongondlolo ().
- Nje ukuba uyibhale kwifomathi enjalo, iya kuvela kwisicatshulwa seseli ngaphezulu kwaye iya kugxininiswa ngesibindi. Cofa kuyo ukuze ungene ngokukhawuleza kwimpikiswano yalo msebenzi.
- Kwintsimi "ye-skeleton" ibeka nje indawo okanye umahluko osetyenzisiweyo kuba kuya kukunceda uqonde ukuba igama liphela. Kwi "Guqula_ -Khangelo" chaza ukuba senziwe iseli efanayo.
- Cofa kumsebenzi wokuqala ukubuyela kuyo, kwaye wongeze ekupheleni kwengxoxo yesibini -1. Oku kuyimfuneko ukwenzela ukuba ifomula yokukhangela ithathela ingqalelo ayisiyo indawo oyifunayo, kodwa iphawuleka kuyo. Njengoko kunokubonwa kwi-skrini elandelayo, isiphumo siyaboniswa ngaphandle kwezithuba, okuthetha ukuba ingqokelela yenziwa ngokuchanekileyo.
- Vala uMhleli Womsebenzi kwaye uqiniseke ukuba iLizwi libonisiwe ngokuchanekileyo kwiseli entsha.
- Bamba iseli kwikona esezantsi ngasekunene kwaye urhole kwinani elifunekayo lemiqolo ukolule. Ke amaxabiso anye amabinzana athathelwa indawo, ekufuneka yahlulelene, kwaye ukuzaliseka kwefomula ngokuzenzekelayo.
Ifomula edaliweyo edaliweyo inefom = iLevimv (a1; ukukhangela (""; i-A1), faka oku ukuba iimeko zilungile. Ungalibali ukutshintsha iseli eqhotyoshelweyo.
Inyathelo 2: Ukwahlulahlula igama lesibini
Eyona nto inzima kukwahlula ilizwi lesibini, elikwigama lethu. Oku kungenxa yokuba kujikelezwe zizithuba kumacala omabini, ke kuya kufuneka uthathele ingqalelo zombini, ukudala ifomula enkulu yokubala isikhundla esichanekileyo.
- Kule meko, eyona formula iphambili iya kuba = pst (- yibhale ngale fomu, emva koko uye kwi-windows windows windows.
- Le fomula iya kukhangela umtya oyifunayo kwisicatshulwa, ekhethwe sisisele kunye nombhalo wokwahlukana.
- Isikhundla sokuqala somgca kuya kufuneka simiselwe kusetyenziswa ifomula esele incedile ().
- Ukudala nokuqhubela phambili, gcwalisa ngendlela efanayo njengoko kubonisiwe kwinyathelo elidlulileyo. Njengesicatshulwa esifunayo, sebenzisa umahluko, kwaye uchaze iseli njengesibhalo ukukhangela.
- Buyela kwifomula yangaphambili, apho kongeza kwi "Khangela" +1 ekupheleni ukuqala kweakhawunti elandelayo emva kwendawo efunyenweyo.
- Ngoku ifomula isenokuqala ukukhangela umgca osuka kwigama lokuqala lomlinganiswa, kodwa isazi ukuba iyigqibezela, ke, endle "ifonati" kwakhona, bhala ifomula yokukhangela ().
- Yiya kwiimpikiswano zayo kwaye uzigcwalise kwifom eqhelekileyo.
- Ngaphambili, asikhange siqwalasele isikhundla sokuqala salo msebenzi, kodwa ngoku siyimfuneko ukungenisa uphando (), kuba le fomula ingafumani msantsa wokuqala, kodwa okwesibini.
- Yiya kwi-DEAD SHION kwaye uyigcwalise ngendlela efanayo.
- Buyela kwi "Khangela" kwaye wongeze kwi "NOCH_POTION" +1 ekupheleni, kuba ayidingi sithuba sokukhangela umgca, kodwa uphawu olulandelayo.
- Cofa kwingcambu = PST kwaye ubeke isikhombisi ekupheleni komgca "Inombolo_Names".
- Khupha ukubonakaliswa kwentetho (""; A1) -1 ukugqiba izithuba zendawo.
- Buyela etafileni, wolula ifomula kwaye uqiniseke ukuba amagama aboniswa ngokuchanekileyo.
Ifomula yajika inkulu, kwaye ayingabo bonke abasebenzisi bayaziqonda kakuhle ukuba isebenza njani. Inyani yile yokuba ukukhangela umgca kufuneka ndisebenzise imisebenzi emininzi echaza indawo yokuqala kunye nendawo yokugqibela yezithuba, kwaye emva koko wawuphawula omnye kubo ukuze ngenxa yoko, ezi zithuba zibonakaliswayo. Ngenxa yoko, le fomula yile: = i-PSTR (A1; Khangela (""; I-A1) - 1). Yisebenzise njengomzekelo, ukutshintsha inombolo yeseli ngesicatshulwa.
Inyathelo 3: Ukwahlulahlula igama lesithathu
Inyathelo lokugqibela lomyalelo wethu lithetha ukwahlulwa kwegama lesithathu, elikhangeleka ngendlela efanayo njengoko yenzekile nowokuqala, kodwa ifomula ngokubanzi itshintsha kancinci.
- Kwiseli engenanto, kuba indawo yesicatshulwa sexesha elizayo, bhala = i-rassimimv (kwaye uye kwimpikiswano yalo msebenzi.
- Njengombhalo, chaza iseli ngombhalo wokwahlukana.
- Umsebenzi oncedisayo wokufumana igama ubizwa ngokuba yi-DLSTR (A1), apho i-A1 ikwiseli efanayo nesicatshulwa. Eli nqaku limisela inani labalinganiswa kwisicatshulwa, kwaye siya kuhlala sabela ifanelekile kuphela.
- Ukwenza oku, ukongeza-) kwaye uye kuhlela le fomula.
- Ngenisa isakhiwo esikhoyo sokukhangela umahluli wokuqala kumtya.
- Yongeza olunye ukukhangela kwindawo yokuqala ().
- Chaza isakhiwo esifanayo.
- Buyela kwifomula yokukhangela kwangaphambili.
- Yongeza +1 kwisikhundla sayo sokuqala.
- Zulazula kwingcambu yeFomula Rassv kwaye uqiniseke ukuba isiphumo sibonakalisiwe ngokuchanekileyo, kwaye uqinisekise utshintsho. Ifomula epheleleyo kule meko ijongeka ngathi = Pracemir (i-A1; i-DLSTR (A1) -Uplikt (""; I-A1) +1).
- Ngenxa yoko, kwi-screen elilandelayo uyabona ukuba onke amagama amathathu ahlukaniswe ngokuchanekileyo kwaye akwiikholamu zazo. Kule nto, kwakuyimfuneko ukusebenzisa iintlobo ezahlukeneyo zefomula kunye nemisebenzi encedisayo, kodwa ikuvumela ukuba usebenze ngokuthembekileyo itafile kwaye ungakhathazeki ukuba ngalo lonke ixesha kufuneka wabelane ngesicatshulwa kwakhona. Ukuba kukho imfuneko, yandisa nje ifomula ngokusisusa ukuze le leseli ilandelayo ichaphazeleke ngokuzenzekelayo.