Indlela yokubala iiTotals kwi-Excel

Izishwankathelo zisisixhobo esibalulekileyo kuhlalutyo lwedatha, nokuba ukwenza izibalo ezilula okanye ezinzima. Kwimeko ye-Excel, le spreadsheet ethandwayo inikezela ngemisebenzi eyahlukeneyo kunye neefomula ezivumela ukuba senze iimali ngokukhawuleza nangokufanelekileyo. Kweli nqaku, siza kuphonononga indlela yokwenza izibalo kwi-Excel, sichaza Inyathelo nenyathelo iinketho ezahlukeneyo kunye nobuchule obukhoyo. Ukusuka kongezwe olusisiseko ukuya kongezelelo olunemiqathango kunye nokusetyenziswa kwemisebenzi ephucukileyo, siya kufumanisa indlela yokufumana okuninzi kulo msebenzi unamandla wezibalo kwi-Excel. Ukuba ujonge ukwandisa ulwazi lwakho ekulawuleni i-spreadsheets kunye nokuphucula uhlalutyo lwamanani, eli nqaku liza kukunika lonke ulwazi oluyimfuneko ukwenza izongezo ngokufanelekileyo kwi-Excel.

1. Intshayelelo kwezongezo kwi-Excel: ingqiqo kunye nokusetyenziswa

Ushwankathelo kwi-Excel sisixhobo esiluncedo kakhulu sokwenza izibalo ezikhawulezayo nezisebenzayo kwiispredishithi. Kule nqaku, siza kuhlolisisa ingcamango kunye nokusetyenziswa kwe-summarys kwi-Excel, ukubonelela ngesinyathelo-ngesinyathelo isikhokelo malunga nendlela yokuyisebenzisa kwiimeko ezahlukeneyo.

Isixa kwi-Excel sikuvumela ukuba wongeze ngokukhawuleza uluhlu lweeseli ekhethiweyo, ngaphandle kokwenza umsebenzi wokudibanisa ngamnye ngesandla. Oku kuluncedo ngakumbi xa usebenza ngeeseti zedatha yamanani amakhulu.

Ukusebenzisa izibalo kwi-Excel, khetha ngokulula uluhlu lweeseli ofuna ukwenza isibambiso phezu kwazo kwaye usebenzise umsebenzi we-SUM kwibha yefomula. Ungasebenzisa kwakhona i-AutoSum ukhetho, olubekwe kwithebhu yaseKhaya, ukongeza ngokuzenzekelayo umsebenzi we-SUM ekupheleni koluhlu olukhethiweyo okanye umqolo. Ngezi ndlela, uya kukwazi ukwenza izibalo ngokukhawuleza nangokuchanekileyo kwi-Excel. Ukongeza, ungasebenzisa iifomyula zemathematika kunye nabaqhubi ukwenza izibalo ezinzima ngakumbi.

2. Imisebenzi esisiseko yokwenza izongezo kwi-Excel

Ziyizixhobo eziluncedo kakhulu ezisivumela ukuba sibale ngokukhawuleza nangokuchanekileyo isamba sesethi yamaxabiso. Le misebenzi yenza lula umsebenzi xa usenza izibalo ezintsonkothileyo zemathematika, ukuphepha imfuneko yokwenza le misebenzi ngesandla.

Kukho imisebenzi eyahlukeneyo enokusetyenziselwa ukwenza izongezo kwi-Excel, ezinye zezona ziqhelekileyo ziquka i-SUM, i-SUMIF, kunye ne-SUMIF. Umsebenzi we-SUM usetyenziselwa ukongeza amaxabiso okanye uluhlu lweeseli. Kwelinye icala, imisebenzi ye-SUMIF kunye ne-SUMIF SET isetyenziselwa ukongeza amaxabiso ngokusekwe kwiikhrayitheriya ezithile ezichaziweyo.

Ukusebenzisa le misebenzi, kufuneka wazi indlela yokuyibhala kunye nendlela yokufaka iingxoxo ezichanekileyo. Kubalulekile ukuqaphela ukuba iingxoxo zohlulwe ngeekoma kwaye ezinye zazo ziyafuneka. Nje ukuba sikhethe iseli apho sifuna isiphumo sesixa sethu sivele, siyakusebenzisa umsebenzi ohambelanayo kwaye sichaze uluhlu okanye indlela esifuna ukuyongeza.

