Ungawabeka kanjani amafomula ku-Excel

Isibuyekezo sokugcina: 6 de julio de 2025
Author: Dr369
  • I-Excel ibalulekile ekuphathweni kwedatha, futhi ukusebenza kwayo kuthuthukiswa ngokusebenzisa amafomula.
  • Amafomula akhiwe ngama-opharetha, izinkomba kanye nama-constants, abalulekile ekusetshenzisweni kwawo ngendlela efanele.
  • Ukwenza kahle imisebenzi efana ne-SUM, I-AVERAGE ne-IF kuvumela ukuhlaziya okusebenza kahle kakhudlwana.
  • Imisebenzi yokufaka isidleke isiza ukubala okuyinkimbinkimbi, ikhulise ukuguquguquka ekusetshenzisweni kwedatha.
Ungawabeka kanjani amafomula ku-Excel

Ezweni lanamuhla lapho idatha inguphethiloli oshayela impumelelo yebhizinisi, i-Excel isiyithuluzi elibalulekile. Kodwa-ke, abasebenzisi abaningi abakaze balwele ingaphezulu lamandla ayo. Uma ufuna ukuyisa amakhono akho e-Excel ezingeni elilandelayo futhi usheshise ukukhiqiza kwakho, ukufunda ukusebenzisa amafomula ngendlela efanele kubalulekile. Kulesi sihloko, wena Sizodalula ezinye izimfihlo amathuluzi angenaphutha azokusiza ukwazi amafomula e-Excel futhi uthole okuningi kulesi sipredishithi esinamandla.

Ungawabeka kanjani amafomula ku-Excel

Isingeniso

I-Excel iyithuluzi elinamandla lokuhlaziya idatha kanye nokukhohlisa, futhi esinye sezici zayo eziwusizo kakhulu yikhono lokusebenzisa amafomula ukwenza izibalo ezizenzakalelayo. Lawa mafomula avumela abasebenzisi ukuthi benze imisebenzi eminingi yezibalo, izibalo kanye nezezimali kalula nangokunemba. Kusukela ekungezeni izinombolo ezilula ukuya ekuhlaziyeni idatha eyinkimbinkimbi, amafomula e-Excel abalulekile ukuze kukhuliswe ukusebenza kahle nokunemba ekulawuleni ulwazi.

Sizohlola indlela yokubeka amafomula ku-Excel, kusukela kokuyisisekelo kuye kumasu athuthuke kakhulu. Ukufunda ukusebenzisa amafomula ku-Excel kungaba yikhono eliyigugu kunoma ubani osebenza ngedatha, kungaba sebhizinisini, kwezemfundo, noma endaweni yomuntu siqu.

Amafomula ku-Excel ayizibalo ezenza izibalo ngokusekelwe kumanani kwamanye amaseli. Ukufaka ifomula, mane uchofoze kuseli lapho ufuna kuvele khona umphumela bese uthayipha uphawu olulinganayo (=) olulandelwa yinkulumo ofuna ukuyihlola. Isibonelo, uma ufuna ukuhlanganisa amanani kumaseli A1 no-B1, ungafaka ifomula =A1+B1 kuseli okuyiwa kuyo.

Excel amafomula
I-athikili ehlobene:
Amafomula e-Excel: Isisekelo Sokukhiqiza!

1. Qonda i-syntax eyisisekelo

1.1 Izinto zefomula Ngaphambi kokuthi ungene emhlabeni wamafomula, kubalulekile ukuqonda izici zawo eziyisisekelo. Ifomula ku-Excel iqukethe izingxenye ezintathu eziyinhloko: ama-opharetha, izinkomba zamaseli, nama-constants.

Ama-opharetha ayizimpawu ezibonisa umsebenzi okufanele wenziwe, njengokuthi +, -, *, /, ^ (amandla), njll. Izinkomba zeseli ziyizixhumanisi zamaseli amanani azo azosetshenziswa ekubalweni, njenge-A1, B2, C3, njll. Ama-Constant amanani ezinombolo noma ombhalo afakwe ngqo kufomula.

1.2 Uhlelo lokusebenza Njengasezibalo, amafomula ku-Excel alandela uhlelo oluthile lokusebenza: okokuqala izinkulumo ezikubakaki ziyahlolwa, bese kuba amandla nezimpande, bese kuba ukuphindaphinda nokuhlukanisa (kusuka kwesokunxele kuye kwesokudla), bese ekugcineni kuhlanganisa nokukhipha (kusuka kwesobunxele kuya kwesokudla). Ungasebenzisa abakaki ukulawula ukuhleleka kokusebenza.

