Imisebenzi yamanani e-Excel: Isifundo esinemizekelo yophando, icandelo lesine

I-Excel ibonelela ngoluhlu olubanzi lwemisebenzi yezibalo eyenza izibalo ukusuka kwisiseko esisisiseko, i-median, kunye nemowudi yokujonga imisebenzi.

Kweli nqaku siza kuphanda nzulu kwimisebenzi yokukhangela.

Nceda uqaphele ukuba eminye imisebenzi yamanani yaziswa kwiinguqulelo zamva nje ze-Excel kwaye ke ayifumaneki kwiinguqulelo ezindala.

Ixesha lokufunda eliqikelelweyo: 18 imizuzu

Khangela imisebenzi

MAX

Umsebenzi MAX ye-Excel idweliswe kudidi lweMisebenzi yeNkcazo ye-Microsoft Excel. Ibuyisela elona xabiso likhulu kuluhlu lwamaxabiso. MAX imele ubuninzi kwaye xa ukhankanya uluhlu lwamaxabiso lujonge elona xabiso liphezulu kuyo kwaye ibuyisela elo xabiso kwisiphumo.

syntax

= MAX(number1, [number2], …)

iingxoxo

• number1:  inani, iseli equlathe inani, okanye uluhlu lweeseli eziqulathe amanani apho ufuna ukufumana elona nani likhulu.
• [number2]:  inani yiseli equlathe inani okanye uluhlu lweeseli eziqulathe amanani apho ufuna ukufumana elona nani likhulu.

umzekelo

Ukwenza kakuhle umsebenzi we-MAX kufuneka sizame kumzekelo kwaye ngezantsi kukho onokuthi uzame:

Kulo mzekelo ulandelayo, sifake amanani ngokuthe ngqo kumsebenzi ngokuwahlula ngesiphumlisi.

Qaphela: ungangenisa inombolo usebenzisa ucaphulo oluphindiweyo.

Kulo mzekelo ulandelayo, sibonisa uluhlu kwaye isiphumo sabuya ngo-1861 njengelona xabiso likhulu. Ungabhekisa kwakhona kuluhlu.

Kulo mzekelo ulandelayo, sidibene nexabiso lemposiso kwaye umsebenzi ubuyise ixabiso lemposiso kwisiphumo.

MAXA

Umsebenzi we-Excel Maxa iyafana kakhulu ne Excel umsebenzi Max.

Umahluko kuphela phakathi kwemisebenzi emibini uyenzeka xa ingxabano inikezelwa kumsebenzi njengereferensi yeseli okanye uluhlu lweeseli.

Umsebenzi Max ayihoyi amaxabiso anengqiqo kunye nokubhaliweyo ngelixa umsebenzi Maxa ixabiso lengqiqo liyabala TRUE njengo-1, ixabiso elisengqiqweni FALSE njengo-0 kunye namaxabiso okubhaliweyo njengo-0.

Umsebenzi MAXA I-Excel ibuyisela elona xabiso likhulu ukusuka kwiseti enikiweyo yamaxabiso amanani, ukubala okubhaliweyo kunye nexabiso lengqiqo FALSE njengexabiso lika-0 kunye nokubala ixabiso lengqiqo TRUE njengexabiso lika-1.

syntax

= MAXA(number1, [number2], …)

iingxoxo

• number1:  inani (okanye uluhlu lwamaxabiso amanani), iseli equlathe inani, okanye uluhlu lweeseli eziqulathe amanani apho ufuna ukufumana elona nani likhulu.
• [number2]:  inani yiseli equlathe inani (okanye uluhlu lwamaxabiso amanani) okanye uluhlu lweeseli eziqulathe amanani apho ufuna ukufumana elona nani likhulu.

Kwiinguqulelo zangoku ze-Excel (i-Excel 2007 kunye nasemva koko), unokubonelela ukuya kuthi ga kwi-255 iingxabano zamanani kumsebenzi we-Maxa, kodwa kwi-Excel 2003 umsebenzi unokwamkela kuphela ukuya kwi-30 iingxoxo zamanani.

Imizekelo

Umzekelo 1

Iseli B1 yale spreadsheet ilandelayo ibonisa umsebenzi Excel Maxa, esetyenziselwa ukubuyisela elona xabiso likhulu kwiseti yamaxabiso kwiiseli A1-A5.

Umzekelo 2