3. Imizekelo yokongezwa kusetyenziswa umsebenzi we-SUM kwi-Excel

Umsebenzi we-SUM kwi-Excel sisixhobo esinamandla esikuvumela ukubala isixa soluhlu lwamaxabiso kwiseli. okanye uluhlu lweeseli. Ngezantsi zithathu.

Umzekelo 1: Ukushwankathela amaxabiso kumhlathi othile, khetha iseli ofuna isiphumo sivele kuyo. Okulandelayo, ngenisa ifomula "=SUM(uluhlu)" endaweni "uluhlu" kunye noluhlu lweeseli ofuna ukuzidibanisa. Umzekelo, ukuba unamaxabiso kwiiseli A1 ukuya ku-A10, ifomula iya kuba “=SUM(A1:A10)”. Ekugqibeleni, cofa u-Enter kwaye uya kufumana isiphumo semali.

Umzekelo 2: Kuyenzeka ukongeza uluhlu oluninzi lweeseli kwinto enye ifomula usebenzisa umsebenzi we-SUM. Yahlula ngokulula uluhlu ngalunye ngesiphumlisi. Umzekelo, ukuba ufuna ukongeza amaxabiso kwiiseli A1:A10 kunye ne-B1:B10, ifomula iyakuba "=SUM(A1:A10, B1:B10)." Oku kuya kukunika isixa sisonke semigangatho yomibini.

Umzekelo 3: Ukuba ufuna ukushwankathela amaxabiso kumqolo endaweni yomqolo, sebenzisa ngokulula umsebenzi we-SUM ngendlela efanayo naleyo yemizekelo yangaphambili, kodwa khetha uluhlu lweeseli oluthe tye endaweni yokuthe nkqo. Umzekelo, ukuba ufuna ukongeza amaxabiso kwiiseli A1 ukuya E1, ifomula iya kuba “=SUM(A1:E1)”. Oku kuya kubala isixa samaxabiso kumqolo ochaziweyo.

4. Uyisebenzisa njani ikhrayitheriya yokukhetha kwizibalo kwi-Excel

Ukusebenzisa imilinganiselo yokukhetha kwizibalo kwi-Excel, sinokusebenzisa umsebenzi we-SUMIF okanye umsebenzi we-SUMIF SET. Le misebenzi ivumela ukuba senze izongezo ezinemiqathango, oko kukuthi, ukongeza kuphela ezo xabiso ezihlangabezana nemilinganiselo ethile. Nantsi indlela yokusebenzisa zombini iindlela:

1. Ukusebenzisa umsebenzi we-SUMIF, kufuneka siqale sikhethe iseli apho sifuna isiphumo se-conditional sum ivele. Emva koko, kufuneka singenise ifomula "=SUMIF(criterion_range, criterion, sum_range)" kwibha yefomula, apho:

• criterion_uluhlu luluhlu lweeseli apho amaxabiso anokuvavanywa afunyanwa khona.
• ikhrayitheriya Lixabiso okanye imeko ekufuneka idibane nedatha ukuze yongezwe.
• sum_uluhlu luluhlu lweeseli eziqulathe amaxabiso aya kongezwa ukuba ziyahlangabezana nemigaqo emiselweyo.

2. Ukuba sifuna ukusebenzisa umsebenzi we-SUMIF SET, inkqubo iyafana. Okokuqala, sikhetha iseli apho sifuna isiphumo semali emiselweyo sivele kwaye emva koko sifake ifomula “=SUMIF.SET(criterion_range1, criterion1, criterion_range2, criterion2, sum_range)” kwibha yefomula. Umahluko kuphela kukuba sinokusebenzisa uluhlu lweekhrayitheriya ezininzi kunye neendlela.

5. Iimali ezinemiqathango kwi-Excel: usebenzisa umsebenzi we-SUMIF