2. Imisebenzi Ebalulekile ye-Excel

2.1 SUMA Umsebenzi we-SUM ungomunye wemisebenzi esetshenziswa kakhulu ku-Excel. Ikuvumela ukuthi uhlanganise ibanga lamaseli noma uhlu lwamanani. Isibonelo, =SUM(A1:A10) izongeza wonke amanani kumaseli A1 kuya ku-A10. Ungakwazi futhi ukwengeza amanani angawodwana: =SUM(A1, B2, C3).

2.2 ISILINGANISO Umsebenzi othi AVERAGE ubala isilinganiso se-arithmetic sobubanzi bamaseli noma uhlu lwamanani. Kuwusizo kakhulu ukuthola ama-avareji amamaki, ukuthengisa, amazinga okushisa, njll. I-syntax ifana ne-SUM: =I-AVERAGE(A1:A10) noma =I-AVERAGE(A1, B2, C3).

2.3 MAX kanye MIN Le misebenzi ikuvumela ukuthi uthole inani eliphezulu noma eliphansi kuhlu lwamaseli noma uhlu lwamanani. Ngokwesibonelo, =MAX(A1:A10) izobuyisela inani eliphakeme kakhulu kumaseli A1 kuya ku-A10, kuyilapho =MIN(A1:A10) izobuyisela inani eliphansi kakhulu.

2.4 COUNT kanye ne-COUNTIF COUNT ibala inani lamaseli aqukethe izinombolo kububanzi obushiwo, iziba amaseli angenalutho. Isibonelo, =COUNT(A1:A10) izobala ukuthi mangaki amaseli ku-A1 kuya ku-A10 aqukethe amanani ezinombolo.

Umsebenzi we-COUNTIF unamandla nakakhulu, njengoba ubala inani lamaseli ahlangabezana nombandela othile. Ungayisebenzisela ukubala amaseli aqukethe inani elithile, umbhalo othize, noma ahlangabezana nombandela. Ungafunda ukusebenzisa amafomula ku-Excel ukuze uthole ukuqonda okujulile kwale misebenzi.

3. Amafomula ezibalo athuthukile

3.1 Amandla nezimpande I-Excel ikuvumela ukuthi wenze izibalo ngamandla nezimpande usebenzisa ama-opharetha ^ kanye ne-sqrt() ngokulandelanayo. Ifomula ethi =5^2 izophakamisa u-5 emandleni ka-2, okuholela ku-25. Ngakolunye uhlangothi, =sqrt(25) izobala impande yesikwele ka-25, ibuyisela u-5.

3.2 Imisebenzi ye-Trigonometric Uma usebenza ngama-engeli, amabanga noma i-geometry, imisebenzi ye-trigonometric ku-Excel izoba abalingani bakho abakhulu. Ungasebenzisa i-SIN() ukuze ubale i-sine, i-COS() ye-cosine, i-TAN() ye-tangent, kanye nokuphambene kwakho okuhambisanayo ASENO(), ACOS() kanye ne-ATAN().

3.3 Ama-logarithm nama-exponentials Imisebenzi ye-LOG() kanye ne-EXP() ikuvumela ukuthi wenze izibalo ezihlanganisa ama-logarithms nama-exponentials. I-LOG(inombolo, ) izobuyisela i-logarithm yenombolo kusisekelo esishiwo (uma singekho isisekelo esinikeziwe, kuthathwa u-10). I-EXP(inombolo) izobala umphumela wokukhulisa inombolo engu-e (2.718281828459045…) emandleni ashiwo.

  I-Google Amafomu yenzelwe ini?

4. Ukusebenza ngezinsuku nezikhathi

4.1 Usuku Imisebenzi I-Excel ihlinzeka ngemisebenzi eyahlukene yokusebenza namadethi, njengokuthi IDETHI() ukwakha idethi ezingxenyeni zayo (unyaka, inyanga, usuku), USUKU() ukuze uthole usuku lwedethi, INYANGA() yenyanga, kanye NONYAKA() yonyaka.

4.2 Imisebenzi yesikhathi Ngokufanayo, kukhona imisebenzi yokusebenza ngezikhathi, njengokuthi HOUR() ukuze udale inani lesikhathi kusukela emahoreni, amaminithi, namasekhondi, MINUTE() ukuze uthole amaminithi enanini lesikhathi, kanye no-SECOND() amasekhondi.

