Uluhlu lweeThebhile kunye neeMpawu kwi-Excel

Ngokubanzi, itafile ku-Excel yinkalo yemiqolo kunye neikholomu kwiphepha lokusebenzela elineenkcukacha ezihambelanayo. Kwiinguqulelo ngaphambi kwe-Excel 2007, itafile yalolu hlobo luchazwe njengoluhlu .

Ngokubhekiselele, itafile ibhloko yeeseli (imigqa kunye neentsika) eziqulethe iinkcukacha ezihambelaniswe njengetafile usebenzisa i-Excel's Table kwikhefu kwi- Insert ithebhu yerbhoni (ukhetho olufanayo lufumaneka kwiTebhu laseKhaya ).

Ukufometha ibhloko yedatha njengetafile kwenza kube lula ukwenza imisebenzi eyahlukileyo kwitafile yedatha ngaphandle kokuchaphazela enye idatha kwiphepha lokusebenzela. Le mi sebenzi iquka:

• ukuhlela idatha;
• u kucoca idatha ;
• Ukubala okukhawulezayo - faka enye ifom esebenzisa ngokuzenzekelayo kuyo yonke iseli kule kholomu;
• ukongeza i totali zekholomu kumgca wokugqibela etafileni;
• ukufomatha idatha yetafile njengebhloko ehlukileyo, ngoko ke uyibeke kwenye idilesi kwiphepha lokusebenzela.

Ngaphambi kokufaka iThebhile

Nangona kunokwenzeka ukwenza itafile engenanto, kudla kulula ukufaka idatha kuqala phambi kokufomathiza njengetafile.

Xa ufaka idatha, musa ukushiya imigca, iikholomu, okanye iiseli ezingenanto, kwiibhloko zedatha eziya kubeka itafile.

Ukwakha itafile :

1. Cofa nayiphi na iseli enye ngaphakathi kwibhloko yedatha;
2. Cofa kwi- Insert ithebhu yebhebhoni;
3. Cofa kwi icon yeTable (ekhoyo kwiqela leeTables ) - i-Excel iya kukhetha yonke ibhloko yedatha edibeneyo kwaye ivule ibhokisi yencoko yebhokisi yebhokisi ;
4. Ukuba idatha yakho inomqolo ophezulu, khangela 'Itafile yam eneenkloko' kwibhokisi yencoko;
5. Cofa u-OK ukudala itafile.

Izixhobo zeThebula

Iimpawu eziphawulekayo i-Excel zongeza kwibhloko yedatha yile:

• yehla imenyu equkethe uhlobo, icebo, kunye neenketho zokukhangela kwikholam nganye kwitafile
• ukufomatha ibhloko yedatha kunye nemigca e-shaded enye - ukutshintsha i-shading isebenzise indlela yeTable Styles ekhoyo kwiTebhu yokufaka;
• Isibambo sokusila esisezantsi ekhoneni letafile ukwenza kube lula ukongeza okanye ukususa iirekhodi ezivela etafileni;
• I- Quick Analysis icon (eyongeziweyo kwi-Excel 2013) ibonakala kwikona elisezantsi lasekuneni leseli esebenzayo xa iiseli ezimbini okanye ngaphezulu etafileni zikhethiweyo. Kwenza kube lula ukuhlalutya idatha ngokusebenzisa:
  • iitshathi;
  • iithayibhile;
  • izibalo zokusebenza - zivela emva komgca wokugqibela weedatha yedatha;
  • fomati enemiqathango.

Ulawulo lweData yeDatha

Ukukhethwa kunye nokuCoca

Amamenyu ehlayo ehlukileyo / ehluzayo edibaniswe kumgca weentloko yenza kube lula ukuhlela amatafula:

• ekwenzeni umyalelo;
• ekuhlaleni;
• ngumgca okanye umbala wendawo yangasese;
• usebenzisa i-order sort sort.

