Ungalibeka kanjani inani eliphelele ku-Excel? Ngaphakathi kwalesi sihloko sizokufundisa, ngezinyathelo ezilula.
Kuyaziwa ukuthi i-Excel iyi-sisofthiwe, ekwazi ukuhlela, ukugcina nokuhlukanisa zonke izinhlobo zedatha nolwazi. Kuyinkimbinkimbi kakhulu ukusebenzisa, kodwa kuyasiza kakhulu uma sifuna ukugcina yonke inhlangano yebhizinisi, indawo, umlando, phakathi kwezinye eziningi.
I-Excel, njengethuluzi elihlakaniphile, iphinde isivumele ukuthi senze imisebenzi yezibalo eminingi, efanayo esivame ukuyidinga, ngaphakathi kwamaphrojekthi ethu, imisebenzi, noma amarekhodi ashiwo ngenhla.
Ngakho ekugcineni, I-Excel ingasisiza ukubala inani eliphelele, ngenxa yalokhu kufanele futhi ukwazi. Ukuthi ngokwengxenye yalo, inani eliphelele yibanga elikhona phakathi kwenombolo enikeziwe kanye noziro, lokhu kusho ukuthi umphumela otholiwe uzohlala uyinombolo ephozithivu, noma inani empeleni liyigegethivu.
Ngale ndlela, i-Excel futhi isivumela ukuthi sengeze uhla lonke noma uhlu lwezinombolo eziphozithivu nezingezinhle ngaphakathi kwamakhasi okusebenza.
Uma ufuna ukwazi, ukuthi ungakwenza kanjani konke lokho, hlala ngaphakathi kwalesi sifundo, lapho sizokufundisa khona ungabeka kanjani inani eliphelele ku-Excel.
Imisebenzi ye-Excel esivumela ukuthi sibeke inani eliphelele
Empeleni i-Excel, inemisebenzi ehlukene, esivumela ukubala futhi sengeze inani eliphelele lenombolo, ngaphakathi kwamakhasi okusebenza, le misebenzi yilena elandelayo:
Umsebenzi we-ABS
Lona omunye wemisebenzi yokuqala, okuyinto Kunconywa uma sifuna engeza inani eliphelele kuspredishithi se-excel. Ngaphakathi kwayo, inani eliphelele lenombolo liyasungulwa, ngaphakathi kweseli elilodwa. Lona umsebenzi oyisisekelo, ongakwazi ngempela ukwengeza amanani aphelele ngokuzenzakalelayo, kodwa usivumela ukuthi sikwenze mathupha.
Ukuze sikwenze, kufanele senze lokhu okulandelayo:
Vula ishidi le-Excel elingenalutho bese uqala ukufaka -3454 kuseli B3, bese ukhetha iseli elilandelayo, B4, ekubeni kulo cindezela umyalo “Fx” Lokhu kuzovula iwindi elisha, lapho kufanele ukhethe “faka umsebenzi”. Ngemuva kwalokho kuzovela imenyu yokudonsela phansi, lapho kufanele ukhethe khona isigaba “ABS”, iwindi elisha lizovuleka ngokushesha ngaphansi kwalo.
Ngemuva kwalokho kufanele uchofoze inkinobho ethi "reference cell" yenkambu ethi "inombolo” bese ukhetha iseli B3. Khona-ke kuzodingeka uchofoze ku-"OK", ngaleyo ndlela ulwazi luzongezwa. Umsebenzi we-ABS ngaphakathi kwesipredishithi. Kulokho uzoqaphela ukuthi iseli B4 manje selizothatha inani lika-3454.
Uma ufuna, ungathola inani eliphelele lohlu lwamaseli, ngalo msebenzi ofanayo, ngokwengeza ikholomu ye-ABS ngaphakathi kwesipredishithi. Bese ungafaka umsebenzi we-ABS kuleyo kholomu, ngokufaka isibalo =SUM, kuseli engezansi kwekholomu, ngaleyo ndlela ungakwazi ukwengeza amanani aphelele atholiwe.
Futhi yilokho. Kulula kakhulu, akunjalo? Ngaleyo ndlela uzoba nakho beka inani eliphelele ngaphakathi kweshidi le-excel.
Inhlanganisela ye-ABS nomsebenzi we-SUMPRODUCT ukuze ubeke inani eliphelele ku-Excel
Umsebenzi we-ABS, ngamafuphi, uwusizo kakhulu ekubaleni inani eliphelele futhi ungabuye uhlanganiswe neminye imisebenzi, kulokhu sikhuluma ngomsebenzi we-SUMPRODUCT, osivumela ukuthi sinikeze ububanzi obunegethivu noma obuphozithivu enanini eliphelele.
Ukuze ukwazi beka inani eliphelele ku-excel, usebenzisa le misebenzi emibili, kufanele wenze okulandelayo:
Kufanele uqale uvule ishidi le-Excel elisha. Bese uyigcwalise ngedatha esunguliwe. Ungafaka amanani 4, 4 no-7 kumaseli A2, A3 no-A4. Ngemuva kwalokho kufanele ukhethe iseli A5 bese uchofoza, ngaphakathi kwebha ebizwa ngokuthi "imiphumela". Khona-ke kufanele ufake i- umsebenzi =I-SUMPRODUCT(A2:A4), kubha efanayo "yemiphumela" ngemuva kokuthi kufanele ukhethe "OK"Noma"Intro”, lokhu kuzokwenza iseli A5, libe inombolo 7, okungelona ngempela inani eliphelele.
Khona-ke kufanele uthole inani langempela eliphelele, kulokhu sidinga ukujoyina umsebenzi we-ABS nezinyathelo zangaphambilini, ngakho-ke umsebenzi onezibalo zawo zangempela kufanele uguqulelwe kulokhu. =I-SUMPRODUCT(ABS(A2:A4)). Lokho kuzodala ukuthi i-A5 ibe ngu-15, okungukuthi, 4+4+7, ukuze uhla lwamaseli, lunikeze umphumela oqondile.
Ilungile! Nakuba le nketho ingase ibonakale iyinkimbinkimbi kakhulu kunangaphambili, uma uyisebenzisa, uzoqaphela ukuthi ilula kangakanani.
Umsebenzi we-SUMIF wokuthola inani eliphelele ku-Excel
Lo msebenzi uvumela abasebenzisi be-Excel ukuthi bengeze amanani ahlangabezana nochungechunge lwemibandela ethile. Ngayo singathola futhi inani eliphelele, kuhlu olunikeziwe lwamaseli, kufanele sengeze isibalo esilandelayo. I-SUMIF(ububanzi, imibandela,[sum_range]). Ngaleyo ndlela ungathola inani eliphelele, ngokuzenzakalelayo.
Ngakolunye uhlangothi, uma ufuna ukuthi ukusebenza kwenziwe ngendlela yezandla, faka umsebenzi ku- “imiphumela”. Ukukhetha iseli A6, bese ufaka idatha =SUMIF(A2:A4,»>0″)-SUMIF(A2:A4,».
Futhi lokho kungaba konke, kulula akunakwenzeka.
I-plugin ye-Kutools
Leli, ngakolunye uhlangothi, liyithuluzi langaphandle, kodwa lisebenza kahle kakhulu kanye ne-Excel, ngalo ungenza imisebenzi ehlukene futhi phakathi kwayo, leyo thola inani eliphelele, kusisiza futhi ukuthi siguqule izimpawu zamanani, sisuke ezinambeni ezinegethivu ziye eziphozithivu, ngaphakathi kweshidi lethu le-Excel.
Uma ufuna ukufinyelela kuyo yonke imisebenzi nezinzuzo zayo, okumele ukwenze nje ukuyifaka kukhompyutha yakho bese uqala ukusebenza nayo.
Isiphetho
Empeleni kunezindlela ezimbalwa zokuthola inani eliphelele lohlu lwezinombolo ngaphakathi kwespredishithi se-Excel. Kodwa ngayinye yalezi ezichazwe ngenhla, ikwazi ukufeza lowo msebenzi ofisayo, okungukuthi beka inani eliphelele ngaphakathi kwe-excel.
Ngakwenu, okusele wukusesha nokukhomba leyo elula kuwena, futhi, ngokusobala, leyo evumelana kangcono nezidingo onazo njengomsebenzisi we-Excel.
Kokunye, sithemba kuphela ukuthi usithandile lesi sihloko nokuthi usuyazi ungabeka kanjani inani eliphelele ku-Excel.