4.3 Izibalo ezinezinsuku nezikhathi Ngaphezu kwemisebenzi eshiwo ngenhla, ungenza imisebenzi yezibalo ngamadethi nezikhathi ku-Excel. Isibonelo, uma ukhipha amadethi amabili, uzothola inani lezinsuku phakathi kwawo. Uma wengeza noma ukhipha inombolo kudethi, uzothola idethi entsha enalelo nani lezinsuku ezingeziwe noma ezikhishiwe.

5. Amafomula ombhalo kanye nedatha

5.1 Hlanganisa umbhalo Umsebenzi we-CONCATENATE() ukuvumela ukuthi uhlanganise iyunithi yezinhlamvu zombhalo ezimbili noma ngaphezulu ube yiseli eyodwa. Isibonelo, =CONCATENATE("Sawubona ", "umhlaba") izobuyisela "Sawubona mhlaba".

5.2 Khipha ingxenye yombhalo Ungasebenzisa umsebenzi we-EXTRA() ukukhipha ingxenye ethile yombhalo. I-syntax ithi MIX(umbhalo, ukukhishwa_ukuqala, izinhlamvu_zenombolo). Isibonelo, =MID("Sawubona Umhlaba", 6, 5) izobuyisela "umhlaba".

5.3 Ukushintsha nokususa izinhlamvu Umsebenzi we-SUBSTITUTE() ikuvumela ukuthi umiselele ingxenye yombhalo ngomunye. I-syntax yayo ithi SUBSTITUTE(umbhalo, ukukhishwa_kokuqala, izinhlamvu_zezinombolo, umbhalo_omusha). Isibonelo, =SUBSTITUTE("Sawubona Mhlaba", 6, 5, "Excel") izobuyisela "Sawubona Excel".

Ukuze ususe izinhlamvu embhalweni, ungasebenzisa i-REPLACE() ngochungechunge olungenalutho njengombhalo_omusha.

Ukufundwa okunconyiwe:  Ukubamba okuyisisekelo kwe-Excel

6. Amafomula anengqondo nanemibandela

6.1 YEBO Umsebenzi we-IF() ungomunye wemisebenzi ewusizo kakhulu ku-Excel. Ikuvumela ukuthi uhlole umbandela bese ubuyisela inani uma lifinyelelwa, noma elinye inani uma lingahlangabezwanga. I-syntax ithi: =IF(isimo, inani_uma_iqiniso, inani_uma_amanga). Isibonelo, =IF(A1>10, "Pass", "Fail") izobuyisela okuthi "Pass" uma i-A1 inkulu kuno-10, noma "Fail" ngenye indlela.

6.2 Futhi noma Ungakwazi ukuhlanganisa izimo eziningi usebenzisa u-AND() kanye no-OR() imisebenzi. AND() ibuyisela TRUE uma zonke izimo kuhlangatshezwana nazo, kuyilapho OR() ibuyisela TRUE uma okungenani umbandela owodwa ufinyelelwa.

6.3 I-SUM.IF.SET Umsebenzi we-SUMIF() ikuvumela ukuthi uhlanganise amanani kububanzi obuhlangabezana nemibandela eyodwa noma ngaphezulu. Kuwusizo kakhulu ekwenzeni izibalo eziyinkimbinkimbi ngokusekelwe kumibandela ethile.

7. Izinkomba zamaseli kanye nama-opharetha

Ku-Excel, izinkomba zamaseli kanye nama-opharetha kubalulekile ekwakheni amafomula anembile nasebenzayo. Ukuqonda ukuthi zisebenza kanjani kuzokuvumela ukuthi uguqule idatha ngendlela efanele.

Izinkomba zeseli

