I-Learning Excel ingenye yalezo zidingo eziyisisekelo okufanele sihlangabezane nazo ukuze singagcini nje ngokusiza ukungena kwethu ezweni lomsebenzi, kodwa nezinqubo eziningi zokuphila kwethu kwansuku zonke. Ispredishithi seMicrosoft iyithuluzi elinamandla ngempela elibandakanyeka ezindaweni eziningi, kusukela emsebenzini kuye kwezifundiswa ngisho nakumaphrojekthi omuntu siqu. Ngalowo mqondo, uma ucabanga ukuqala indlela yakho ngalolu hlelo, sifuna ukukusiza ukuthi uthathe izinyathelo zokuqala. Ngakho-ke, sizobuyekeza amafomula ayisisekelo okufanele uwazi ukuze ufunde ukusebenzisa i-Excel.
Lawa mafomula azokusiza ukuthi uhambe kahle ngokusebenzisa ithuluzi, wenze imisebenzi yezibalo, izakhi zoku-oda, ukubala neminye imisebenzi ezokunikeza ithuba lokwenza imisebenzi ehlukahlukene.
Ithini ifomula ku-Excel?
Uma kukhulunywa nge-Excel, noma ungenalo ulwazi endaweni, ngokuqinisekile uzwile ngamafomula. Iningi lemisebenzi kulolu hlelo iqhutshwa ifomula, engeyona into engaphezu kwekhodi ekhethekile noma isibalo esisifakayo ukuze senze isenzo. Izenzo okukhulunywa ngazo zingasukela kwisamba esilula, ukuhleleka kwezinto eshidini noma ukubalwa kwezinto eziguquguqukayo njengezindawo, izindawo nokunye.
I-Excel inekhathalogi ebanzi yamafomula ezezimali, okunengqondo, ezibalo kanye ne-trigonometric, kanye namafomula okusesha kanye nereferensi. Ngokunjalo, uzothola izinketho eziqondiswe kwizibalo, ubunjiniyela kanye nokuphathwa kolwazi.
Ngale ndlela, uma uphakathi komsebenzi obandakanya noma iyiphi yalezi zindawo, kuzokwanela ukuba nedatha edingekayo bese ufaka ifomula okukhulunywa ngayo, ukuze uthole umphumela oqondile. Ngalowo mqondo, sizobuyekeza ngokushesha ukuthi yimaphi amafomula ayisisekelo okufanele siwaphathe ukuze sifunde i-Excel.
Amafomula okudingeka ukwazi ukuze uqale ukufunda i-Excel
Imisebenzi yezibalo eyisisekelo
Okokuqala, sizokukhombisa ukuthi ungayenza kanjani imisebenzi yezibalo eyisisekelo yokuhlanganisa, ukususa, ukuphindaphinda nokuhlukanisa. Empeleni, okuwukuphela kwayo enefomethi yefomula yangempela iyifomula Yesamba, kanti okunye kusekelwe ekusetshenzisweni kwezimpawu ezinqunyelwe umsebenzi ngamunye..
Sum
Ukwenza isamba se-Excel kumele sifake ifomula elandelayo:
=USUM(A1:A2) noma =USUM(2+2)
Njengoba sibona, ifomula isekela izindlela ezimbili, eyodwa ukwengeza amaseli amabili ahlukene futhi enye ukwengeza izinombolo ezimbili ngaphakathi kweseli efanayo.
Bamba
Ngakolunye uhlangothi, ukususa inqubo kulula kakhulu ngoba kufanele usebenzise kuphela uphawu "-". Kulowo mqondo, sizoba nokuthile okufana nalokhu:
=A1–A3
Ngale ndlela, sikhipha amanani amaseli amabili, nakuba kungenzeka futhi ukukwenza ngezinombolo ngaphakathi kwawo.
Ukuphindaphinda
Njengokususa, ukuphindaphinda ku-Excel kusekelwe ekusebenziseni inkanyezi njengophawu. Ngakho-ke, ukuphindaphinda izakhi ezimbili noma ngaphezulu sizoba nokuthile:
=A1*A3
Kuyaphawuleka ukuthi, njengasezimweni ezedlule, singaphindaphinda amanani amabili ngaphakathi kweseli efanayo.
Isigaba
Ekugcineni, ukwenza imisebenzi yokuhlukanisa, sizosebenzisa ibha njengophawu. Ngale ndlela sine:
= A1/A3
Futhi, ungasebenzisa ifomula efanayo ukuhlukanisa izinombolo ezimbili kuseli.
I-AVERAGE
Ifomula EYISILINGANISO iwusizo kakhulu emikhakheni eminingi futhi njengoba igama layo libonisa, isisiza ukuthi sithole inani elimaphakathi phakathi kwesethi yezinombolo ezikhethiwe. Kufanele kuqashelwe ukuthi lokhu kusebenza kubuye kwaziwe ngokuthi Mean noma Arithmetic Mean futhi kukhona kakhulu emkhakheni wezemfundo kanye nasezibalweni.
Ukuze uyisebenzise kufanele ufake:
=ISILINGANISO(A1:B3)
SI
Umsebenzi we-IF uyingxenye yamafomula anemibandela, uwusizo kakhulu lapho sidinga ukuhlola ukuthi isimo esithile siyiqiniso noma cha.. Lokhu kusetshenziswa ikakhulukazi ezindaweni ezifana nezifundiswa, isibonelo, lapho singaba khona nohlu lwabafundi abanamabanga abo futhi eduze kwalo nepheshana elibonisa ukuthi baphumelele noma cha. Ngale ndlela, kufanele sibeke ifomula ukuze iqinisekise uma isimo sifinyelelwa.
Kulowo mqondo, i-syntax imi kanje:
=IF(Isimo, Inani uma kuyiqiniso, Inani uma lingelona iqiniso)
Ngakho-ke, uma izinga lokuphasa lingu-50, sizoba nesibonelo esifana nalesi:
= YEBO(B2>=50, PASS, FAIL)
UZOBALA
I-COUNTA ingelinye lamafomula ayisisekelo okufunda ukusebenzisa i-Excel okufanele siyiphathe ngenxa yokusetshenziswa kwayo okukhulu. Ngayo, ungakwazi ukubala inani lamaseli anedatha ekhona ebangeni elinikeziwe. Ngale ndlela, uma udinga ukwazi inani lezinto kukholamu nokuthi libuye libuyekezwe, ungalisebenzisa.
Ukuze wenze lokhu, i-syntax imi kanje:
I-COUNTA (A1:B3)
Ngaphakathi kubakaki ungafaka ububanzi bamaseli owadingayo ukuze uqinisekise futhi uzoba nomphumela ngokushesha.
I-HYPERLINK
Nakuba i-Excel izibona izixhumanisi lapho sizifaka futhi iziguqule ngokushesha zibe isixhumanisi esifinyeleleka ngokuchofoza, ifomula ye-HYPERLINK ithatha lokhu kungenzeka iqhubeke kancane. Ngalowo mqondo, singakwazi ukwenza ngokwezifiso umbhalo wesixhumanisi, senze umbhalo othile uvele esikhundleni sesixhumanisi.
Ifomula kanje:
=HYPERLINK(isixhumanisi, umbhalo)
=HYPERLINK(“www.windowsnoticias.com”, “Yazi iwebhusayithi yethu”)
VLOOKUP
I-VLOOKUP ingenye yemisebenzi edume kakhulu ku-Excel futhi izokuvumela ukuthi uthole inani olifunayo phakathi kohlu lwamaseli.. Ngale ndlela, uzokwazi ukugwema ukudlula kuseli ngalinye ukuze uthole idatha oyidingayo futhi esikhundleni salokho, kuyokwanela ukusebenzisa ifomula okukhulunywa ngayo. I-syntax imi kanje:
=IBHEKA(IFUNA INANI, UHLELO LWAMASISI, INANI LEKHOLAMU LAPHO IMINININGWANE ELIBHEKAYO ITHOLAKALA KHONA, IYA-ODWA)
Ngalo mqondo, ipharamitha yokuqala okumelwe ifakwe yinani elifunwayo, elingeyona into engaphezu kwereferensi esizoyisebenzisa ukuze sithole idatha okukhulunywa ngayo. Bese, kube yithuba lebanga lamaseli lapho ukusesha kuzokwenziwa khona bese wengeza inombolo yekholomu lapho idatha esifuna ukuyithola itholakala khona.. Amakholomu aqala enombolweni ukusuka kuleyo oyikhethile. Okokugcina, Okuhleliwe kubhekisela ekutheni ukusesha kuzobuyisela okufanayo ngqo noma okucishe kufane. Ukuze uthole okufanayo ngqo, faka FALSE.