Kwindawo yoqeqesho lwe-Excel, iyamangalisa indlela iifomyula ezimbalwa ezilula ezinokunyusa ukusebenza kakuhle kwakho xa usebenza ngedatha. Ndiyakumema ukuba funda iifomyula ze-Excel ukusuka ekuqaleni okanye ukuphucula izakhono zakho ezikhoyo. Ngeli nqaku, ndiza kukwazisa kwihlabathi elinomdla le-Excel, ndikuxhobisa ngezixhobo ezibalulekileyo zokuqalisa uhambo lwakho olusingise esi sixhobo sinamandla sokuhlalutya.
Kutheni ufunda iiFomula ze-Excel?
I-Excel ayisosixhobo nje sokwenza iitafile. Yindalo epheleleyo yokuhlalutya kunye nokulawulwa kwedatha okunokwenzeka. Ukwazi iifomula ezifanelekileyo kunokukunceda:
– Yenza imisebenzi ephindaphindwayo, ukonga ixesha kunye nokunciphisa iimpazamo.
– Hlalutya imithamo emikhulu yedatha, ukufumana ulwazi oluxabisekileyo obelungayi kuphawulwa.
– Ukwenza izigqibo ezisekelwe kulwazi ngokusekelwe kuhlalutyo oluchanekileyo.
– Phucula izakhono zakho zokusebenza, ngesakhono sokwandisa ukuqesheka kwakho.
Iifomyula ze-Excel eziyimfuneko ukuze uqalise
Ngezantsi, ndinikezela kuwe ukhetho lweefomula ezibalulekileyo ekufuneka wonke umntu oqalayo azazi. Ezi zisebenza njengesiseko apho ulwazi lwakho lwe-Excel luya kwakhiwa.
- UKWONGEZA
Inkcazo: Yongeza uluhlu lweeseli.
Isintaksi: =SUM(inombolo1, [inombolo2], …)
Umzekelo: =ISIXA(A1:A10)
- UMLINGANISELO
Inkcazo: Ubala umndilili wamanani kuluhlu oluchaziweyo.
Isintaksi: =UMANDLA(inombolo1, [inombolo2], …)
Umzekelo: =UMLINGANISELO(B1:B10)
- IBALA
Inkcazo: Ibala ukuba zingaphi iiseli eziqulathe amanani kuluhlu.
Isintaksi: =COUNT(ixabiso1, [ixabiso2], ...)
Umzekelo: =COUNT(C1:C10)
- MAX kunye MIN
Inkcazo: Ifumana ubuninzi kunye ixabiso eliphantsi kuluhlu, ngokulandelelanayo.
Isintaksi: =MAX(inombolo1, [inombolo2], …) / =MIN(inombolo1, [inombolo2], …)
Umzekelo: =UMAX(D1:D10) / =MIN(D1:D10)
- SI
Inkcazo: Wenza uvavanyo olusengqiqweni kwaye ubuyisela ixabiso elinye ukuba olo vavanyo luyinyani, kunye nelinye ixabiso ukuba bubuxoki.
Isintaksi: =IF(uvavanyo_lobulumko, ixabiso_ukuba_yinyaniso, [ixabiso_ukuba_bubuxoki])
Umzekelo: =Ukuba(E1>5, «Ewe», »Hayi»)
IiNdlela eziGqwesileyo zokuSebenza ngeeFomula kwi-Excel
Ngelixa ukwazi iifomula kubalulekile, ukwazi ukuba zingasetyenziswa njani kwaye nini ngokufanelekileyo kubaluleke ngokulinganayo. Nanga amanye amacebiso aza kukunceda uphucule izakhono zakho ze-Excel:
– Sebenzisa izalathisi ezizalanayo nezipheleleyo ngokufanelekileyo ukuze iifomula zakho zisebenze kakuhle xa uzikhuphela kwezinye iiseli.
– Faka amagama kuluhlu lwakho ukwenza iifomula zakho zifundeke ngakumbi kwaye kube lula ukuziqonda.
– Jonga iifomula zakho ngenqaku elithi "Trace Precedents" ukuqonda ukuba idatha yakho iqhagamshelwa njani.
– Ziqhelise rhoqo ngeeprojekthi zokwenyani okanye ukulinganisa ukudibanisa ukufunda kwakho.
Ityala lokuHlalutya iNtengiso
Khawucinge ukuba unoxanduva lohlalutyo lwentengiso yenkampani yakho. Ngeefomula ezikhankanyiweyo, unako:
1. Yongeza iintengiso zizonke zexesha.
2. Bala umndilili weentengiso zemihla ngemihla.
3. Bala zingaphi iintsuku abagqithise kwinjongo ethile yokuthengisa.
4. Chonga usuku kunye nokuthengiswa okuphezulu kunye nokuncinci.
5. Yenza isigqibo Ngeziphi iintsuku zokuqhuba ukukhushulwa, usebenzisa ifomula SI ukumisela iintsuku ezineentengiso ezingaphantsi komndilili.
Ukuntywiliselwa kwe-Excel: Iifomyula ze-Excel zabaQalayo
Master the iifomula Excel Kubalulekile kuyo nayiphi na ingcali enqwenela ukusebenza ngokufanelekileyo ngedatha. Qala nge Funda ezi fomula zisisiseko, kwaye uziqhelise rhoqo, iya kukubeka ngokuqinileyo kwindlela eya kubuchule obuphambili kwi-Excel. Ukuziqhelanisa kwenza ukuba kugqibelele, kwaye kwimeko ye-Excel, oku akunakuba yinyani ngakumbi. Ndiyathemba ukuba eli nqaku lisebenze njengesikhokelo sakho sokuqala kwaye likukhuthaza ukuba uqhubeke ufunda kwaye uphande ngayo yonke into enokunikelwa yi-Excel.
NdinguSebastián Vidal, injineli yekhompyuter ethanda itekhnoloji kunye ne-DIY. Ngaphaya koko, ndingumdali we tecnobits.com, apho ndabelana ngee-tutorials ukwenza itekhnoloji ifikeleleke kwaye iqondeke kumntu wonke.