Izinkomba zeseli amakheli akhomba indawo yeseli ekhasini lokusebenza. Asetshenziswa kumafomula ukuze ucacise ukuthi iyiphi idatha okufanele isetshenziswe ezibalweni.

  • izinkomba ezihlobene: Lezi yizona ezivame kakhulu futhi zilungiswa ngokuzenzakalelayo lapho ifomula ikopishelwa kwamanye amaseli. Isibonelo, uma unefomula kuseli B2 enezela amaseli B1 kanye no-B2 (=B1+B2), uma ukopisha leyo fomula kuseli C2, izozijwayeza ngokuzenzakalelayo ukuze (=C1+C2).
  • izinkomba eziphelele: Ahlala engashintshi kungakhathaliseki ukuthi ifomula ikopishwe kuphi. Aboniswa ngokubeka uphawu lwedola ($) ngaphambi kwekholomu, umugqa, noma kokubili. Isibonelo, ireferensi ephelele yeseli A1 ingaba ngu-$A$1.
  • izinkomba ezixubile: Balungisa ingxenye eyodwa yereferensi (umugqa noma ikholomu) kuyilapho enye ingxenye ihlobene. Isibonelo, i-$A1 ilungisa ikholomu A kodwa ivumela umugqa ukuthi ushintshe lapho ukopisha ifomula.

Opharetha

Ama-opharetha ayizimpawu ezisetshenziswa kumafomula ukwenza izibalo phakathi kwamanani.

  • Opharetha bezibalo: Asetshenziselwa ukwenza imisebenzi yezibalo eyisisekelo njengokuhlanganisa (+), ukususa (-), ukuphindaphinda (*), ukuhlukanisa (/), phakathi kokunye.
  • iziqhathaniso opharetha: Zikuvumela ukuthi uqhathanise amanani bese ubuyisela umphumela weqiniso noma ongamanga. Ezinye izibonelo zifaka phakathi ukulingana (=), okukhulu kuno (>), ngaphansi kuka (<), njll.
  • Abaqhubi be-Concatenation: Asetshenziselwa ukuhlanganisa noma ukuhlanganisa iyunithi yezinhlamvu zombhalo. U-opharetha wokuhlanganisa ku-Excel wuphawu “&”.
  • Opharetha abanengqondo: Zikuvumela ukuthi uhlole izimo ezinengqondo bese ubuyisela umphumela weqiniso noma ongamanga. Ezinye izibonelo FUTHI, NOMA, HHAYI.

Kubalulekile ukuqonda indlela yokusebenzisa kahle amareferensi nama-opharetha ku-Excel ukwakha amafomula anembile nasebenzayo. Ngokuzijwayeza nokuqonda le mibono, uzokwazi ukwenza izibalo eziyinkimbinkimbi nokuhlaziya idatha kalula.

Ikholomu Nomugqa ku-Excel
I-athikili ehlobene:
Ikholomu Nomugqa ku-Excel: Ungawasebenzisa Kanjani Ukuze Udale AmaSpredishithi Aphumelelayo

8. Imisebenzi echazwe ngaphambilini

Imisebenzi echazwe ngaphambilini ku-Excel ingamathuluzi anamandla enza ngokuzenzakalelayo imisebenzi evamile futhi enze izibalo ezithile ngokushesha nangempumelelo. Ukwazi le misebenzi kuzokongela isikhathi futhi kuthuthukise ukunemba kokuhlaziywa kwedatha yakho.

Isingeniso semisebenzi echazwe ngaphambilini

Imisebenzi echazwe ngaphambilini ingamafomula akhelwe ngaphakathi ku-Excel enza imisebenzi ethile. Le misebenzi yakhelwe ukubhekana nezinhlobonhlobo zezidingo, kusukela ekubalweni kwezibalo ezilula kuya ekuhlaziyweni kwezibalo okuthuthukisiwe kanye nokukhohlisa kombhalo.

  I-Android Recycle Bin: Lapho ikhona nokuthi isetshenziswa kanjani

Izibonelo zemisebenzi evamile

  1. I-SUMA: Lo msebenzi uhlanganisa amanani ebangeni lamaseli. Isibonelo, =SUM(A1:A10) ingeza amanani kumaseli A1 kuya ku-A10.
  2. I-AVERAGE: Ibala isilinganiso samanani ebangeni lamaseli. Isibonelo, =I-AVERAGE(B1:B5) izobuyisela isilinganiso samanani kumaseli B1 ukuya ku-B5.
  3. OKUNINGI/UMUNTU: Le misebenzi ibuyisela inani eliphezulu noma eliphansi kububanzi bamaseli. Ngokwesibonelo, =MAX(C1:C20) izobuyisela inani eliphakeme kumaseli C1 kuya ku-C20.
  4. TSHELA: Ibala inani lamaseli aqukethe izinombolo kububanzi obushiwo. Isibonelo, =COUNT(D1:D10) izobala ukuthi mangaki amaseli kububanzi D1 kuya ku-D10 aqukethe izinombolo.
  5. SI: Ihlola isimo bese ibuyisela inani elilodwa uma isimo siyiqiniso kanti elinye uma lingamanga. Isibonelo, =IF(A1>10, "Pass", "Fail") izobuyisela "Pass" uma inani kuseli A1 likhulu kuno-10, kungenjalo izobuyisela "Fail".

