Kuti mukhale ogwira ntchito ndi deta yambirimbiri mu matebulo, iwo ayenera kulamulidwa nthawi zonse molingana ndi vuto linalake. Kuonjezerapo, pazinthu zenizeni, nthawizina deta yonse sizimafunike, koma mizere yokha. Kotero kuti, kuti musasokonezedwe ndi zambirimbiri zowonjezera, yankho labwino lingakhale kukhazikitsa deta ndi kusungira kuchokera ku zotsatira zina. Tiyeni tipeze momwe tingasankhire ndi kusunga deta mu Microsoft Excel.
Kusanthula deta mosavuta
Kusankha ndi chimodzi mwa zida zabwino kwambiri pamene mukugwira ntchito ku Microsoft Excel. Ndicho, mukhoza kukonza mizere ya tebulo muzithunzithunzi za alfabata, molingana ndi deta yomwe ili mu maselo a zipilala.
Deta ya Microsoft Excel ikhoza kuchitidwa pogwiritsa ntchito batani la "Sewani ndi Fyuluta," lomwe liri mu tabu la "Home" pa kavalo mu barabu yowonjezera "Kusintha". Koma choyamba, tifunika kujambula pa selo lirilonse muzomwe tidzakambirana.
Mwachitsanzo, mu tebulo ili m'munsiyi, antchito ayenera kusankhidwa mwachidule. Timakhala mu selo iliyonse ya "Dzina", ndipo dinani pa batani "Fufuzani ndi Fyuluta". Kuti muyambe mayina malemba, kuchokera mndandanda womwe ukuwonekera, sankhani chinthucho "Pangani A mpaka Z".
Monga mukuonera, deta yonse yomwe ili patebulo ilipo, molingana ndi mndandandanda wa mayina a alfabeti.
Kuti muyambe kusinthira, mu menyu yomweyo, sankhani Pangidwe lochokera ku Z mpaka A ".
Mndandandawu umangidwanso mmalo mwake.
Tiyenera kukumbukira kuti mtundu wamtundu uwu umangowonongeka pokhapokha ndi mauthenga a deta. Mwachitsanzo, pamene chiwerengero cha chiwerengero chafotokozedwa, mtundu wa "Kuchokera payeso kufika pazitali" (ndi mosiyana) umatchulidwa, ndipo pamene chiwonetsero cha tsiku chikufotokozedwa, "Kuyambira kalekale kupita kwatsopano" (ndi mosiyana).
Kusankha mwakhama
Koma, monga momwe tikuonera, ndi mitundu yosankhidwayo ndi mtengo womwewo, deta yomwe ili ndi mayina a munthu yemweyo imakonzedweratu mwadongosolo lokhazikika.
Ndipo tingachite chiyani ngati tikufuna kutchula mayina a alfabeti, koma mwachitsanzo, ngati dzina likugwirizana, pangani deta yokonzekera tsiku? Kuti muchite izi, komanso kugwiritsa ntchito zinthu zina, zonse zomwe zili m'ndandanda womwewo "Sankhani ndi fyuluta", tifunika kupita ku chinthucho "Kusankha mwambo ...".
Pambuyo pake, zenera zowonongeka zimatsegula. Ngati pali zolembera patebulo lanu, chonde onani kuti pawindo ili padzakhala chitsimikizo pafupi ndi "Deta yanga ili ndi mutu".
Kumunda "Column" imatchula dzina la chigawocho, chomwe chidzasankhidwa. Kwa ife, ili ndilo "Dzina". Kumunda "Kukonza" izo zikuwonetsedwa ndi mtundu wa zinthu zomwe zidzasankhidwe. Pali njira zinayi:
- Miyambo;
- Mtundu wa selo;
- Mtundu wa mtundu;
- Chithunzi cha selo
Koma, nthawi zambiri, chinthu cha "Values" chikugwiritsidwa ntchito. Imaikidwa mwachindunji. Kwa ife, tidzagwiritsanso ntchito chinthuchi.
M'ndandanda ya "Order" tiyenera kufotokozera momwe deta idzakhalire: "Kuchokera ku A mpaka Z" kapena mosiyana. Sankhani mtengo "Kuyambira A mpaka Z".
Kotero, ife timayambitsa kukonzekera ndi imodzi mwa zipilala. Kuti muthe kusankha mndandanda pamtundu wina, dinani pa batani "Onjezerani".
Zina mwazinthu zikuwonekera, zomwe ziyenera kudzazidwa kale kuti zisankhidwe ndi ndime ina. Kwa ife, ndi gawo la "Date". Popeza kuti tsikuli laikidwa mu maselowa, mu gawo la "Order" timayika osati "Kuchokera pa A mpaka Z", koma "Kuyambira kale mpaka latsopano", kapena "Kuchokera kwatsopano mpaka chakale."
Mofananamo, pawindo ili, mukhoza kukonza, ngati kuli kofunikira, ndikusankha ndizitsulo zina kuti mukhale patsogolo. Pamene zonsezi zikuchitika, dinani pa "Kulungama".
Monga mukuonera, tsopano patebulo lathu deta yonse yasankhidwa, choyamba, ndi dzina la wogwira ntchito, ndiyeno, ndi masiku a msonkho.
Koma, izi siziri zonse zomwe zimachitika mwambo wokonda. Ngati mukufuna, pawindo ili mungathe kukonza zosankhidwa ndizitsulo, koma ndi mizere. Kuti muchite izi, dinani pa batani "Parameters".
Muwindo lotseguka la magawo osankhidwa, suthani kasinthasintha kuchokera ku malo akuti "Mzere wamtundu" ku malo "Mizere yazitali". Dinani pa batani "OK".
Tsopano, mwa kufanana ndi chitsanzo chapitalo, mukhoza kulowa deta yosankha. Lowani deta, ndipo dinani pa batani "OK".
Monga mukuonera, zitatha izi, zipilala zimasinthidwa malingana ndi magawo olowawo.
Inde, pa tebulo lathu, kutengedwa monga chitsanzo, kugwiritsa ntchito kusinthanitsa ndi kusintha malo azitsulo sizothandiza kwenikweni, koma kwa matebulo ena mtundu wa mtundu uwu ukhoza kukhala woyenera.
Sakanizani
Kuwonjezera pamenepo, mu Microsoft Excel, pali fyuluta ya data. Amakulolani kuchoka kuwonetseratu deta yomwe mukuona kuti ikuyenera, ndi kubisala. Ngati ndi kotheka, deta yobisika ikhoza kubwezeretsedwa kuwonekera.
Kuti tigwiritse ntchito ntchitoyi, timakani pa selo lirilonse patebulo (ndipo makamaka pamutu), dinani pang'onopang'ono pa batani "Sewani ndi Fyuluta" mu barabu yothandizira. Koma, nthawi ino mu menyu omwe akuwonekera, sankhani chinthu "Fyuluta". Mwinanso mungathe kuchita izi pokhapokha muphatikize mgwirizano wambiri Ctrl + Shift + L.
Monga momwe mukuonera, mu maselo omwe ali ndi mayina onse, chithunzi chinkaoneka ngati mawonekedwe apakati, momwe chidutswa cha katatu chokwera.
Dinani pa chithunzi ichi mu gawoli momwe tidzasankhira. Kwa ife, ife tinaganiza kuti tizisungira ndi dzina. Mwachitsanzo, tifunika kusiya Nikolaev wogwira ntchitoyo basi. Choncho, timachotsa nkhuku kuchokera ku mayina a antchito ena onse.
Pamene ndondomeko yatsirizika, dinani pa batani "OK".
Monga tikuonera, patebulo panali mzere wokhala ndi dzina la wantchito wa Nikolaev.
Tiyeni tilimbikitse ntchitoyo, ndipo tisiyeni tebulo kokha data yomwe ikugwirizana ndi Nikolaev pa gawo lachitatu la 2016. Kuti muchite izi, dinani pa chithunzi mu selo "Tsiku". Mndandanda umene umatsegulira, chotsani chikwangwani kuchokera pa miyezi ya "May", "June" ndi "Oktoba", chifukwa sakugwirizana ndi gawo lachitatu, ndipo dinani "Bwino".
Monga mukuonera, pali deta yomwe tikusowa.
Kuti muchotse fyuluta pamtundu winawake, ndi kusonyeza deta zobisika, bwerezani kachiwiri pa chithunzi chomwe chili mu selo ndi dzina la ndimeyi. Mu menyu yomwe imatsegula, dinani pa chinthucho "Chotsani fyuluta kuchokera ...".
Ngati mukufuna kubwezeretsa fyuluta yonseyo malinga ndi tebulo, ndiye kuti muzitsulola batani "Sewani ndi Fyuluta" pa riboni, ndipo sankhani kusankha "Chotsani".
Ngati mukufuna kuchotsa zonsezo fyuluta, ndiye, monga pulogalamu yake, mu menyu yomweyo, sankhani chinthu "Fyuluta," kapena yesani kuphatikizana kwachinsinsi pa kibokosi Ctrl + Shift + L.
Kuwonjezera apo, tifunika kukumbukira kuti titatha kutsegula "Fyuluta" ntchito, mukasindikiza pazithunzi zofanana pamaselo a mutu wa tebulo, mumasamba omwe adawoneka, ntchito zowonetsera zilipo, zomwe tanena pamwambapa: "Yambani A mpaka Z" , "Pita ku Z mpaka A", ndi "Pangani mtundu".
Maphunziro: Momwe mungagwiritsire ntchito fyuluta yamoto ku Microsoft Excel
Mapepala abwino
Kusankha ndi kusuta kungathenso kutsegulidwa mwa kutembenuza dera limene mukugwira ntchito ndi "tebulo labwino".
Pali njira ziwiri zopangira tebulo lapamwamba. Kuti mugwiritse ntchito yoyamba ya iwo, sankhani mbali yonse ya tebulo, ndipo, pokhala pa tabu ya Pakhomo, dinani pa batani kuti Muyimire monga tepi ya tebulo. Bululi lili mu Styles toolbar.
Kenaka, sankhani imodzi mwa mafayilo omwe mumawakonda m'ndandanda yomwe imatsegulidwa. Kusankhidwa kwa tebulo sikungakhudze ntchito ya tebulo.
Pambuyo pake, bokosi la bokosi limatsegula momwe mungasinthire makonzedwe a gome. Koma, ngati munasankha deralo moyenera, ndiye kuti palibe chinthu china chimene chiyenera kuchitidwa. Chinthu chachikulu ndikuzindikira kuti pali chongerezi pafupi ndi "Table ndi mutu". Kenako, dinani pa batani "OK".
Ngati mwasankha kugwiritsa ntchito njira yachiwiri, ndiye kuti mufunikanso kusankha malo onse a tebulo, koma nthawi ino pitani ku "Insert" tab. Pamene pano, pa lembalo mu bokosi la masewero, "muyenera kujambula pa batani".
Pambuyo pake, monga nthawi yotsiriza, zenera zidzatsegulidwa kumene mungasinthe makonzedwe a patebulo. Dinani pa batani "OK".
Mosasamala kanthu njira yomwe mumagwiritsira ntchito popanga tebulo yabwino, mudzatha ndi tebulo, m'maselo a makapu omwe zithunzi zosayera zomwe tafotokozedwa poyamba zidzaikidwa.
Mukasindikiza pazithunzi izi, ntchito zonse zomwezi zidzakhalapo ngati mukuyamba fyuluta mu njira yowonjezera kudzera mu batani "Sewani ndi Fyuluta".
PHUNZIRO: Mmene mungapangire tebulo mu Microsoft Excel
Monga momwe mukuonera, zipangizo zogwiritsa ntchito ndi zosankha, zikagwiritsidwa ntchito bwino, zingathandize kwambiri ogwiritsa ntchito ndi matebulo. Chofunikira kwambiri ndi funso la ntchito yawo pochitika kuti tebulo liri ndi deta yaikulu kwambiri.