Umsebenzi we-SUMIF kwi-Excel uluncedo kakhulu xa ufuna ukwenza izongezo ezinemiqathango kwiphepha yokubala. Lo msebenzi ikuvumela ukuba wongeze amaxabiso oluhlu oludibana nemeko ethile. Ngokusebenzisa umsebenzi we-SUMIF, unokufumana iziphumo ezichanekileyo nezikhawulezayo xa usenza izibalo kwi-Excel.

Ukusebenzisa umsebenzi we-SUMIF kwi-Excel, kufuneka uqale ukhethe uluhlu lwedatha ofuna ukwenza isixa esinemiqathango. Umqathango kufuneka ucaciswe kusetyenziswa abaqhubi abanjengomkhulu kune, ngaphantsi, okanye ulingana, kunye nenqobo okanye ixabiso elithile lingabandakanywa. Ukongeza, umsebenzi we-SUMIF ungasetyenziswa kunye neemeko ezingaphezu kwesinye usebenzisa abaqhubi abanengqondo njenge-AND okanye OKANYE.

Umzekelo wesicelo somsebenzi we-SUMIF ukwi-spreadsheet equlethe uluhlu lweemveliso zentengiso. Masithi ufuna ukufumana isixa esipheleleyo seentengiso yemveliso ethile. Ukusebenzisa umsebenzi we-SUMIF, unokukhetha uluhlu lwamaxabiso okuthengisa kwaye uchaze imeko yokuba igama lemveliso lilingana nemveliso oyifunayo. Emva kokufaka umsebenzi, isixa esinemiqathango yokuthengiswa kwemveliso ekhethiweyo iya kufunyanwa.

6. I-summarys ephezulu kwi-Excel: Imisebenzi ye-SUMPRODUCT kunye ne-SUMIF SET

Kwi-Excel, ukushwankathelwa okuphambili sisixhobo esiluncedo kakhulu sokwenza izibalo ezinzima. Imisebenzi emibini yeyona nto isetyenziswayo yi-SUMPRODUCT kunye ne-SUMIFSET. Le misebenzi ivumela ubalo olusekwe kwiikhrayitheriya kunye nophindaphindo loluhlu lweeseli.

Umsebenzi we-SUMPRODUCT ikuvumela ukuba wande uluhlu lweeseli kwaye wongeze iziphumo. Ukusebenzisa lo msebenzi, le fomati ilandelayo kufuneka ilandelwe: =SUMPRODUCT(uluhlu1, uluhlu2, ...). Uluhlu ngalunye kufuneka lube nenani elifanayo lerowu kunye nemiqolo. Kubalulekile ukuqaphela ukuba lo msebenzi uza kuphinda-phinda amaxabiso ahambelana nendawo efanayo kuluhlu ngalunye.

Kwelinye icala, umsebenzi we-SUMIF SET ikuvumela ukuba wongeze amaxabiso oluhlu oluhlangabezana neendlela ezininzi. Ifomati yalo msebenzi yile ilandelayo: =SUMIFSET(sum_range, criteria_range1, criteria1, criteria_range2, criteria2, ...). Kuyenzeka ukongeza uluhlu oluninzi kunye nemilinganiselo yemigangatho njengoko kufuneka. Kubalulekile ukuqaphela ukuba iikhrayitheriya zingamabinzana, amanani okanye isicatshulwa ekufuneka sifakwe kwiingcaphuno.

7. Ubalwa njani uqukuqelo loluhlu oluhluziweyo kwi-Excel

Ukubala amanani oluhlu oluhluziweyo kwi-Excel kunokuba ngumsebenzi oluncedo xa ufuna ukufumana iziphumo ezithile kwiseti yedatha. Ngethamsanqa, i-Excel ibonelela ngomsebenzi obizwa ngokuba yi-“SUBTOTALS” eyenza olu balo lube lula. Apha siza kukubonisa amanyathelo okubala izixa zoluhlu oluhluziweyo kwi-Excel.