Ukusetshenziswa Okuthuthukisiwe Komsebenzi

Ngokungeziwe kule misebenzi eyisisekelo, i-Excel inikezela ngezinhlobonhlobo zemisebenzi ekhethekile yokwenza imisebenzi ethuthuke kakhulu. Lokhu kufaka phakathi imisebenzi yezibalo efana ne-STDEV, imisebenzi yezezimali efana ne-PV, kanye nemisebenzi yokubheka nereferensi efana ne-VLOOKUP.

Amathiphu okusebenzisa imisebenzi echazwe ngaphambilini

  • Funda imibhaloZijwayeze imisebenzi etholakala ku-Excel kanye ne-syntax yayo efanele ngokubonana nemibhalo esemthethweni ye-Microsoft noma izinsiza eziku-inthanethi.
  • Prakthiza ngezibonelo: Linga ngemisebenzi eyahlukene nezibonelo ukuze uqonde kangcono ukuthi zisebenza kanjani nokuthi zingasetshenziswa kanjani ezidingweni zakho ezithile.
  • Hlola izici ezithuthukile: Ungesabi ukuhlola izici ezithuthuke kakhulu ukuze wenze ukuhlaziya okuyinkimbinkimbi futhi uthole imininingwane ejulile ngedatha yakho.

Ukwenza kahle imisebenzi eyakhelwe ngaphakathi ye-Excel kuzokunikeza amathuluzi owadingayo ukuze wenze izibalo ezinembile kanye nokuhlaziya idatha ngempumelelo kusipredishithi sakho.

 

9. Umsebenzi wokuzalela

Ukusebenza kwesidleke ku-Excel kuyindlela enamandla ekuvumela ukuthi uhlanganise imisebenzi eminingi ngaphakathi kwefomula ukuze wenze izibalo eziyinkimbinkimbi neziyinkimbinkimbi. Ngokuqonda indlela yokwenza isidleke imisebenzi, ungenza izinqubo ngokuzenzakalelayo futhi uthole imiphumela enembile kahle.

Kuyini ukukhiqiza isidleke?

Ukwenza isidleke kuhlanganisa ukusebenzisa umsebenzi ngaphakathi komunye umsebenzi njengengxenye yempikiswano yawo. Lokhu kukuvumela ukuthi wenze izibalo eziningi ngendlela eyodwa, wonge isikhathi nesikhala kusipredishithi sakho.

Izibonelo zokuzalanisa umsebenzi

  1. Isidleke SUM kanye ne-AVERAGE: Ake sithi ufuna ukubala isilinganiso samanani afingqiwe ebangeni lamaseli. Ungafinyelela lokhu ngokufaka imisebenzi ye-SUM kanye ne-AVERAGE kanje:
    =PROMEDIO(SUMA(A1:A10), SUMA(B1:B10))

    Lokhu kuzokwengeza amanani kububanzi A1:A10 kanye no-B1:B10 bese kubala isilinganiso saleyo miphumela emibili.

  2. Isidleke IF kanye ne-SUM: Cabanga ukuthi ufuna ukuhlanganisa kuphela amanani amakhulu kunomkhawulo othile ebangeni lamaseli. Ungakwazi ukufeza lokhu ngokufaka isidleke imisebenzi ye-IF ne-SUM ngale ndlela elandelayo:
    =SUMA(SI(A1:A10>5, A1:A10, 0))

    Lokhu kuzohlanganisa kuphela amanani ebangeni A1:A10 amakhulu kuno-5 futhi kubuyisele u-0 kulawo angahlangabezani nombandela.

  3. Isidleke se-VLOOKUP ne-SUMUma udinga ukubheka inani elithile kuthebula bese wenza isamba samanani alowo mugqa, ungakwazi ukuhlanganisa imisebenzi ye-VLOOKUP ne-SUM kanje:
    =SUMA(BUSCARV("Valor a buscar", A1:D10, 2, FALSO))

    Lokhu kuzobheka inani kukholomu A1:D10, bese kuhlanganisa amanani ahambisanayo kukholamu yesibili yomugqa lapho lelo nani litholakala khona.