Inketho yohlulo kumamenyu kukuvumela ukuba

• bonisa kuphela idatha ehambelana nemigaqo echaziweyo, okanye unako
• ukucoca ngomgca okanye umbala wangasese weseli;
• Ukukhangela iirekodi ezithile ngokuhambelana nemida nganye yedata .

Ukongeza kunye nokususwa kweeNdawo kunye neeRekhodi

Isibambo sokusila kwenza kube lula ukongeza okanye ukususa yonke imigca (iirekhodi) okanye iikholomu (imimandla) yedatha etafile. Ukwenza njalo:

1. Cofa uze ubambe isalathisi se mouse kwi-handle handle;
2. Hudula umgca wokubamba phezulu okanye phantsi okanye ngakwesobunxele okanye ngakwesokudla ukuguqula itafile.

Idata esuswe kwitafile ayinakususwa kwiphepha lokusebenzela, kodwa ayisayi kufakwa kwimisebenzi yeetafile ezifana nokuhlunga kunye nokucoca.

Iikholamu ezibalwa

Ikholamu ebhaliweyo ikuvumela ukuba ufake ifomula enye kwiseli enye kwikholam kwaye usebenzise le fomu ngokuzenzekelayo kuzo zonke iiseli kwikholam. Ukuba awufuni ukubala ukubandakanya zonke iiseli, cima ifomu kulezo iiseli. Ukuba ufuna kuphela ifomula kwiseli yokuqala, sebenzisa isici sokurhoxisa ukususa ngokukhawuleza kuzo zonke ezinye iiseli.

Row Total

Inani leerekhodi etafileni linokuqalwa ngokufaka iRhafu epheleleyo kwizantsi kwetafile. Umqolo opheleleyo usebenzisa umsebenzi we-SUBTOTAL ukubala inani lamarekhodi.

Ukongezelela, ezinye izibalo ze-Excel - njengeSum, uMyinge, uMax, kunye neMin - unokongezwa ngokusebenzisa imenyu ehlayo yezinketho. Ezi zibalo ezongezelelweyo nazo zenza umsebenzi we-SUBTOTAL.

Ukongeza iRow Total :

1. Cofa naluphi na kwitafile;
2. Cofa kwiThebhu yoyilo yerbhoni;
3. Cofa kwi- Row Total ukukhangela ibhokisi ukuyikhetha (ekhoyo kwiqela leSetyathisi yeTayibhile );

Umqolo opheleleyo uvela njengomgca wokugqibela etafileni kwaye ubonisa igama elipheleleyo kwi-cell ekhohlo kunye nenani elipheleleyo lamarekhodi kwisona esisezantsi kunjengokuboniswa kumfanekiso ongentla.

Ukongeza ezinye izibalo kwi- Row Total :

1. Kwinqanaba elipheleleyo, nqakraza kwiseli apho kubalwa kuza kubakho inani - i-arrow ehlayo iyavela;
2. Cofa umgca oluhlu lokuhlalisa ukuvula imenyu yezinketho;
3. Cofa kwi-calculation oyifunayo kwimenyu ukuyifaka iseli;

Qaphela: Amafomula angenakongezwa kumgca wemiqolo ayigcinelwanga kubalo kwimenyu. I-Formula ingongezwa ngesandla nakweyiphi iseli kwimiqolo epheleleyo.

Cima iThebhile, Kodwa Gcina iDatha

1. Cofa naluphi na kwitafile;
2. Cofa kwiThebhu yoyilo yerbhoni
3. Cofa ukuguqula ukuya kwiBanga (eliseQela lamaThuluzi ) - livula ibhokisi lokuqinisekisa ukususa itafile;
4. Cofa u- Yebo ukuqinisekisa.

Iifayile zeetafile - ezifana ne-drop down menus kunye ne-handle ye-sizing - zisuswe, kodwa idatha, u-shading kunye kunye nezinye izinto ezifomathiweyo zigcinwa.