Okokuqala, kufuneka ukhethe Uluhlu okanye uluhlu lwedatha ofuna ukwenza ubalo kuyo. Okulandelayo, yiya kwithebhu ethi "Idatha" kwibha yemenyu ye-Excel kwaye ucofe u-"Hlunga." Oku kuya kukuvumela ukuba ucofe idatha ngokusekelwe kwiikhrayitheriya zakho ezithile. Nje ukuba usebenzise izihluzi ezifunekayo, kuphela idatha ehlangabezana nezo migaqo iya kuboniswa.

Okulandelayo, ukubala isixa sedatha ehluziweyo, yiya kwiseli apho ufuna ukuba isiphumo sivele kwaye usebenzise "SUBTOTAL" umsebenzi. Lo msebenzi uneempikiswano ezimbini: impikiswano yokuqala linani lomsebenzi ofuna ukuwenza (umzekelo, 9 ukudibanisa), kwaye impikiswano yesibini luluhlu lweeseli ofuna ukufaka kuzo umsebenzi. Umzekelo, ukuba ufuna ukushwankathela amaxabiso ahluziweyo kumhlathi A, ingxoxo iyakuba "=SUBTOTALS(9,A:A)". Oku kuya kubala udibaniso lwedatha ehluziweyo kwaye ibonise umphumo kwiseli ekhankanyiweyo.

8. Ukusebenzisa iifomyula ze-matrix ukwenza izongezo ezinzima kwi-Excel

Enye yezona zinto zinamandla kwi-Excel kukukwazi ukwenza izongezo ezinzima usebenzisa iifomyula zoluhlu. Ezi fomula zisivumela ukuba senze izibalo eziphezulu kunye neeseti zedatha kwifomula enye, ukugcina ixesha kunye nokunciphisa iimpazamo. Apha ngezantsi sisikhokelo senyathelo nenyathelo lendlela yokusebenzisa ezi fomula kwi-Excel.

Ngaphambi kokusebenzisa iifomyula zematrix, kubalulekile ukuvula i-"Matrix Formulas" ukhetho kwi-Excel. Ukwenza oku, yiya ku "Ifayile"> "Okukhethwa kukho"> "Iifomula" kwaye ukhangele ibhokisi ye "Matrix Formulas". Oku kuya kuvumela i-Excel ukuba yenze izibalo ngokufanelekileyo.

Nje ukuba uluhlu lweefomyula ukhetho luvuliwe, sinokuqalisa ukusebenzisa ezi fomula ukwenza izongezo ezinzima kwi-Excel. Umzekelo, masithi sinoluhlu lweentengiso zenyanga zeemveliso ezahlukeneyo kwi-spreadsheet kwaye sifuna ukubala isixa esipheleleyo seentengiso kwiinyanga ezi-3 zokugqibela. Singasebenzisa ifomula yematrix =SUMA(SI(A2:A100=»Producto1″, B2:B100)) ukufumana umphumo oyifunayo. Le fomula yongeza kuphela amaxabiso entengiso ahambelana ne "Product1".

9. Ushwankathelo kwi-Excel pivot tables: ukongeza kunye nokushwankathela idatha

Ukongeza kunye nokushwankathela idatha kwiitafile ze-pivot ze-Excel, ungasebenzisa umsebenzi wokuhlanganisa. Isixa sikuvumela ukuba ufumane isixa esipheleleyo samaxabiso kuluhlu oluthile okanye umqolo kwitafile yakho yepivot. Oku kuluncedo ngakumbi xa ufuna ukwenza izibalo ngokukhawuleza kwaye ufumane iziphumo ezidityanisiweyo.

Ukongeza isixa kwitheyibhile yepivot, landela la manyathelo:

• Khetha iseli apho ufuna isibalo sivele khona.
• Yiya kwi "PivotTable Tools" ithebhu kwi-Excel menu bar.
• Cofa "Yongeza iNdawo" kwaye ukhethe ikholamu okanye umqolo ofuna ukuwongeza.
• Qinisekisa ukuba umsebenzi wodibaniso usetelwe ku-"Sum."