Amathiphu emisebenzi yokuzalela

  • Gcina ifomula ifundekaUkwenza isidleke okweqile kwemisebenzi kungenza ifomula ibe nzima ukuyiqonda. Zama ukukugcina kucace ngangokunokwenzeka ngokusebenzisa imigqa eyengeziwe nezikhala.
  • Ukuhlolwa kwesinyathelo ngesinyathelo: Uma wenza isidleke semisebenzi eminingi, hlola ifomula ngesinyathelo ukuze wenze isiqiniseko sokuthi ingxenye ngayinye isebenza kahle ngaphambi kokwengeza imisebenzi eyengeziwe.
  • Bhala ifomula yakho: Uma ifomula iyinkimbinkimbi, kuyasiza ukubhala injongo yayo nesakhiwo ukuze kube lula ukuqonda nokulungiswa kwesikhathi esizayo.

Ukwenza isidleke sokusebenza kahle ku-Excel kukuvumela ukuthi wenze izibalo ezithuthukile nokuhlaziya idatha eyinkimbinkimbi kalula. Ngokuzijwayeza nokuqonda imiqondo, ungasebenzisa ngokugcwele lesi sici esinamandla se-Excel.

10. Amafomula athuthukile: Ungawabeka kanjani amafomula ku-Excel

Ku-Excel, amafomula athuthukile akuvumela ukuthi wenze ukuhlaziya idatha eyinkimbinkimbi, ulawule umbhalo nezinsuku, ukusesha kanye nolwazi lokuhlunga, neminye imisebenzi ethuthukisiwe. Lawa mafomula ahlinzeka ngamathuluzi anamandla okuxazulula izinkinga ezithile nokukhipha imininingwane ewusizo kudatha yakho.

Ukusebenzisa ukusesha kanye nemisebenzi yereferensi

  1. VLOOKUP: Lo msebenzi ukuvumela ukuthi ubheke inani kukholomu yokuqala yethebula futhi ubuyisele inani kumugqa ofanayo wekholomu eshiwo. Kuwusizo ekusesheni idatha kumasethi amakhulu olwazi.
  2. HLOOKUP: Ifana ne-VLOOKUP, kodwa ibheka inani elikumugqa wokuqala wethebula futhi ibuyisela inani kukholomu efanayo kumugqa oshiwo. Iwusizo ekusesheni ulwazi kumathebula anedatha ehlelwe ngokuvundlile.
  3. INDEX kanye ne-MATCH: Le misebenzi ihlangana ukuze iseshe futhi ithole inani elithile kuthebula. I-INDEX ibuyisela inani kuseli elithile kumalungu afanayo, kuyilapho i-MATCH ibheka inani kububanzi futhi ibuyisela indawo yalo.

Imisebenzi yezibalo ethuthukisiwe

  1. I-STDEV: Ibala ukuchezuka okujwayelekile kwesethi yamanani. Iwusizo ekulinganiseni ukusakazeka kwedatha ngokuhlobene nencazelo.
  2. I-CORREL: Ibala i-coefficient yokuhlobana phakathi kwamasethi amabili edatha. Kuyasiza ukunquma ukuthi kukhona yini ubudlelwano phakathi kweziguquguquki ezimbili.
  3. IMVAMILE: Ibuyisela imvamisa yokusabalalisa njengohlelo oluqondile. Kuwusizo ekuhlaziyeni ukusatshalaliswa kwamanani kusethi yedatha.

Ukushintsha umbhalo namadethi

  1. QHUBEKA: Ihlanganisa imibhalo embalwa ibe munye. Kuwusizo ekuhlanganiseni idatha esuka kumaseli ahlukene ngefomethi ethile.
  2. TEXT: Iguqula inani lenombolo libe umbhalo kusetshenziswa ifomethi ethile. Iwusizo ekufometheni amadethi nezinombolo ngokwezidingo zakho.
  3. IDETHI NEZINSUKU ZOMSEBENZI: Le misebenzi ikuvumela ukuba wenze izibalo namadethi, njengokwengeza izinsuku osukwini noma ukubala umehluko phakathi kwezinsuku ezimbili ngaphandle kwezimpelasonto.