Iseli B1 yale spreadsheet ilandelayo ibonisa umsebenzi Excel Maxa, esetyenziselwa ukubuyisela elona xabiso likhulu kwiseti yamaxabiso kwiiseli A1-A3.

Qaphela ukuba TRUE ixabiso kwiseli A1 yespreadsheet iphathwa njengexabiso lamanani 1 ngomsebenzi Maxa. Ngoko ke, eli lelona xabiso likhulu kuluhlu A1-A3.

Eminye imizekelo yomsebenzi Excel Maxa zibonelelwa nge Iwebhusayithi yeMicrosoft Office .

Impazamo yokusebenza MAXA

Ukuba ufumana impazamo kumsebenzi Maxa ye-Excel, oku kunokwenzeka ukuba yimpazamo #VALORE!: Kwenzeka ukuba amaxabiso anikezelwe ngokuthe ngqo kumsebenzi Maxa azingomanani.

MAXIFS

Umsebenzi we-Excel Maxifs ngumsebenzi wokukhangela obuyisela ixabiso eliphezulu ukusuka kwiseti yamaxabiso ekhankanyiweyo ngokusekelwe kwindlela enye okanye ngaphezulu.

syntax

= MAXIFS( max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ... )

iingxoxo

• max_range:  Uluhlu lwamaxabiso amanani (okanye uluhlu lweeseli eziqulathe amaxabiso amanani), apho ufuna ukubuyisela elona xabiso liphezulu ukuba iinqobo zokugweba zihlangatyeziwe.
• criteria_range1:  uluhlu lwamaxabiso (okanye uluhlu lweeseli eziqulathe amaxabiso) ukuvavanya ngokuchaseneyo criteria1 .(Olu luhlu kufuneka lulingane nobude obufanayo noluhlu_lobuninzi ).
• criteria1: Imeko yokuvavanya ngokubhekiselele kumaxabiso kwi criteria_range1.
• [criteria_range2, criteria2], [criteria_range3, criteria3], ...: Uluhlu olongezelelweyo olukhethiweyo lwamaxabiso okuvavanya kunye neemeko ezifanelekileyo zokuvavanya.

Umsebenzi Maxifs inokuphatha ukuya kuthi ga kwi-126 izihloko zezibini criteria_range e criteria.

Indlela nganye enikiweyo ingaba:

• ixabiso lamanani (elinokuba yinani elipheleleyo, idesimali, umhla, ixesha okanye ixabiso elisengqiqweni) (umz. 10, 01/01/2017, TRUE)

okanye