Nje ukuba wongeze isamba, i-Excel iya kubala ngokuzenzekelayo isixa samaxabiso ahambelanayo kuluhlu olukhethiweyo okanye umqolo. Ukuba ufuna ukushwankathela idatha ngendlela eneenkcukacha ezininzi, ungasebenzisa ukhetho lokucoca kunye nokwahlulahlula kwitafile yakho yepivot. Oku kuya kukuvumela ukuba ulawule ngakumbi indlela idatha eboniswa ngayo kwaye ishwankathelwe kuhlalutyo lwakho.

10. Uwongeza njani amaxabiso akhethekileyo kwi-Excel usebenzisa umsebenzi we-SUMIF SET

Kwi-Excel, umsebenzi we-SUMIF SET sisixhobo esiluncedo kakhulu sokongeza amaxabiso awohlukileyo kumhlathi.. Lo msebenzi usivumela ukuba songeze amaxabiso omqolo ukuba iimeko ezithile zihlangatyeziwe. Ukusebenzisa lo msebenzi kubaluleke kakhulu xa sisebenza ngeeseti zedatha enkulu kwaye sifuna ukufumana iimali ezithile ngokusekelwe kwiikhrayitheriya ezithile.

Ukusebenzisa i-SUMIF SET umsebenzi, kufuneka siqale sicacise uluhlu lwamaxabiso okuvavanya kunye nomqathango okanye umlinganiselo ekufuneka kuhlangatyezwane nawo. Okulandelayo, sikhetha uluhlu lwamaxabiso oluya kongezwa ukuba imeko ifezekisiwe. Kubalulekile ukukhumbula ukuba umsebenzi uya kushwankathela amaxabiso awodwa kuluhlu lwedatha.

Umzekelo, masithi sinekholamu enamagama emveliso kunye nenye ikholamu enobungakanani obuthengisiweyo bemveliso nganye. Ukuba sifuna ukudibanisa ubuninzi obuthengisiweyo bemveliso ethile, sinokusebenzisa umsebenzi we-SUMIF SET. Ukwenza oku, sicacisa uluhlu lwamagama emveliso njengomlinganiselo kunye noluhlu lwezixa ezithengiswa njengoluhlu lweemali. Ngale ndlela, siya kufumana isixa semali ethengisiweyo yemveliso ekhethiweyo.

11. Ukusebenzisa isixhobo seSolver ukwenza izongezo ngokuxhomekeke kwimithintelo kwi-Excel

Isixhobo seSolver kwi-Excel ngumsebenzi okuvumela ukuba wenze izongezo ngokuxhomekeke kwizithintelo, eziluncedo ngakumbi ukusombulula iingxaki ulungiselelo. ISolver isebenzisa iialgorithms zemathematika ukufumana esona sisombululo sisiso kwingxaki, kuthathelwa ingqalelo imiqobo esekiweyo.

Ukusebenzisa iSolver, kufuneka ube noguqulelo lwe-Excel olubandakanyayo (ngokuqhelekileyo iinguqulelo zobungcali okanye zeshishini). Nje ukuba sifikelele kwiSolver, kufuneka silandele la manyathelo alandelayo:

• Khetha iseli ekujoliswe kuyo esifuna ukuyikhulisa.
• Chaza iiseli eziguquguqukayo eziza kuxhomekeka kwizithintelo kwaye eziya kuchaphazela umphumo weseli ekujoliswe kuyo.
• Ukuseka imiqobo, zombini imiqobo yolingano kunye nemiqobo yokungalingani.

Nje ukuba ingxaki iqwalaselwe, sinokubaleka iSolver ukufumana isisombululo. I-Excel iya kufumana amaxabiso afanelekileyo kwiiseli eziguquguqukayo, ithathela ingqalelo imiqobo echaziweyo, kwaye ibonise iziphumo kwiseli ekujoliswe kuyo. Ukongeza, iSolver inokuvelisa ingxelo eneenkcukacha ngolwazi malunga nesisombululo esifunyenweyo.

12. Uyongeza njani iiseli ezingadibaniyo kwi-Excel

Ukongeza iiseli ezingahambelaniyo kwi-Excel, kukho iindlela ezahlukeneyo ongazisebenzisa ngokuxhomekeke kwiimfuno zakho kunye nohlobo lwedatha oyibambayo. Ngezantsi, sibonisa amanyathelo kunye nemizekelo eya kukunceda ukusombulula le ngxaki:

