AliExpress WW

Momwe mungachotsere masanjidwe patebulo mu Excel?

Microsoft Excel ndi ntchito yomwe imagwiritsidwa ntchito kwambiri mubizinesi ndi maphunziro kuwerengera, kusanthula ndi kuyimira mawonekedwe a data. Chimodzi mwazinthu zodziwika bwino za Excel ndikutha kupanga ndikuwongolera matebulo. M'nkhaniyi, tiwona kuti matebulo mu Excel ndi ati, ndi chiyani, ndi mitundu yosiyanasiyana ya matebulo omwe alipo.

Kodi matebulo mu Excel ndi chiyani?

Mu Excel, tebulo ndi gulu la deta lopangidwa m'mizere ndi mizati, pamene gawo lililonse limayimira gulu ndipo mzere uliwonse uli ndi zolembera kapena zolemba. Matebulo amathandizira kukonza ndi kusanthula deta mogwira mtima popereka mawonekedwe omveka bwino komanso osasinthika.

Matebulo mu Excel ndi osinthika kwambiri ndipo amapereka zinthu zambiri ndi zida zogwirira ntchito ndi deta bwino. Mwa kutembenuza deta kuti ikhale tebulo, mutha kupeza zina zowonjezera zomwe zimapangitsa kuti zikhale zosavuta kusefa, kusanja, ndi kusanthula zambiri.

Kodi matebulo mu Excel ndi ati?

Matebulo mu Excel ali ndi ntchito zingapo ndipo ndiwothandiza munthawi zosiyanasiyana. Zina mwazomwe zimagwiritsidwa ntchito kwambiri ndi matebulo ndi:

Bungwe ndi kasamalidwe ka data: Matebulo amakulolani kuti mukonzekere ma seti akulu akulu muzosavuta kuwerenga. Ndi zida zojambulira zokha za Excel, mutha kugwiritsa ntchito masitayelo ndi masanjidwe omwe afotokozedweratu pamatebulo kuti muwongolere mawonekedwe awo ndi kuwerengeka.

Kusanthula deta: Matebulo amapereka zida zamphamvu zosanthula deta. Zosefera zitha kugwiritsidwa ntchito kuti ziwonetse zolemba zomwe zimakwaniritsa zofunikira zina, zomwe zimapangitsa kuti zikhale zosavuta kuzindikira machitidwe ndi zomwe zikuchitika. Kuphatikiza apo, matebulo amatha kupanga ma graph okha ndi mafupipafupi kuti muwonetsetse bwino deta.

Kasamalidwe ka database: Matebulo mu Excel atha kugwiritsidwa ntchito kupanga ndikuwongolera nkhokwe zosavuta. Mizere yatsopano ikhoza kuwonjezeredwa kuti mulowetse deta, ndipo kufufuza ndi kusanja zimakupatsani mwayi wopeza ndi kukonza zambiri.

Mitundu ya matebulo mu Excel

Pali mitundu yosiyanasiyana ya matebulo mu Excel omwe amakwaniritsa zosowa zosiyanasiyana:

matebulo muyezo: Ndiwo matebulo oyambira mu Excel ndipo amatha kusinthidwa ndi masitayilo, mawonekedwe ndi mawonekedwe. Amapereka dongosolo lokhazikitsidwa pokonzekera ndi kusanthula deta.

Matebulo amphamvu: Matebulo a Pivot ndi zida zapamwamba zomwe zimakulolani kufotokoza mwachidule ndi kusanthula ma data akulu. Amapereka chiwongolero chachidule cha chidziwitso ndikulola kusanthula kwamitundu yosiyanasiyana poika m'magulu ndi kusefa deta.

Ma tebulo: Matebulowa amagwiritsidwa ntchito posanthula zochitika ndi zochitika. Amakulolani kuti mulowetse zinthu zosiyanasiyana m'maselo enieni ndikuwona momwe zimakhudzira zotsatira.