Amathiphu okusebenzisa amafomula athuthukile

  • Ukuqonda i-logic: Ngaphambi kokusebenzisa ifomula ethuthukisiwe, qiniseka ukuthi uyaqonda ukuthi isebenza kanjani nokuthi iyini inhloso yayo. Lokhu kuzokusiza ukuthi ukusebenzise ngendlela efanele kudathasethi yakho.
  • Prakthiza ngezibonelo: Linga ngezibonelo ezingokoqobo ukuze ujwayelane nokusebenzisa amafomula athuthukile ezimeni ezahlukahlukene.
  • Bheka imibhalo: Noma nini lapho unemibuzo mayelana nokusebenzisa umsebenzi othile, bheka imibhalo ye-Excel noma sesha izinsiza eziku-inthanethi ukuze uthole ulwazi olwengeziwe.

Ukwenza amafomula athuthukile ku-Excel kukuvumela ukuthi wenze ukuhlaziya okuningiliziwe futhi uthole imininingwane ebalulekile kudatha yakho. Ngokuzijwayeza nokuqonda imiqondo, ungenza okuningi kulawa mathuluzi ukuze uthuthukise amakhono akho okuphatha idatha.

Imibuzo ejwayelekile: Ungawabeka kanjani amafomula ku-Excel

Ingabe amafomula endabeni ye-Excel ayazwela? Cha, amafomula ku-Excel awazwela kakhulu. Isibonelo, =USUM(A1:A10) iyafana ne=isamba(a1:a10).

Ngingakwazi ukusebenzisa amafomula kumaseli amaningi ngesikhathi esisodwa? Yebo, ungakhetha uhla lwamaseli bese uhudula isibambo sokugcwalisa (isikwele esincane ekhoneni elingezansi kwesokudla) ukuze ugcwalise ngokuzenzakalelayo amaseli ngefomula efanayo.

Ngingawagwema kanjani amaphutha ereferensi ayindilinga kumafomula ami? Ireferensi eyindilinga yenzeka lapho ifomula ibhekisela kuseli layo, ngokuqondile noma ngokungaqondile. Ukuze ugweme lokhu, qiniseka ukuthi awuzidali izinkomba eziyindilinga kumafomula akho.

Iyini ifomula ehlanganisiwe futhi uyisebenzisa kanjani? Ifomula ehlanganisiwe iyifomula equkethe enye ifomula njengempikiswano. Isibonelo, =USUM(ISILINGANISO(A1:A10), ISILINGANISO(B1:B10)). Lokhu kungenza amafomula akho abe nzima kakhulu, kodwa futhi abe namandla kakhulu.

Ngingawavikela kanjani amafomula ami ukuze ngivimbele izinguquko zengozi? Ungakwazi ukuvikela amaphepha okusebenza namaseli akho ngamafomula usebenzisa inketho ethi “Vikela Ishidi” kuthebhu ethi “Buyekeza” yeribhoni ye-Excel.

Ingabe ikhona indlela yokwenza amafomula ami abe lula ukuwafunda nokuwagcina? Yebo, ungasebenzisa amagama obubanzi ukuze ubhekisele kumaseli noma ububanzi obunamagama achazayo esikhundleni sezixhumanisi. Ungakwazi futhi ukwengeza amazwana kumafomula akho ukuze uchaze injongo nokusebenza kwawo.

Isiphetho: Ungawabeka kanjani amafomula ku-Excel

Ukwenza kahle amafomula e-Excel kuyikhono eliyigugu lanoma yimuphi uchwepheshe wedatha. Ngokuqonda i-syntax eyisisekelo, imisebenzi ebalulekile, amafomula ezibalo athuthukisiwe, ukusebenza namadethi nezikhathi, ukusebenza kombhalo nedatha, namafomula anengqondo nanemibandela, ungathatha ukukhiqiza kwakho kumazinga amasha. Khumbula ukuthi ukuzijwayeza kuwukhiye wokucija lawa makhono kanye nokuthola izindlela ezintsha zokusebenzisa amandla e-Excel. Qhubeka uhlola futhi ungayeki ukufunda!

Ingabe usukulungele ukuba yingcweti yamafomula e-Excel? Yabelana ngalesi sihloko nozakwenu nabangane ukuze nabo bathole izimfihlo esizidalulile. Ngokuhlangene, singakhuphula amakhono ethu futhi sibe ochwepheshe bangempela ekuphathweni kwedatha. Ungakhohlwa ukushiya imibono nemibuzo yakho ngezansi. Silapha ukuze sikusize endleleni yakho eya e-Excellence!