Ukusuka kwisandla seli nqaku, siza kukunika isishwankathelo esifutshane malunga Iimpazamo zeFomula kwi-Excel ixhaphake kakhulu namhlanje ukuze wazi ukuba ungaziqonda njani kumzuzu wokuqala.
Yonke into ofuna ukuyifumana
Iimpazamo zeFomyula kwi-Excel: Eyona iQhelekileyo
Ngokuqinisekileyo ube nethuba lokusebenzisa inkqubo edumileyo yeMicrosoft Excel amaxesha amaninzi, uqaphela ukuba, ngaphandle kwamathandabuzo, yenye yezona nkqubo zisebenzayo kuyo yonke iminyaka. Nangona kunjalo, ukusebenzisa gwenxa kwayo nayiphi na imisebenzi yayo kunokutshintsha isiphumo ngokupheleleyo.
Inkqubo edumileyo isebenza ngeefomyula ezisebenza ngamaxabiso ahambelana nazo okanye amanani apheleleyo; Nangona kunjalo, kukho ezinye iintlobo zeefomula ezenza ukusetyenziswa kwazo kube nzima, kuba azisetyenziswa rhoqo.
Ezinye zeempazamo zeFomula kwi-Excel
Silungiselele uluhlu olumangalisayo apho ezinye zeempazamo zeFomula ezixhaphakileyo ziya kuvela, ukuze ukwazi ukubona ukuba ibiyintoni na ingxaki ebikukuchaphazela ngamaxesha ahlukeneyo. Nje ukuba ucace gca, siza kudlulela kolunye uluhlu apho izisombululo zezi ngxaki ziya kuboniswa.
Ukungasebenzisi uphawu lokulingana
Yikholwe okanye ungakholelwa, kukho abantu abalibeleyo ukusebenzisa uphawu olulinganayo oludumileyo xa uqala ifomula. Oku kwenzeka ikakhulu ngenxa yokuba ungxamile; Kungenxa yoko le nto xa ufuna ukwenza ifomula, inkqubo iyithatha njengomxholo oqhelekileyo okanye uyiguqule ibe ngumhla.
Shiya ngaphandle abazali
Njengakwimeko engaphambili, ukusebenza ngokubambisana nabazali abathile kunokuba yinto edidayo; oku akwenzeki rhoqo ngeendlela elula. Nangona kunjalo, kuqhelekile ukuba abantu, xa besenza iifomula ezingaphezulu, balibale omnye okanye bobabini abazali babazali ngaxa lithile kwifomula.
Andazi ukuba ulubonisa njani uLuhlu
Indlela echanekileyo yokubonisa uluhlu isebenzisa kuphela ikholoni eyaziwayo; umzekelo uya kuba ngu: C1: D1. Indlela engalunganga (enokuthi yenziwe ngabantu abaninzi ngaphandle kokuyiqonda) kukusebenzisa olunye uphawu okanye uphawu okanye ukusebenzisa isithuba, ngaloo ndlela, uluhlu luya kugqibela lubonisa njengeNull.
Iingxoxo ezibandakanyiweyo ezimbi
Le yenye yezona mpazamo zixhaphakileyo xa usenza ifomula, oku kubulelwe kubunzima obukhoyo kubo. Enkosi kwinqanaba lokuntsokotha, sitsho silushiye nolunye ulwazi olufunekayo kwifomula; nangona sinokuthi siqwalasele kwelinye icala: kubandakanya ulwazi oluninzi kunokuba uceliwe.
Kuya kufuneka sijonge amaxesha ambalwa ngaphambi kokwenza ifomula, indlela eyakhiwe ngayo ukuze singaphinde senze impazamo efanayo.
Amanani aFomathiweyo
Into elungileyo ekufuneka yenziwe kukubandakanya amanani kwiifomula zegama, ungabandakanyi ukufomatha; Oku kungenxa yokuba ukuba kufakelwe isimboli esingafanelekanga ukuba sibe khona, ifomula iyakuthatha olo phawu ngokwahlulahlula. Umzekelo oqhelekileyo uya kuba kukumakisha amawaka ngokuchitha.
Hlanganisa amanye amaphepha ngendlela engalunganga
Xa sifuna ukubonisa umqolo, iseli okanye ikholamu ngefomyula, sizifumana sijoyina ispredishithi esithile. Oku kufuneka kwenziwe kusetyenziswa iikowuti.
Ukuba olunye uhlobo lwesimboli lusetyenziswa njengomahluli, ifomula iya kuthatha idatha njengempazamo kwaye ayiyi kuvumela owona msebenzi uphambili ukuba wenze ngokuchanekileyo.
Kwelinye icala, ukuba ufuna ukubonisa isihloko esithile kwiphepha, kufuneka usebenzise inqaku lokumemeza. Umzekelo unokuthi: 'Iphepha 3'! A1, ukubonisa isihloko esikwiseli A1 kwiphepha lokusebenzela 3.
Iimpazamo zeFomyula kwi-Excel: Isisombululo sokuqala
Mhlawumbi ubungayazi, kodwa i-Excel inento emangalisayo eyaziwa ngokuba yi-Error Checking, eyenziwe ngenjongo enye: ukuqinisekisa ukuba zonke iifomula ezisetyenziswe kwiphepha zilungile.
Ukuya "kwiFayile", emva koko uye ku "Khetha i-Excel" emva koko uye ku "Iifomula", ukhetho luya kuvela phantsi kwegama elithi "Vumela ukuKhangela okuPhambi kweMvelaphi". Olu khetho luya kuba luxanduva lokubonisa zonke Iimpazamo zeFomula kwi-Excel ngonxantathu obekwe kwindawo ephezulu yasekhohlo ebhokisini enempazamo.
Ukongeza kuloo nto, kunokwenzeka ukuba ulwenziwo lweefomula lusebenze ngokwenza okanye ukucima imigaqo ethile efana nale: "Iifomula ezingadibaniyo nezinye iifomula zommandla", "iiseli eziqulathe iifomula ezikhokelela kwimpazamo", "iifomula ekubhekiswa kuzo Iiseli ezingenanto "," Iifomula ezishiya iiseli kwingingqi "okanye" Idatha ekwitheyibhile ayisebenzi "ukongeza ekubeni kukho ezinye iindlela ezininzi.
Kwelinye icala, kunokwenzeka ukufumana iziphene ngesandla. Ngokucofa kwi «Formulas» kwaye emva koko «Formula Auditing», ukuze ube nakho ukucofa kwi «Impazamo Ukujonga». Iwindow iya kubonakala ibonisa impazamo efumaneka kwiphepha.
Iimpazamo zeFomyula kwi-Excel: Isisombululo sesibini
Kwelinye icala, ukuba sifuna ukuhlalutya iimpazamo zefomula, kufuneka ucofe ku "Qalisa" emva koko «Hlela», emva koko «Khangela kwaye ukhethe», emva koko «Yiya kuKhethekileyo» kwaye ekugqibeleni kwi «Iifomula» kwaye siya kubonisa kuVavanyo «iiseli ezineefomula».
Emva koko, cofa kwibhokisi yeefomula emva koko ku- "Formula Audit", ukhethe u "Uhlolo" kwaye ungeze. Uluhlu lweefomula luya kuvela ukuze uhlalutye nganye nganye kwaye ke ufumane impazamo.
Ukuba ulifumene eli nqaku liluncedo, sikunika enye enomdla malunga neyona ibalaseleyo Ezinye iindlela kuGoogle Drayivu kwiifayile zakho.