Amaphutha avame kakhulu ngamafomula ku-Excel nendlela yokuwalungisa

Uma uke wabhekana naleyo miyalezo eyimfihlo ehlanganiswe izibabazo, ama-hash marks, namagama anosonhlamvukazi ngenkathi usebenzisa i-Excel, awuwedwa. Amaphutha efomula ku-Excel ajwayelekile kubo bobabili abaqalayo nabasebenzisi abanolwazi. Funda ukuzibona futhi uzilungise Kuyisinyathelo esibalulekile ukusebenzisa leli thuluzi elinamandla futhi ugweme ubuhlungu bekhanda obungenasidingo.

Kulesi sihloko ngikuchazela ngokucacile Imaphi amaphutha avame kakhulu ngamafomula ku-Excel?, indlela yokuzibona, ukuthi zibangelwa yini, futhi okubaluleke kakhulu, ukuthi zingalungiswa kanjani. Futhi, ngizokubonisa amathiphu okuwavimba, futhi sizohlola ezinye izindlela zesimanje ku-Excel uma kwenzeka ufuna ukuzizwisa okuhlukile noma okuhlanganyelwe efwini. Qhubeka ufunde futhi ube uchwepheshe we-spreadsheet wangempela! Ake siqale! Amaphutha avame kakhulu ngamafomula ku-Excel nendlela yokuwalungisa.

Kungani i-Excel ikhombisa amaphutha kumafomula?

I-Excel ngokungangabazeki iyindinganiso yomhlaba wonke uma kuziwa kumaspredishithi. Isetshenziselwa kokubili ukuphathwa kwempahla enkampanini nokubalwa kwezimali kwasekhaya kanye nokuhlaziywa kwezimali okuthuthukisiwe ezinkampanini ezinkulu. Nokho, ukuguquguquka kwayo okukhulu namandla okubala Bangadlala ngathi uma senza amaphutha. uma ufaka amafomula.

Amaphutha amaningi avela ngoba Okuthile kufomula akufani nalokho okulindelwe yi-Excel.: izinkomba ezingavumelekile, izimpikiswano ezingalungile, imisebenzi engenakwenzeka (njengokuhlukanisa ngoziro), ukusetshenziswa kabi kwemisebenzi, amaphutha okuthayipha, noma izinkinga zokufometha. Ukuqonda umsuka wephutha ngalinye kuzokusiza ukuthi ulilungise ngokushesha. futhi uvimbele idatha yakho nezibalo ukuthi zingafakwa engozini.

Amaphutha avame kakhulu kumafomula e-Excel

Ake sehlele ebhizinisini: Lawa amaphutha avame kakhulu avela lapho usebenza namafomula ku-Excel, anemininingwane yokuthi enzeka nini nokuthi kungani, nokuthi ungawaxazulula kanjani kalula.

• #¡DIV/0!: Leli phutha livela uma uzama ukuhlukanisa ngoziro. Akunandaba ukuthi uthayipha uziro ngokwakho noma uma iseli elisetshenziswa njengedinominetha lingenalutho noma liqukethe inani elingu-0. Ngaphambi kokuhlukanisa, hlola ukuthi idinomineyitha ayisiye uziro.. Xazulula inkinga usebenzisa izimo ezifana =IF(B3=0, «», A3/B3) para evitarlo.
• #¡VALOR!: Ibonisa ukuthi ifomula iqukethe inani elingahambisani noma i-agumenti. Lokhu kuvame ukwenzeka uma ufaka umbhalo lapho kulindelwe inombolo, ushiye amaseli engenalutho, noma usebenzise izinhlamvu ezingalungile. Hlola ama-agumenti ngokucophelela futhi uqiniseke ukuthi amaseli aqukethe uhlobo lwedatha olulungile..
• #REF!: Lokhu kubonakala uma ifomula ibhekisela kuseli elingasekho, ngokuvamile ngenxa yokuthi lisusiwe. Uma lokhu kwenzeka kuwe, hlehlisa isenzo noma ulungise ireferensi mathupha kubha yefomula.
• #¿NOMBRE?: Leli phutha libonisa ukuthi i-Excel ayiboni ingxenye ethile yefomula, ngokuvamile ngenxa yephutha lokuthayipha (isibonelo, ukubhala I-AVERAGE esikhundleni se ISILINGANISO) noma ukusetshenziswa kwamagama ngendlela engafanele. Hlola ukuthi wonke amagama apelwe ngendlela efanele yini futhi uma ungabaza, sebenzisa iwizadi yokusebenza ukuze ugweme amaphutha.
• #NA: Kuboniswa uma umsebenzi wokusesha, njenge BUSCARV, COINCIDIR o BUSCARH, ayilitholi inani eliceliwe kububanzi obubonisiwe. Qiniseka ukuthi idatha ikhona nokuthi ifomula yakhiwe ngendlela efanele. Uma ufuna ukwenza umlayezo ube ngokwakho, ungasebenzisa =IF.ERROR(..., "Inani alitholakali").
• #####: Uma ubona amamaki e-hashi kuphela esitokisini, akukona ukubala kabi, kodwa inkinga yesikhala: ikholomu yincane kakhulu ukubonisa umphumela. Udinga nje ukwandisa ububanzi bekholomu ukuze uyibonise ngendlela efanele.
• #¡NULO!: Leli phutha livela lapho i-Excel ingakwazi ukunquma ububanzi obucacisayo, ngokuvamile ngenxa yokuthi inyunyana noma u-opharetha wobubanzi usetshenziswe ngokungalungile. Hlola ikholoni (:) ukuze uthole ububanzi kanye nesemicolon (;) ukuze uthole izinkomba zokuhlanganisa emsebenzini (=USUM(A2:A6;D2:D6)).
• #¡NUM!: Ibonisa ukuthi umphumela wefomula uyinani lenombolo elingaphandle kwemikhawulo i-Excel engakwazi ukuyiphatha, noma ukuthi uzama ukwenza umsebenzi wezibalo ongenakwenzeka, njengokubala impande yesikwele yenombolo eyinegethivu (=SQRT(-2)). Ihlola i-agumenti ngayinye bese ifaka amanani ezinombolo avumelekile kuphela.