• umtya wokubhaliweyo (umz. “Igama”, “MercoleKwe")

okanye

• intetho (umzekelo “>1”, “<>0”).

Nei criteria enxulumene nokubhaliweyo ungasebenzisa wildcards:

• ? ukutshatisa nawuphi na umlinganiswa omnye
• * ukutshatisa naluphi na ulandelelwano lwabalinganiswa.

Ukuba i criteria ngumtya wokubhaliweyo okanye intetho, oku kufuneka kunikezelwe kumsebenzi Maxifs kwiingcaphuno.

Umsebenzi Maxifs Ayinabungozi. Ke ngoko, umzekelo, xa uthelekisa amaxabiso kwi criteria_range kunye nam criteria, imitya yokubhaliweyo "TEXT"E"text” ziya kugqalwa zilingana.

Umsebenzi Maxifs yaziswa okokuqala kwi-Excel 2019 kwaye ke ayifumaneki kwiinguqulelo zangaphambili ze-Excel.

Imizekelo

I-spreadsheet engezantsi ibonisa idatha yokuthengisa ngekota kubameli be-3 yokuthengisa.

Umsebenzi Maxifs ingasetyenziselwa ukufumana inani eliphezulu lentengiso kuyo nayiphi na ikota, indawo, okanye irep yokuthengisa (okanye nayiphi na indibaniselwano yekota, indawo, kunye nerep yokuthengisa).

Makhe sijonge le mizekelo ilandelayo.

Umzekelo 1

Ukufumana inani eliphezulu lentengiso kwikota yokuqala:

=MAXIFS( D2:D13, A2:A13, 1 )

enika isiphumo $ 456.000.

Kulo mzekelo, i-Excel Maxifs Ichonga iirowu apho ixabiso kumhlathi A lilingana no-1 kwaye ibuyisela elona xabiso liphezulu ukusuka kumaxabiso ahambelanayo kumhlathi D.

Oko kukuthi, umsebenzi ufumana amaxabiso aphezulu $223.000, $125.000 kunye $456.000 (ukusuka kwiiseli D2, D3 kunye D4).

Umzekelo 2

Kwakhona, usebenzisa i-spreadsheet yedatha apha ngasentla, sinokusebenzisa umsebenzi we-Maxifs ukufumana inani eliphezulu lokuthengisa "Jeff", ngexesha le-3 kunye ne-4:

=MAXIFS( D2:D13, A2:A13, ">2", C2:C13, "Jeff" )

Le fomula ibuyisela isiphumo $ 310.000 .

Kulo mzekelo, i-Excel Maxifs ichonga imigca apho:

• Ixabiso kumhlathi A likhulu kuno-2

E

• Ingeniso kukholomu C ilingana no-“Jeff”

kwaye ibuyisela ubuninzi bamaxabiso ahambelanayo kumhlathi D.

Oko kukuthi, le fomyula ifumana ubuninzi bexabiso le-$ 310.000 kunye ne-$ 261.000 (ukusuka kwiiseli ze-D8 kunye ne-D11).

Qhagamshelana ne Iwebhusayithi yeMicrosoft Office ngolwazi oluthe kratya kwimizekelo yomsebenzi we-Excel Maxifs.

Impazamo yokusebenza MAXIFS

Ukuba ufumana imposiso kwi-Excel function Maxifs, inokuba yenye yezi zilandelayo:

#VALUE!: Ijonga ukuba ii-arrays max_range e criteria_range ezinikiweyo azinabude obufanayo zonke.

@NAME?: Iyenzeka ukuba usebenzisa uguqulelo oludala lwe-Excel (pre-2019), olungalixhasiyo uphawu. Maxifs.

MIN

Umsebenzi MIN ngumsebenzi wokukhangela obuyisela elona xabiso lisezantsi kuluhlu lwamaxabiso. MIN imele ubuncinci kwaye xa ukhankanya uluhlu lwamaxabiso ikhangela elona xabiso liphantsi kuyo kwaye ibuyisela elo xabiso kwisiphumo.

syntax

= MIN(number1, [number2], …)

iingxoxo

• number1:  inani, iseli equlathe inani, okanye uluhlu lweeseli eziqulathe amanani apho ufuna ukufumana elona nani lincinci.
• [number2]:  inani, iseli equlathe inani, okanye uluhlu lweeseli eziqulathe amanani apho ufuna ukufumana elona nani lincinci.

umzekelo

Kulo mzekelo ulandelayo, sifake amanani ngokuthe ngqo kumsebenzi ngokuwahlula ngesiphumlisi.

Ungaphinda ufake inombolo usebenzisa izicaphulo eziphindiweyo. Ngoku, kulo mzekelo ulandelayo, sibonise uluhlu kwaye iziphumo ezibuyisiweyo yi-1070.

Kulo mzekelo ulandelayo, sidibene nexabiso lemposiso kwaye umsebenzi ubuyise ixabiso lemposiso kwisiphumo.

MINA

Umsebenzi we-Excel MINA iyafana kakhulu ne Excel umsebenzi MIN.

Umahluko kuphela phakathi kwemisebenzi emibini uyenzeka xa ingxabano inikezelwa kumsebenzi njengereferensi yeseli okanye uluhlu lweeseli.

Kule meko umsebenzi MIN ayihoyi amaxabiso anengqiqo kunye nokubhaliweyo ngelixa umsebenzi MINA ixabiso lengqiqo liyabala TRUE njengo-1, ixabiso elisengqiqweni FALSE njengo-0 kunye namaxabiso okubhaliweyo njengo-0.

Umsebenzi MINA I-Excel ibuyisela elona xabiso lincinci ukusuka kwiseti enikiweyo yamaxabiso amanani, ukubala okubhaliweyo kunye nexabiso elivakalayo FALSE njengexabiso lika-0 kunye nokubala ixabiso lengqiqo TRUE njengexabiso lika-1.

syntax

= MINA( number1, [number2], ... )

iingxoxo

• number1:  inani, iseli equlathe inani, okanye uluhlu lweeseli (okanye uluhlu lwamaxabiso amanani) eziqulathe amanani apho ufuna ukufumana elona nani lincinci.
• [number2]:  inani, iseli equlathe inani, okanye uluhlu lweeseli (okanye uluhlu lwamaxabiso amanani) eziqulathe amanani apho ufuna ukufumana elona nani lincinci.

Kwiinguqulelo zangoku ze-Excel (i-Excel 2007 nasemva koko), unganikezela ukuya kuthi ga kwi-255 yeengxoxo zamanani kumsebenzi MINA, kodwa kwi-Excel 2003 umsebenzi unokwamkela ukuya kuthi ga kwi-30 yeengxoxo zamanani.

Imizekelo

Umzekelo 1

Iseli B1 kwesi sipredishithi silandelayo sibonisa umsebenzi we-Excel MINA, osetyenziselwa ukubuyisela elona xabiso lincinci kwiseti yamaxabiso kwiiseli A1-A5.

Umzekelo 2

Iseli B1 yale spreadsheet ilandelayo ibonisa umsebenzi weExcel MINA, esetyenziselwa ukubuyisela elona xabiso lincinci kwiseti yamaxabiso kwiiseli A1-A3.

Gcina ukhumbule ukuba ixabiso TRUE esiseleni A1 yespreadsheet iphathwa njengexabiso lamanani 1 ngomsebenzi MINA. Ngoko ke, eli lelona xabiso lincinci kuluhlu A1-A3.

Imizekelo emininzi yomsebenzi we-Excel MINA zibonelelwa nge Iwebhusayithi yeMicrosoft Office .

Impazamo yokusebenza MINA

Ukuba ufumana impazamo kumsebenzi MINA ye-Excel, oku kunokwenzeka ukuba yimpazamo #VALORE!. Iyenzeka ukuba amaxabiso anikezelwe kumsebenzi we-MINA ayingomanani.

MINIFS

Umsebenzi we-Excel MINIFS ngumsebenzi wokukhangela obuyisela ixabiso eliphantsi ukusuka kwiseti yamaxabiso ekhankanyiweyo ngokusekelwe kwindlela enye okanye ngaphezulu.

syntax

= MINIFS( min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ... )

iingxoxo

• min_range:  Uluhlu lwamaxabiso amanani (okanye uluhlu lweeseli eziqulathe amaxabiso amanani), apho ufuna ukubuyisela elona xabiso liphezulu ukuba iinqobo zokugweba zihlangatyeziwe.
• criteria_range1:  uluhlu lwamaxabiso (okanye uluhlu lweeseli eziqulathe amaxabiso) ukuvavanya ngokuchaseneyo criteria1 .(Olu luhlu kufuneka lulingane nobude min_range ).
• criteria1: Imeko yokuvavanya ngokubhekiselele kumaxabiso kwi criteria_range1.
• [criteria_range2, criteria2], [criteria_range3, criteria3], ...: Uluhlu olongezelelweyo olukhethiweyo lwamaxabiso okuvavanya kunye neemeko ezifanelekileyo zokuvavanya.

Umsebenzi Minifs inokuphatha ukuya kuthi ga kwi-126 izihloko zezibini criteria_range e criteria.

Indlela nganye enikiweyo ingaba:

• ixabiso lamanani (elinokuba yinani elipheleleyo, idesimali, umhla, ixesha okanye ixabiso elisengqiqweni) (umz. 10, 01/01/2017, TRUE)

okanye

• umtya wokubhaliweyo (umz. “Igama”, “MercoleKwe")

okanye

• intetho (umzekelo “>1”, “<>0”).

Nei criteria enxulumene nokubhaliweyo ungasebenzisa wildcards:

• ? ukutshatisa nawuphi na umlinganiswa omnye
• * ukutshatisa naluphi na ulandelelwano lwabalinganiswa.

Ukuba i criteria ngumtya wokubhaliweyo okanye intetho, oku kufuneka kunikezelwe kumsebenzi Minifs kwiingcaphuno.

Umsebenzi Minifs Ayinabungozi. Ke ngoko, umzekelo, xa uthelekisa amaxabiso kwi criteria_range kunye nam criteria, imitya yokubhaliweyo "TEXT” kunye “nombhalo” ziya kugqalwa njengento enye.

Umsebenzi Minifs yaziswa okokuqala kwi-Excel 2019 kwaye ke ayifumaneki kwiinguqulelo zangaphambili ze-Excel.

Imizekelo

I-spreadsheet engezantsi ibonisa idatha yokuthengisa ngekota kubathengisi be-3.

Umsebenzi Minifs ingasetyenziselwa ukufumana inani elincinci lentengiso kuyo nayiphi na ikota, ummandla okanye ummeli wentengiso.

Oku kuboniswa kule mizekelo ilandelayo.

Umzekelo 1

Ukufumana elona nani lisezantsi lentengiso kwikota yokuqala:

=MINIFS( D2:D13, A2:A13, 1 )

enika isiphumo $ 125.000 .

Kulo mzekelo, i-Excel Minifs Ichonga iirowu apho ixabiso kumhlathi A lilingana no-1 kwaye ibuyisela elona xabiso liphantsi lisuka kumaxabiso ahambelanayo kumhlathi D.

Oko kukuthi, umsebenzi ufumana ubuncinci bamaxabiso $223.000, $125.000, kunye ne-$456.000 (ukusuka kwiiseli D2, D3, kunye neD4).

Umzekelo 2

Kwakhona, usebenzisa i-spreadsheet yedatha engentla, sinokusebenzisa umsebenzi Minifs ukufumana elona nani lincinci lentengiso lika "Jeff" ngexesha lekota yesi-3 neyesi-4:

=MINIFS( D2:D13, A2:A13, ">2", C2:C13, "Jeff" )

Le fomula ibuyisela isiphumo $261.000 .

Kulo mzekelo, i-Excel Minifs ichonga imigca apho:

• Ixabiso kumhlathi A likhulu kuno-2

E

• Ingeniso kukholomu C ilingana no-“Jeff”

kwaye ibuyisela ubuncinci bamaxabiso ahambelanayo kumhlathi D.

Oko kukuthi, le fomyula ifumana ubuncinci bexabiso le-$ 310.000 kunye ne-$ 261.000 (ukusuka kwiiseli D8 kunye ne-D11).

Ngeminye imizekelo yomsebenzi we-Excel Minifs, dibana ne Iwebhusayithi yeMicrosoft Office .

Impazamo yokusebenza MINIFS

Ukuba ufumana impazamo kumsebenzi we-Excel Minifs, isenokuba sesinye sezi zizathu zilandelayo:

• #VALORE! -Ijonga ukuba kukho uluhlu min_range e criteria_range ezinikiweyo azinabude obufanayo zonke.
• #NOME? -Kuyenzeka ukuba usebenzisa inguqulo endala ye-Excel (phambi kwe-2019), engawuxhasiyo uphawu Minifs.

LARGE

Umsebenzi we-Excel Large ngumsebenzi wokukhangela obuyisela i k'th ixabiso elikhulu ukusuka kuluhlu lwamaxabiso amanani.

syntax

= LARGE( array, k )

iingxoxo

• uluhlu-Uluhlu lwamaxabiso amanani ukukhangela elona xabiso likhulu.
• K – Isalathiso, o.k.t. umsebenzi ubuyisela ixabiso elikhulu kwi ktharray kubonelelwe.

Ingxoxo yoluhlu inokubonelelwa kumsebenzi ngokuthe ngqo okanye njengereferensi kuluhlu lweeseli eziqulathe amaxabiso amanani. Ukuba amaxabiso kuluhlu lweeseli ezinikiweyo ngamaxabiso okubhaliweyo, la maxabiso awahoywa.

umzekelo

I-spreadsheet elandelayo ibonisa umsebenzi we-Excel Large, esetyenziselwa ukubuyisela i-1st, 2nd, 3rd, 4th, kunye ne-5th amaxabiso amakhulu kwiseti yamaxabiso kwiiseli A1-A5.

Ezinye iingcamango kumzekelo we-spreadsheet ngasentla:

• Kwiseli B1, apho k imiselwe ku-1, umsebenzi Large yenza isenzo esifanayo ne Excel umsebenzi Max ;
• Kwiseli B5, xa k imiselwe ku 5 (inani lamaxabiso kuluhlu olunikiweyo), umsebenzi omkhulu wenza isenzo esifanayo Excel Min umsebenzi .

Iinkcukacha ezithe vetshe kunye nemizekelo ye-Excel Enkulu umsebenzi inokufumaneka kwi Iwebhusayithi yeMicrosoft Office .

Impazamo yokusebenza LARGE

Ukuba iExcel Large ibuyisela imposiso, inokuba yenye yezi zilandelayo:

• #NUM! -Iyenzeka ukuba:
  • Ixabiso elinikiweyo lika k lingaphantsi kwe-1 okanye likhulu kunenani lamaxabiso kuluhlu olunikiweyo
    okanye
    L 'array enikiweyo ayinanto.
• #VALUE! – Kwenzeka ukuba i-k enikiweyo ayilomanani.

Nangona kunjalo, iimpazamo zingenzeka ekubalweni komsebenzi OMKHULU nokuba ixabiso elinikiweyo lika k liphakathi kwe-1 kunye nenani lamaxabiso kuluhlu olunikiweyo. Isizathu esinokubakho kukuba amaxabiso okubhaliweyo, kubandakanywa nokumelwa okubhaliweyo kwamanani ngaphakathi koluhlu olunikiweyo, akahoywa ngumsebenzi omkhulu. Ke ngoko, lo mba unokwenzeka ukuba amaxabiso kuluhlu olunikiweyo luphawu lokubhaliweyo lwamanani kunokuba lube ngamaxabiso okwenene amanani.

Isisombululo sinokufezekiswa ngokuguqula onke amaxabiso oluhlu lube ngamaxabiso amanani. 

SMALL

Umsebenzi omncinci we-Excel ngumsebenzi wojongo obuyisela elona xabiso lincinci kwi-kth kuluhlu lwamaxabiso amanani.

syntax

= SMALL( array, k )

iingxoxo

• array -Uluhlu lwamanani amanani okukhangela elona xabiso likhulu.
• K – Isalathiso, o.k.t. umsebenzi ubuyisela ixabiso elikhulu kwi ktharray kubonelelwe.

Ingxoxo yoluhlu inokubonelelwa kumsebenzi ngokuthe ngqo okanye njengereferensi kuluhlu lweeseli eziqulathe amaxabiso amanani. Ukuba amaxabiso kuluhlu lweeseli ezinikiweyo ngamaxabiso okubhaliweyo, la maxabiso awahoywa.

umzekelo

I-spreadsheet elandelayo ibonisa umsebenzi we-Excel Small, esetyenziselwa ukubuyisela i-1st, 2nd, 3rd, 4th, kunye ne-5th awona maxabiso amancinci ukusuka kwiseti yamaxabiso kwiiseli A1-A5.

Kulo mzekelo kuyimfuneko ukuqwalasela ukuba::

• Kwiseli B1, apho k imiselwe ku-1, umsebenzi Small yenza isenzo esifanayo ne Excel Min umsebenzi ;
• Kwiseli B5, xa k imiselwe ku-5 (inani lamaxabiso kwiarray kunikezelwe), umsebenzi Small yenza isenzo esifanayo ne Excel's Max umsebenzi .

Iinkcukacha ezongezelelweyo kunye nemizekelo yomsebenzi we-Excel Small zibonelelwa nge Iwebhusayithi yeMicrosoft Office .

Impazamo yokusebenza SMALL

Ukuba iExcel SMALL ibuyisela imposiso, inokuba yenye yezi zilandelayo:

• #NUM! -Iyenzeka ukuba:
  • Ixabiso elinikiweyo lika k lingaphantsi kwe-1 okanye likhulu kunenani lamaxabiso kuluhlu olunikiweyo
    okanye
    Uluhlu olunikiweyo alunanto.
• #VALUE! – Kwenzeka ukuba i-k enikiweyo ayilomanani.

Nangona kunjalo, iimpazamo zingenzeka ekubaleni umsebenzi LARGE nokuba ixabiso elinikiweyo lika k liphakathi kwe 1 kunye nenani lamaxabiso kwiarray kubonelelwe. Isizathu esinokwenzeka kukuba amaxabiso okubhaliweyo, kubandakanywa nokumelwa okubhaliweyo kwamanani ngaphakathiarray zinikezelwe, azihoywa ngumsebenzi omkhulu. Ke, le ngxaki inokwenzeka ukuba amaxabiso kwiarray Okubonelelweyo kukuboniswa okubhaliweyo kwamanani kunamaxabiso okwenene amanani.

Isisombululo sinokufikelelwa ngokuguqula onke amaxabiso earray kumaxabiso amanani. 

Ufundo olunxulumeneyo

• Imisebenzi yezibalo ze-Excel: Isifundo esinemizekelo, inxalenye yokuqala
• Iitshathi ze-Excel, ukuba ziyintoni na, indlela yokuyila itshathi kunye nendlela yokukhetha eyona tshati ifanelekileyo
• Isicelo se-JSP, zonke iindlela zesicelo esifihlakeleyo sesicelo
• Ulawulo lweProjekthi kuqeqesho lwamava
• Iitafile zePivot: yintoni na, indlela yokwenza kwi-Excel kunye neGoogle. Isifundo esinemizekelo

Ercole Palmeri