1. ":"" indlela yomsebenzisi (ikholoni): Indlela elula yokwenza isixa seeseli ezingadibaniyo kukusebenzisa icolon operator. Umzekelo, ukuba ufuna ukongeza iiseli B1, C1, F1, kunye ne-G1, chwetheza ngokulula le fomula ilandelayo kwiseli engenanto: =SUM(B1:C1, F1:G1). Le fomula iyakongeza imixholo yeeseli ezine ngokuzenzekelayo.

• Ingcebiso: Sebenzisa "," (ikoma) umsebenzisi ukwahlula iindidi ezahlukeneyo zeeseli.
• Umzekelo: =SUMA(A1:A5, C1:D5, F1:G5)

2. Indlela yokusebenzisa i-SUMIF SET umsebenzi: Enye indlela kukusebenzisa umsebenzi we-SUMIF SET, okuvumela ukuba wongeze iseti yeeseli ezingadibaniyo ezihlangabezana nemilinganiselo ethile. Umzekelo, ukuba ufuna ukongeza zonke iiseli ezikuluhlu A ezinkulu kuno-10 nangaphantsi kwama-20, ungasebenzisa le fomula ilandelayo: =SUMIFSET(A1:A10, «>10», A1:A10, « <20 ") Le fomula iya kushwankathela zonke iiseli ezihlangabezana nale miqathango.

• Ingcebiso: Ungasebenzisa abaqhubi bothelekiso abahlukeneyo, abanje nge «>» (ngaphezulu kune), «<" (ngaphantsi kune), ">=» (mkhulu kuno okanye ulingana no), «<=" (ngaphantsi okanye ulingana no), phakathi abanye.
• Umzekelo: =SUMIFSET(A1:A10, «>=50», B1:B10, «<=100")

3. Indlela yokusebenzisa umsebenzi we-SUMPRODUCT: Umsebenzi we-SUMPRODUCT nawo uluncedo ekongezeni iiseli ezingabonakaliyo kwi-Excel. Lo msebenzi ikuvumela ukuba wenze imisebenzi yemathematika phakathi koluhlu olwahlukeneyo lweeseli uze wongeze iziphumo. Umzekelo, ukuba ufuna ukongeza iiseli B1, C1, F1 kunye ne-G1 ziphindaphindwe ngo-2, ungasebenzisa le fomula ilandelayo: =SUMPRODUCT((B1:C1, F1:G1)*2). Le fomula iyakuphinda-phinda iiseli ngo-2 kwaye emva koko yongeze iziphumo.

• Ingcebiso: Unokusebenzisa imisebenzi yezibalo eyahlukeneyo, enjengophinda-phindo (*), ulwahlulo (/), ukudibanisa (+), ukuthabatha (-), phakathi kwezinye.
• Umzekelo: =SUMARPRODUCTO((A1:A5*2) + (B1:B5/2))

13. Yonga ixesha: Ukuzigqibezela ngokuzenzekelayo izibalo kwi-Excel ngee-shortcuts ze-keyboard

Kwabo bajonge ukonga ixesha lokwenza izongezo kwi-Excel, ukugqibezela ngokuzenzekela ngeendlela ezimfutshane zekhibhodi yinto eluncedo kakhulu. Endaweni yokuba uchwetheze ngesandla iseli nganye okanye usebenzise umsebenzi we-SUM, ungasebenzisa iindlela ezimfutshane zebhodi yezitshixo ukugqiba ngokukhawuleza isibalo kumhlathi okanye kumqolo.

Inyathelo lokuqala kukukhetha iseli apho ufuna isiphumo sesambuku sivele. Emva koko, cofa iqhosha elithi "Alt" kwaye, ngelixa uyibambe, cinezela uphawu olulinganayo (=) ukuze uvule ukugqibezela okuzenzekelayo. Okulandelayo, bhala ifomula yokudibanisa, umzekelo, «=SUM(«.

Ngoku, khetha uluhlu lweeseli ofuna ukuzongeza kwaye ucinezele iqhosha elithi "Enter" ukufumana isiphumo semali. Ukuba ufuna ukukopa ifomyula kwezinye iiseli, khetha ngokulula iseli enesiphumo, cofa u-"Ctrl+C" amaqhosha ukuze uyikope uze ukhethe iiseli zendawo ekuyiwa kuyo kwaye ucinezele izitshixo zika-"Ctrl+V" ukuncamathisela ifomula. Ngale ndlela, unokugcina ixesha xa usenza izongezo kwi-Excel usebenzisa iindlela ezimfutshane zebhodibhodi.

14. Iingcebiso kunye namaqhinga okuphucula ukusebenza xa usenza izibalo kwi-Excel

Ukuphucula ukusebenza xa usenza izongezo kwi-Excel, kukho uluhlu lwe iingcebiso namaqhinga oko kunokuba luncedo kakhulu. Ezinye zazo ziya kuchazwa ngezantsi:

1. Sebenzisa iifomula ezifanelekileyo: Kubalulekile ukusebenzisa iifomyula ezifanelekileyo ukwenza izibalo. Umzekelo, endaweni yokusebenzisa ifomula ye-SUM, kungcono ukusebenzisa imisebenzi ethile efana ne-SUMIF okanye i-SUMIFSET, eya kunciphisa ixesha lokubala.

2. Kulumkele ukubala ngokungeyomfuneko: Ukuba unedatha engafanelekanga kwisamba, kuyacetyiswa ukuba ugweme ukuyifaka kwiiseli ezongezwayo. Oku Inokufezekiswa usebenzisa izihluzi okanye iimeko zokukhuphela ngaphandle idatha exeliweyo kwaye ngaloo ndlela kukhawuleziswe inkqubo yokubala.

3. Sebenzisa uluhlu oluchaziweyo: Xa usebenza ngeeseti ezinkulu zedatha, kunokuba luncedo ukwabela amagama kuluhlu oluya kongezwa. Oku kuya kuququzelela kakhulu umsebenzi wokwenza izongezo, kuba unokubhekisa kuluhlu olubiziweyo endaweni yokuba ukhethe ngesandla iiseli ofuna ukuzongeza.

Isishwankathelo, ii-Excelles ze-Excel zisisixhobo esibalulekileyo kwabo basebenza ngemithamo emikhulu yedatha kwaye bafuna ukufumana iziphumo ezikhawulezayo nezichanekileyo. Ngeefomula ezilula kunye nemisebenzi ethile, efana ne-SUM kunye ne-SUMIF, kunokwenzeka ukwenza imisebenzi yemathematika enzima ngaphandle kweengxaki.

Nangona kunjalo, kubalulekile ukuthathela ingqalelo eminye imiba ephambili ukuphepha iimpazamo ekubaleni kwethu. Ukhetho oluchanekileyo lwezintlu, ukusetyenziswa ngokufanelekileyo kweenqobo zokugweba kwimisebenzi yesixa esinemiqathango kunye nokuqinisekiswa rhoqo kweziphumo zizenzo ezibalulekileyo.

I-Excel isinika iindlela ezininzi onokukhetha kuzo kunye nezixhobo ezisivumela ukuba senze ngcono iinkqubo zethu zokudibanisa kunye nokwenza lula imisebenzi yethu yohlalutyo lwedatha. Ukususela ekusebenziseni iitafile ze-pivot ukuya kwi-automation yemisebenzi usebenzisa i-macros, iqonga limi njengeqabane elinamandla kulabo bafuna ukusebenza kakuhle kunye nokuchaneka.

Ekugqibeleni, kunye nokudibanisa okufanelekileyo kolwazi lobugcisa kunye nokuziqhelanisa rhoqo, siya kukwazi ukwenza uninzi lwee-summarys kwi-Excel kwaye sibe nesixhobo esinamandla sokubala kunye nokuhlalutya ezandleni zethu.

Ungalibazisi ukuqhubeka uziqhelanisa kwaye ufunde malunga neempawu eziphambili ze-Excel ukuthatha izakhono zakho uzise kwinqanaba elilandelayo! Ushwankathelo oluyingcweti kunye nokukhanya ngohlalutyo lwakho lwedatha.