Amaphutha esakhiwo ajwayelekile kumafomula okubhala

Ngaphezu kwamanani amaphutha, kukhona amaphutha avamile lapho ubhala amafomula ayinkimbinkimbi. Lokhu akukhiqizi imilayezo yamaphutha njalo, kodwa kungabangela imiphumela engalungile.Nazi ezivame kakhulu:

• Olvidar el signo igual (=): Yonke ifomula ku-Excel kufanele iqale ngayo =Uma ushiya lokhu, i-Excel izohumusha lokho okuthayiphayo njengombhalo noma idethi, futhi ngeke ibale lutho.
• Ukukhohlwa uvula noma ukuvala abakaki: Emisebenzini evalelwe noma amafomula amade, kulula ukushiya abakaki abangavaliwe, okubangela ukuthi kuhluleke. Bala abakaki njalo ukuze balinganisele.
• Ukusetshenziswa okungalungile kobubanzi noma izihlukanisi: Ububanzi buboniswa ngamachashazi amabili (:), como en =ISAMBA(A1:A10)Uma ufaka isikhala, uphawu lwenkulumo olungalungile, noma u-opharetha ongalungile, uzothola iphutha.
• Izimpikiswano ezinganele noma ezeqile: Imisebenzi eminingi idinga inani eliqondile lama-agumenti. Yeqa okukodwa noma wengeze okwengeziwe izobavimbela ekusebenzeni kahle.
• Izithenjwa zamaseli kwamanye amashidi azipelwanga kahle: Uma ifomula ibhekisela kwelinye ishidi, kuphoqelekile ukuthi ufake igama kumacaphuno owodwa uma linezikhala, futhi uphethe ngophawu lwesibabazo, isibonelo: ='Ukuthengisa Q2'!A1.
• Ukubhekisela ezincwadini zangaphandle akuphelele: Ukuze ubhekisele kwelinye ifayela, faka igama kubakaki, ulandelwe ishidi nobubanzi (=Ishidi!A1:A8). Uma ifayela livaliwe, udinga indlela egcwele.
• Izinombolo ezifomethiwe ngaphakathi kwamafomulaUngalokothi usebenzise izinombolo ezifomethiwe (izikhala, ongqi, izimpawu) kumafomula. Sebenzisa izinombolo "ezingenalutho" kuphela futhi usebenzise ukufometha kuseli.

Amathuluzi e-Excel nemisebenzi yokuthola amaphutha

I-Excel inikeza izindlela ezisiza indawo kanye nokulungiswa kwamaphutha ngokubukeka noma ngokuzenzakalelayo:

• Iphutha ekuhlolweni: Lo msebenzi uhlola ukungahambisani bese ubonisa unxantathu oluhlaza ekhoneni elingaphezulu kwesokunxele seseli. Ungakwazi ukwenza ngokwezifiso imithetho kusukela kokukhethwa kukho.
• Ukuhlolwa Kwefomula: Desde Amafomula > Audit, ikuvumela ukuthi uhlaziye futhi ulungise amafomula ayinkimbinkimbi, usize ukuhlonza amaphutha.
• Landela ama-precedents nabancikile: Le misebenzi ibonisa ngokucacile ukuthi yimaphi amaseli athinta noma athintwa ifomula, esiza ukuthola amaphutha ezithenjwa.
• Ayuda contextualI-Excel inikeza iziphakamiso zesikhathi sangempela nezexwayiso zamaphutha avamile kusetshenziswa i-Functional Wizard.

Amathiphu asebenzayo okugwema amaphutha ngamafomula ku-Excel

Ukunciphisa amaphutha, kuhle ukulandela le mikhuba:

• Planifica antes de escribir: Chaza ukuthi iyiphi idatha nemisebenzi oyidingayo ngaphambi kokuthi uqale.
• Buyekeza ukwakheka kwemisebenzi: Hlola usizo ukuze uqiniseke ukuthi usebenzisa izimpikiswano ngendlela efanele.
• Utiliza nombres descriptivos: Ukuqamba izigaba ezibalulekile namaseli kwenza kube lula ukugcina amafomula ayinkimbinkimbi.
• Aprovecha el autocompletado: Sebenzisa amacebo ukugwema amaphutha esipelingi emisebenzini namagama.
• Haz cambios gradualmente: Shintsha kuphela okudingekayo, uqinisekise imiphumela ngaphambi kokwenza ezinye izinguquko.
• Londoloza izinguqulo zokuphepha: Ngaphambi kokwenza izinguquko ezinkulu, gcina amakhophi ukuze uwabuyisele uma kukhona okungahambi kahle.

Ezinye izindlela ku-Excel ukuze kugwenywe amaphutha futhi kuthuthukiswe ukusebenzisana

Nakuba i-Excel ingumholi kumaspredishithi, izinguqulo zayo ezihlukene nokuhambisana kungabangela izinkinga ezindaweni zokusebenzisana noma lapho kushintshwa amafayela. Ezinye izindlela ezisiza ukubambisana futhi zigweme amaphutha athile yilezi:

• AmaSpredishithi e-GoogleOkusekelwe efwini, kuvumela ukuhlela kwesikhathi sangempela, umlando wenguqulo, nokuhambisana kwenkundla. Ezinye izici ziyehluka, kodwa zinikeza izinga eliphezulu lokuguquguquka.
• Zoho Sheets: Izici zokusebenzisana, ukungenisa/ukuthekelisa kalula ngamafomethi ahlukahlukene, kanye nokubika okuzenzakalelayo.
• Numbers (Apple): Kubasebenzisi be-Apple, ngesixhumi esibonakalayo esibonakalayo nezici ezibukwayo ukuze bakhe ihluzo nokwabelana ngamafayela kalula.
• Rows: Idizayinelwe amabhizinisi, ngokudidiyelwa okuthuthukile kanye nezishintshayo ezixhumeka kuzinhlelo zokusebenza zangaphandle nezinhlelo zokuphatha.
• Sebenzisa i-AI ku-Excel: Sikushiyela lo mhlahlandlela Amathuluzi angu-9 angcono kakhulu e-Excel ane-AI.

Kulabo abakhetha ukwenza ngokuzenzakalelayo ukuphathwa kwezimali, amapulatifomu afana neChipax axhuma ngesikhathi sangempela namabhange nezinhlelo zentela, ukunciphisa amaphutha abantu kanye nezinqubo ezilula.

Iphutha lomuntu: ingozi enkulu uma usebenza namafomula

Amaphutha amaningi e-Excel awaveli ku-software, kodwa avela emaphutheni omuntu. Kusukela ekukopisheni nasekunamathiseleni okungalungile kuye ekukhipheni izimpikiswano noma ekusebenziseni ama-opharetha angalungile, ukunganaki okuncane kungaholela emiphumeleni engalindelekile. Isihluthulelo siwukuthi prestar atención a los detalles futhi ubuyekeze amafomula ngaphambi kokuwaqinisekisa.

Ukuze ugweme ukuchitha isikhathi, izinqubo zokuzenzakalela noma ukusebenzisa izinsizakalo ezehlisa umkhawulo wephutha kungaba yinzuzo enkulu. Ukutshala imali ekuqeqesheni noma kumathuluzi ahlakaniphile kungenza umehluko futhi kukugcinele izinkinga eziningi ngokuhamba kwesikhathi.

Isihloko esihlobene:

Amafomula e-Excel athuthukile okuphatha amathebula njengochwepheshe

Bazi kahle amaphutha ajwayelekile ku I-Excel Ukwazi ukuthi ungazilungisa kanjani ngokushesha kuzokuvumela ukuthi usebenzise ngokugcwele leli thuluzi elinamandla futhi ugweme ukwesabisa okuthinta ukukhiqiza kwakho. Ngokuzijwayeza okuhle kanye nokusetshenziswa kwamathuluzi alungile, imilayezo yamaphutha izoyeka ukuba yizitha futhi ibe izexwayiso ezilula ozozilawula kalula. Ungavumeli iphutha lefomula likhawulele ukusebenza kahle kwakho! Sithemba ukuthi manje usuwazi amaphutha avame kakhulu ngamafomula e-Excel kanye nendlela yokuwalungisa.

UCristian Garcia

Uzifela ngobuchwepheshe kusukela esemncane. Ngiyakuthanda ukwaziswa kwamuva kulo mkhakha futhi, ngaphezu kwakho konke, ukuxhumana nawo. Yingakho ngizinikele ekuxhumaneni kumawebhusayithi emidlalo yevidiyo iminyaka eminingi. Ungangithola ngibhala nge-Android, iWindows, iMacOS, i-iOS, iNintendo nanoma yisiphi esinye isihloko esihlobene esifika emqondweni.