Tsatanetsatane wabulo ndi zizindikiro mu Excel

Kawirikawiri, tebulo mu Excel ndi mndandanda wa mizera ndi mazenera mu kapepala komwe kali ndi deta. M'masinthidwe asanayambe Excel 2007, tebulo la mtundu uwu linatchulidwa ngati Mndandanda.

Zowonjezera, tebulo ndilo gawo la maselo (mizere ndi zipilala) zomwe zili ndi deta zokhudzana ndi tebulo pogwiritsira ntchito Table Excel pa Insert tab ya riboni (njira yomweyi ili pamtanda).

Kupanga ma deta monga tebulo kumapangitsa kuti zikhale zosavuta kugwira ntchito zosiyanasiyana pa tebulo deta popanda kuwonongera deta zina pa tsamba. Ntchito izi zikuphatikizapo:

• kusanthula deta;
• kufufuza deta ;
• Kuwerengera kofulumira - lowetsani njira imodzi yomwe imagwiritsidwa ntchito pamaselo aliwonse mulololo;
• kuwonjezera zigawo za pamzere mpaka mzere womaliza mu tebulo;
• kupanga mapepala a deta ngati chinthu chosiyana, motero kuchichotsa kuzinthu zina mu tsamba la ntchito.

Asanayambe Kuyika Masamba

Ngakhale kuti n'zotheka kupanga tebulo lopanda kanthu, kawirikawiri zimakhala zosavuta kuti mulowetse deta yoyamba musanaikidwe monga tebulo.

Mukalowetsa deta, musasiye mzere, mizere, kapena maselo osalongosoka mu deta yomwe idzapange tebulo.

Kupanga tebulo :

1. Dinani selo limodzi lirilonse mkati mwa deta ya deta;
2. Dinani ku Insert tab ya riboni;
3. Dinani pa chithunzi Chakujambula (chomwe chili mkati mwa magulu a matebulo ) - Excel idzasankha zonse zowonongetsa deta ndikutsegula Bukhu lakulumikiza Zamkatimu ;
4. Ngati deta yanu ili ndi mzere wotsatira, fufuzani 'Gome langa liri ndi mutu' mubox;
5. Dinani OK kuti mupange tebulo.

Zithunzi Zamaphunziro

Zinthu zochititsa chidwi kwambiri zomwe Excel akuwonjezera pa chiwerengero cha deta ndi:

• lekani menyu omwe ali ndi mtundu, fyuluta, ndi zosankha zosaka pa ndime iliyonse mu tebulo
• kupanga ma deta ndi mizere ina ya shaded - kusintha kusintha kumagwiritsa ntchito Table Styles zomwe zili pa Insert tab;
• chogwirira chaching'ono chomwe chiri pansi pa dzanja lamanja la gome kuti chikhale chosavuta kuwonjezera kapena kuchotsa zolembedwa kuchokera pa tebulo;
• Chithunzi Chofulumira Kufufuza (kuwonjezeka mu Excel 2013) chikuwoneka pansi pa dzanja lamanja la selo yogwira ntchito pamene maselo awiri kapena angapo pa tebulo amasankhidwa. Zimakhala zosavuta kusanthula deta pogwiritsa ntchito:
  • zolemba;
  • matebulo ofunika;
  • miyendo yothamanga - ayang'ane pambuyo pa mndandanda wa deta;
  • maonekedwe ovomerezeka.

Kusamalira Deta Data

Kusankha ndi Kusankha Zosankha

Mitundu yotsitsa / mafayilo otsika omwe akuphatikizidwa ku mzere wa mutu amachititsa kuti zovuta zikhale zosavuta:

• mu kukwera dongosolo;
• potsika;
• ndi maonekedwe kapena maonekedwe a mzere;
• kugwiritsa ntchito dongosolo la mtundu wamtundu.

Njira yoponda fyuluta mu menyu ikulolani kutero

