Indlela Yokufumana Iimilinganiselo Eyona Mkhulu Kakhulu kwi-Excel Database okanye uLuhlu

01 ngo 04

I-Excel SUBTOTAL Inkcazo Yenkcazelo

Fumana Iimilinganiselo ezikhulu kakhulu nge-Excel 2007 ye-Subtotal Feature

I-Excel's Subtotal feature isebenza ngokufaka umsebenzi we-SUBTOTAL kwisiseko sedata okanye uluhlu lweenkcukacha ezihambelanayo. Ukusebenzisa i-Subtotal feature yenza ukufumana nokukhipha ulwazi oluthile kwitafile enkulu yedatha ngokukhawuleza kwaye kulula.

Nangona ibizwa ngokuba "i-Subtotal feature", awukhawulelwanga ekufumaneni isisombululo okanye isixa semigca ekhethiweyo yedatha. Ukongeza kwi-totali, unokufumana ixabiso elincinci kwisigatshana ngasinye seenkcukacha.

Olu qeqesho linyathelo ngeyathelo luquka umzekelo wendlela yokufumana ixabiso elipheleleyo lezentengiso kwingingqi nganye yokuthengisa.

Amanyathelo kule khosi:

1. Faka idatha yeTutorial
2. Ukuhlelwa kweSample Example
3. Ukufumana Ixabiso Elikhulu

02 we 04

Faka iData yeTutorial Data

Qaphela: Ukuze uncedo ngale miyalelo ubone umfanekiso ongentla.

Isinyathelo sokuqala sokusebenzisa i-Subtotal feature kwi-Excel kukufaka idatha kwiphepha lokusebenzela .

Xa wenza njalo, gcina iingongoma ezilandelayo engqondweni:

• Kubalulekile ukungena idatha ngokuchanekileyo. Iimpazamo, ezibangelwa ukungena kwedatha engafanelekanga, ziyimvelaphi yeengxaki ezininzi ezinxulumene nokuphathwa kwedatha.
  
• Shiya akukho miqolo okanye iikholam ezingenanto xa ufaka idatha. Oku kubandakanya ukushiya umgca ongagqibekanga phakathi kwezihloko zekholomu kunye nomqolo wokuqala wedatha.

Kule Tutorial

Faka idatha kwiiseli A1 ukuya kwi-D12 njengoko kuboniswa kumfanekiso ongentla. Kulabo abangacingi ukuthayipha, idatha, imiyalelo yokuyikopisha kwi-Excel, iyafumaneka kulekhonkco.

03 we 04

Ukuhlela iDatha

Qaphela: Ukuze uncedo ngale miyalelo ubone umfanekiso ongentla. Cofa kumfanekiso ukuze ukwandise.

Ngaphambi kokuba iifowuni zingasetyenziselwa, idatha yakho kufuneka iqokelelwe ngekholomu yedatha ofuna ukukhipha ulwazi ukusuka kuyo.

Olu qela lwenziwa ngokusebenzisa i-Excel's Sort feature .

Kule tutorial, sifuna ukufumana inani elona liphezulu lamagosa ngommandla wokuthengisa ukwenzela ukuba idatha imele ihlelwe yi-column column heading.

Ukuhlenga iDatha ngoMmandla weNtengiso

1. Hudula ukhetha iiseli A2 ukuya kwi-D12 ukuze uzigqwezele. Qiniseka ukuba ungabandakanyi isihloko kwisigcawu esisodwa ekukhetheni kwakho.
   
2. Cofa kwiTebhu yedata yebhanethi .
   
3. Cofa kwiQhosha lokuHlaba eliphakathi kwidatha yedatha ukuvula ibhokisi yencoko yencoko .
   
4. Khetha Uhlobo ngeNqila ukusuka kuluhlu olungezantsi phantsi kweKholam ehamba kwibhokisi yencoko.
   
5. Qinisekisa ukuba idatha yam inehloko ihlolwe kwikhoneni eliphezulu lebhokisi yencoko.
   
6. Chofoza OK.
   
7. Idata kwiiseli ze-A3 ukuya kwi-D12 kufuneka ihlaziywe ngokwe-alfabhethi yimihlathi yesibini. Idatha yeempahla ezintathu zokuthengisa ezivela kummandla waseMpuma kufuneka zifakwe kuqala, zilandelwe nguMntla, ngokoMzantsi, kwaye zigcine indawo yaseNtshona.

04 we 04

Ukufumanisa ixabiso elona likhulu kakhulu usebenzisa ii-Subtotals

Qaphela: Ukuze uncedo ngale miyalelo ubone umfanekiso ongentla.

Kule nyathelo, siya kusebenzisa i-Subtotal feature ukuze sifumane inani eliphezulu lokuthengisa ngommandla ngamnye. Ukufumana ixabiso eliphakamileyo okanye elona likhulu, i-Subtotal feature isebenzisa umsebenzi we-MAX.

Kule khokelo:

1. Hudula ukhethe idatha kwiiseli ze-A2 ukuya kwi-D12 ukuze zigqityise.
   
2. Cofa kwiTebhu yedata yebhanethi.
   
3. Cofa kwiqhosha lase-Subtotal ukuvula ibhokisi yencoko yababini.
   
4. Kukhetho lokuqala kwibhokisi yencoko Kwiphetshana nganye kwi: Khetha iNgingqi ukusuka kuluhlu lokuhla.
   
5. Okwenketho lwesibini kwibhokisi yencoko Sebenzisa umsebenzi: khetha i- MAX ukusuka kuluhlu lokuhla.
   
6. Okwenketho lwesithathu kwibhokisi yencoko Yongeza ii-subtotals uku: khangela ubungakanani bentengiso kuphela kwiluhlu lwezinto ezikhethiweyo ezisefestile.
   
7. Kwiibhokisi ezintathu zokukhangela phantsi kwebhokisi yencoko yababini, khangela:
   
   Shintsha indawo ekhoyo yangoku
   Isishwankathelo esingezantsi kwedatha
   
8. Chofoza OK.
   
9. Itheyibhile yedata ngoku kufuneka ibandakanye inani elipheleleyo lezentengiso kwingingqi nganye (imiqolo 6, 9, 12, kunye ne-16) kwakunye ne- Grand Max (ixabiso elipheleleyo lezentengiso kuzo zonke iindawo) kumqolo 17. Kufanele ufanane nomfanekiso phezulu kule tutorial.