Ithebula incazelo kanye nezici ku-Excel

Ngokuvamile, itafula ku-Excel liwuhlu lwemizila namakholomu kushidi lokusebenza eliqukethe idatha ehlobene. Ezinguqulo ngaphambi kwe-Excel 2007, itafula lolu hlobo luthiwa Uhlu.

Ngokuqondile, itafula liyi-block yamaseli (imigqa namakholomu) aqukethe idatha ehlobene efomathiwe njengetafula usebenzisa i-Excel's Table yokukhethwa kukho ithebhu yokufaka yebhande (okufanayo okukhona kuthebhu lasekhaya ).

Ukufometha ibhlogo yedatha njengetafula kwenza kube lula ukwenza imisebenzi ehlukahlukene kwedatha yetafula ngaphandle kokuthinta enye idatha ekhasini lokusebenzela. Le misebenzi ihlanganisa:

• ukuhlunga idatha;
• ukuhlunga idatha ;
• Ukubala okusheshayo - faka ifomula elilodwa elisetshenziselwa ngokuzenzakalela kuwo wonke amaselula kuleyo kholomu;
• ungeze izamba zekholomu kumugqa wokugcina etafuleni;
• ukufometha idatha yetafula njengebhokisi elihlukile, ngaleyo ndlela libeke eceleni kwezinye idatha kuphepha lokusebenzela.

Ngaphambi kokufaka ithebula

Nakuba kungenzeka ukudala itafula elingenalutho, ngokuvamile kulula ukufaka idatha kuqala ngaphambi kokuyifometha njengetafula.

Uma ufaka idatha, ungashiyi imigqa, amakholomu, noma amaseli angenalutho ebhodini lwedatha elizokwenza ithebula.

Ukwakha itafula :

1. Chofoza noma iyiphi iseli elilodwa ngaphakathi kwe-data yedatha;
2. Chofoza ku- Faka ithebhu ye-ribbon;
3. Chofoza kwisithonjana seThebula (esitholakala eqenjini lamathebula ) - I-Excel izokhetha yonke ibhulogi yedatha edibeneyo futhi ivule ibhokisi lengxoxo yeDesign Table ;
4. Uma idatha yakho inomugqa wokukhomba, hlola 'Itafula lami linamakhanda' ebhokisini lengxoxo;
5. Chofoza OK ukudala ithebula.

Izici zeThebula

Izici eziphawulekayo ezivezwa yi-Excel ebhodini yedatha yilezi:

• wehlisa amamenyu aqukethe uhlobo, ukuhlunga, kanye nezinketho zokusesha kukholomu ngayinye etafuleni
• ukufometha i-block yedatha ngemigqa eminye evuliwe - ukuguqula ukuthungatha ukusebenzisa inketho yeTable Styles etholakala kuthebhu Faka ;
• isibambo se-sizing esisekhoneni elingezansi kwesokudla setafula okwenza kube lula ukwengeza noma ukususa amarekhodi avela etafuleni;
• Isithonjana se- Quick Analysis (esingeziwe ku-Excel 2013) sivela engxenyeni engezansi kwesokunxele yeseli esebenzayo lapho amaseli amabili noma ngaphezulu etafuleni akhethiwe. Kwenza kube lula ukuhlaziya idatha usebenzisa:
  • amashadi;
  • amathebula we-pivot;
  • izibalo zokugijima - zivela ngemuva komugqa wokugcina wedatha yedatha;
  • ukufometha okunemibandela.

Ukuphatha idatha yethebula

Ukuhlunga nokuhlunga Izinketho

Amamenyu wehla okuhlunga / okuhlunga ukuhlunga okungeziwe emgqeni wekhanda yenza kube lula ukuhlela amatafula:

• ekukhuphukeni;
• ngokuhlehlisa;
• ngombala noma umbala wangemuva weseli;
• usebenzisa i-order sort sort.