• Onetsani zokhazokha zomwe zikugwirizana ndi ndondomekoyi, kapena mungathe
• Fyuluta ndi mazenera kapena mtundu wa mzere wa selo;
• fufuzani zolemba zomwe mwasakaniza magawo ena a deta .

Kuwonjezera ndi Kutulutsa Minda ndi Zolemba

Mgwirizano wowonjezera umapangitsa kuti kukhale kosavuta kuwonjezera kapena kuchotsa mizere yonse (ma rekodi) kapena zigawo (minda) ya deta kuchokera pa tebulo. Kuchita izi:

1. Dinani ndikugwiritsira ntchito pointer ya mouse pamasamba oyesera;
2. Kokani chogwirira chakumwamba mmwamba kapena pansi kapena kumanzere kapena kumanja kuti mukhazikitse tebulo.

Deta yomwe imachotsedwa pa tebulo sizimachotsedwa pa tsamba, koma sichiphatikizidwanso m'magwiridwe a tebulo monga kupatula ndi kusuta.

Mazenera Owerengedwa

Mzere wowerengedwa umakulowetsani kuti mupange ndondomeko imodzi m'maselo amodzi mu khola ndipo mukhale ndi ndondomeko yomwe imagwiritsidwira ntchito pamaselo onse a m'mbali. Ngati simukufuna kuwerengera kuphatikizapo maselo onse, chotsani mawonekedwe a maselowa. Ngati mukufuna kokha mawonekedwe mu selo yoyamba, gwiritsani ntchito ndondomeko yowonongeka kuti muichotse mwamsanga ku maselo ena onse.

Total Row

Chiwerengero cha zolembedwa patebulo chikhoza kufika powonjezera Total Row pansi pa tebulo. Mzere wathunthu umagwiritsa ntchito NTCHITO YOTSATIRA kuti muwerenge chiwerengero cha ma rekodi.

Kuwonjezera apo, mawerengedwe ena a Excel - monga Sum, Average, Max, ndi Min - akhoza kuwonjezeka pogwiritsa ntchito menyu pansi. Zowonjezera izi zimagwiritsanso ntchito ntchito SUBTOTAL.

Kuwonjezera Total Row :

1. Dinani kulikonse mu tebulo;
2. Dinani pa tabu Yopanga ya riboni;
3. Dinani pa Total Row chekeni botani kuti muzisankhe (zili mu Table Style Options gulu);

Mzere wathunthu umakhala ngati mzere womaliza pa tebulo ndikuwonetsera mawu Onse mu selo lakumanzere ndi chiwerengero cha ma rekodi mu selo yoyenera monga momwe asonyezedwera mu chithunzi pamwambapa.

Kuwonjezera mawerengedwe ena ku Total Row :

1. Mu mzere wathunthu, dinani pa selo kumene mawerengedwe akuwonekera - chiwonetsero chotsitsa chikuwonekera;
2. Dinani mndandanda wa ndondomeko yotsika pansi kuti mutsegule mndandanda wa zosankha;
3. Dinani pa mawerengedwe ofunidwa mu menyu kuti muwonjezere selo;

Zindikirani: Ma formula omwe angathe kuwonjezeredwa pa mzere wathunthu sali owerengeka kuwerengera. Fomu ikhoza kuwonjezedwa pamanja pa selo iliyonse mumzere wathunthu.

Chotsani tebulo, koma Sungani Deta

1. Dinani kulikonse mu tebulo;
2. Dinani pa tabu Yopanga ya kasoni
3. Dinani kusinthana kuti muyambe (yomwe ili mu Gulu la Zida ) - imatsegula bokosi lovomerezera kuchotsa tebulo;
4. Dinani Inde kuti mutsimikizire.

Dongosolo lapafa - monga manyowa otsika ndi kugwiritsira ntchito sizing - achotsedwa, koma deta, mthunzi wa mzere, ndi zinthu zina zomangidwe zimasungidwa.