Matebulo mu Microsoft Excel ndi chida champhamvu chokonzekera, kusanthula, ndikuwonera deta. Kukhoza kwawo kuyendetsa bwino zidziwitso zazikulu, komanso kusinthasintha kwawo ndikusintha mwamakonda, zimawapangitsa kukhala chida chofunikira kwambiri kwa akatswiri ndi ophunzira omwe amagwira ntchito ndi data.

Momwe mungachotsere masanjidwe patebulo mu Microsoft Excel

Microsoft Excel ndi chida chosunthika komanso champhamvu pakuwongolera ndi kusanthula deta. Chimodzi mwazinthu zomwe zimagwiritsidwa ntchito kwambiri mu Excel ndikupanga matebulo, omwe amakulolani kuti mukonzekere ndikuwonera bwino deta.

Momwe mungachotsere masanjidwe patebulo mu Excel?

Komabe, nthawi zina pamafunika kuchotsa masanjidwe patebulo kuti mukonzenso detayo mwanjira yoyambira. M'nkhaniyi, tikuwonetsani momwe mungachotsere masanjidwe patebulo mu Microsoft Excel.

Chotsani masanjidwe patebulo

Kusasintha tebulo mu Excel ndi njira yachangu komanso yosavuta. Nazi njira zomwe mungatsatire:

Gawo 1: Sankhani tebulo

Chinthu choyamba chimene muyenera kuchita ndi kusankha tebulo limene mukufuna kuchotsa masanjidwe. Dinani pa selo iliyonse yomwe ili mkati mwa tebulo, kenako pitani ku tabu ya "Zida Zamakono" pazida za Excel. Tsambali limawoneka lokha mukasankha tebulo.

Gawo 2: Sinthani tebulo kukhala losiyanasiyana

Mukangosankha tabu ya "Zida Zamndandanda", muwona zosankha zingapo pamwamba pazenera. Dinani batani la "Convert to Range" mu gulu la "Table Tools". Kuchita izi kudzatsegula zokambirana ndikufunsa ngati mukufuna kusunga deta patebulo kapena kuichotsa.

Gawo 3: Sungani kapena kufufuta zomwe zili patebulo

Munkhani ya Convert Table to Range, mutha kusankha kusunga kapena kuchotsa zomwe zili patebulo. Ngati mwasankha "Sungani deta patebulo", Excel idzachotsa masanjidwe patebulo koma sungani deta ndi mafomu omwe mwasankha. Mukasankha "Chotsani deta patebulo", Excel imachotsa zonse zomwe zili patebulo, ndikusinthira zosankhidwa kukhala zoyambira.

Gawo 4: Tsimikizirani zomwe zikuchitika

Mukasankha njira yomwe mukufuna, dinani batani "Chabwino" kuti mutsimikizire zomwe zikuchitika. Excel idzasintha tebulo ndikugwiritsa ntchito mawonekedwe amtundu wa cell pamtundu womwe wasankhidwa. Ngati mwasankha njira ya "Keep Table Data", deta yanu ndi mafomu anu adzakhalabe mumndandanda popanda kupanga mapangidwe a tebulo.

Ubwino wochotsa masanjidwe patebulo

Kuchotsa masanjidwe patebulo kungakhale ndi maubwino angapo:

Kusintha kwakukulu: Pochotsa masanjidwe patebulo, mutha kugwira ntchito ndi data mosavuta ndikusintha masanjidwe a cell popanda zoletsa.

Kuphweka kwa deta: Posintha tebulo kukhala gawo loyambira, mutha kupangitsa kuti data ikhale yosavuta ndikuchotsa magwiridwe antchito patebulo, monga mizati yowerengeka kapena mizere yonse.

Kugwirizana ndi mapulogalamu ena: Pochotsa masanjidwe patebulo, mutha kutumiza deta ku mapulogalamu ena osafunikira kuti musinthe kukhala mawonekedwe oyambira.

Kusasintha tebulo mu Microsoft Excel ndi njira yosavuta komanso yothandiza mukafuna kugwira ntchito ndi deta yanu m'njira yoyambira komanso yosinthika.

Tommy Banks
Tidzasangalala kumva zomwe mukuganiza

siya yankho

TechnoBreak | Zopereka ndi Ndemanga
Logo