Okukhethwa kukho okuhlunga emamenyu kukuvumela ukuba

• bonisa kuphela idatha ehlangabezana nemigomo ecacisiwe, noma ungakwazi
• ukuhlunga ngefonti noma umbala wangemuva weseli;
• cinga amarekhodi athile ngokufanisa izinkambu ezithile zedatha .

Ukwengeza nokususa amasimu namarekhodi

Isibambo se-sizing senza kube lula ukufaka noma ukususa yonke imigqa (amarekhodi) noma amakholomu (amasimu) wedatha esuka etafuleni. Ukwenza kanjalo:

1. Chofoza bese ubamba isikhombisi segundane kwisiphathi sokulinganisa;
2. Hudula isibambo sokususa phezulu noma phansi noma ngakwesokunxele noma kwesokudla ukushintsha usayizi wetafula.

Idatha esusiwe etafuleni ayisusiwe ekhasini lokusebenzela, kodwa ayisekho ekusebenzeni kwethebula njengokuhlunga nokuhlunga.

Amakholomu abalwa

Ikholomu elibaliwe likuvumela ukuba ufake ifomula elilodwa esitokisini esisodwa kukholomu bese uthola leyo fomula isetshenziswe ngokuzenzakalelayo kuwo wonke amaseli akukholomu. Uma ungafuni ukubalwa kufaka wonke amaseli, susa ifomula kulawo maseli. Uma ufuna kuphela ifomula esitokisini sokuqala, sebenzisa isici sokuhlehlisa ukususa masinyane kuwo wonke amanye amaseli.

Inani eliphelele

Inombolo yamarekhodi etafuleni ingahlanganiswa ngokungeza iRonke Row phansi kwetafula. Umugqa ophelele usebenzisa umsebenzi we-SUBTOTAL ukubala inani lamarekhodi.

Ngaphezu kwalokho, ezinye izibalo ze-Excel - njenge-Sum, Isilinganiso, i-Max, ne-Min - zinganezelwa besebenzisa imenyu yehla yezinketho. Lezi zibalo ezengeziwe zenza umsebenzi we-SUBTOTAL.

Ukwengeza iNamba Yonke :

1. Chofoza noma kuphi etafuleni;
2. Chofoza kuthebhu Yokwakha yedibhoni;
3. Chofoza ku- Total Row ukuhlola ibhokisi ukuyikhetha (etholakala eqenjini lezinketho zesitayela seThebula );

Umugqa ophelele uvela njengomugqa wokugcina etafuleni futhi ubonisa igama eliphelele kulelo seli elingakwesokunxele kanye nenani eliphelele lamarekhodi esitokisini esiphambili njengoba kuboniswe esithombeni ngenhla.

Ukwengeza ezinye izibalo ku- Total Row :

1. Emgqeni ophelele, chofoza esitokisini lapho ukubalwa kuzobonakala khona - umcibisholo wokudonsa ubonakala;
2. Chofoza umcibisholo wohlu lokudonsa ukuze uvule imenyu yezinketho;
3. Chofoza ekubalweni okufunayo kumenyu ukuze uyengeze iseli;

Qaphela: Amafomula angangeniswa kumugqa ophelele awunqunyelwe kubalo kwimenyu. Iformula ingafakwa ngesandla ngesandla kunoma isiphi iseli kumugqa ophelele.

Susa iThebula, Kodwa Londoloza Idatha

1. Chofoza noma kuphi etafuleni;
2. Chofoza kuthebhu Yokwakha yedibhoni
3. Chofoza ukuguqulwa kuya ku-Range (etholakala eqenjini lamaThuluzi ) - uvula ibhokisi lokuqinisekisa lokususa ithebula;
4. Chofoza Yebo ukuze uqinisekise.

Izici zethebula - ezifana namamenyu wehla kanye nesibambo sokususa - zisusiwe, kodwa idatha, ukukhishwa komugqa, nezinye izici zokufomatha zigcinwa.