Nthawi zambiri cholinga chachikulu chogwira ntchito pa chikalata cha Excel ndi chosindikizira chake. Koma, mwatsoka, si wogwiritsa aliyense amadziwa momwe angakwaniritsire njirayi, makamaka ngati mukufuna kusindikiza buku la bukuli, koma masamba ena okha. Tiyeni tiwone momwe mungagwiritsire ntchito chikalatacho mu pulogalamu ya Excel.
Wonenaninso: Kusindikiza Zolemba M'mawu a MS
Kutulutsa kwa chikalatacho kwa chosindikizira
Musanafike posindikiza chikalata chilichonse, onetsetsani kuti chosindikizira chikulumikizidwa bwino pakompyuta yanu komanso kusinthidwa kofunikira kumachitika mu Windows Kugwiritsa ntchito mawindo. Kuphatikiza apo, dzina la chipangizo chomwe mukufuna kusindikiza iyenera kuwonetsedwa kudzera pa mawonekedwe a Exel. Kuti muwonetsetse kuti kulumikizana ndi zosintha zili zolondola, pitani ku tabu ya fayilo. Kenako, pitani gawo "" kusindikiza ". Mu gawo lalikulu lazenera lomwe limatseguka mu chosindikizira, dzina la chipangizocho chomwe mukufuna kusindikiza zikalata chikuwonetsedwa.
Koma ngakhale chipangizocho chikuwonetsedwa bwino, sichimagwirizana. Izi zikutanthauza kuti zimapangidwa bwino mu pulogalamuyi. Chifukwa chake, musanasindikize, onetsetsani kuti chosindikizira chimathandizidwa pa intaneti ndipo imalumikizidwa ndi kompyuta ndi chingwe kapena zingwe zopanda zingwe.
Njira 1: kusindikiza chikalata chonse
Pambuyo polumikizidwa ndikuyang'aniridwa, mutha kuyamba kusindikiza zomwe zili mufayilo ya Excel. Njira yosavuta yosindikiza chikalatacho kwathunthu. Kuchokera pamenepa, tidzayamba.
- Pitani ku "fayilo" tabu.
- Kenako, timasamukira ku "chosindikizira" podina chinthu choyenera patsamba lakumanzere kwa zenera lotseguka.
- Zenera losindikiza limayamba. Kenako, pitani kusankhidwa kwa chipangizocho. Gawo la "Printer" liyenera kuwonetsa dzina la chipangizocho chomwe mukufuna kusindikiza. Ngati dzina la chosindikizira china chikuwonetsedwa pamenepo, muyenera dinani pa icho ndikusankha njira yomwe ikukhutiritsani kuchokera pamndandanda wotsika.
- Pambuyo pake, timasamukira ku malo osinthira pansipa. Popeza tifunika kusindikiza zomwe zili mufayilo, dinani pa gawo loyamba ndikusankha buku la "kusindikiza buku lonse" pamndandanda.
- M'munda wotsatira, mutha kusankha mtundu wa kusindikiza:
- Chisindikizo chimodzi;
- Mbali ziwiri ndi couning ndi mtunda wautali;
- Mbali ziwiri zokhala ndi componse pamphepete.
Ndikofunikira kale kusankha malinga ndi zolinga zina, koma kusasunthika ndiye njira yoyamba.
- M'munsi yotsatira, ndikofunikira kusankha, kusokoneza zinthu zomwe zidasindikizidwazo kapena ayi. Poyamba, ngati musindikiza makope angapo omwewo, nthawi yomweyo chidindo chidzafika ma sheet onse kuti: Kopekani, ndiye yachiwiri, etc. Mlandu wachiwiri, wosindikiza amasindikiza zigawo zonse za pepala loyamba la makope onse nthawi imodzi, ndiye yachiwiri, etc. Nyanjayi ndiyofunika kwambiri ngati wosuta amasindikiza zolemba zambiri, ndipo zimachepetsa kusintha kwa zinthu zake. Ngati mungasindikize buku limodzi, mafayilo awa ndi osafunikira kwenikweni kwa wogwiritsa ntchito.
- Malo ofunikira kwambiri ndi "mawonekedwe". Gawo ili limatsimikizika kuti kusindikizidwa: mu buku kapena pamalopo. Poyamba, kutalika kwa pepalali ndi lalikulu kuposa m'lifupi mwake. Ndi mawonekedwe a mawonekedwe, m'lifupi mwake m'lifupi kuposa kutalika.
- Gawo lotsatirali likufotokozera kukula kwa pepala losindikizidwa. Kusankha chotsimikizika ichi, choyambirira, kumadalira kukula kwa pepalali komanso pathanzi la chosindikizira. Nthawi zambiri, mtundu wa A4 umagwiritsidwa ntchito. Imakhazikitsidwa muzosintha. Koma nthawi zina muyenera kugwiritsa ntchito miyeso ina yomwe ilipo.
- M'munda wotsatira, mutha kukhazikitsa kukula kwake. Mwachidule, "minda yachilendo" imagwiranso ntchito. Nthawi yomweyo ya makonda, kukula kwa minda yapamwamba ndi yotsika ndi 1.91 masentimita, kumanja ndikumanzere - 1.78 cm. Kuphatikiza apo, ndizotheka kukhazikitsa mitundu yotsatirayi:
- Chachikulu;
- Chopapatiza;
- Mtengo Wotsiriza Wotsiriza.
Komanso, kukula kwa mundawo kumatha kukhazikitsa izi tikambirana pansipa.
- M'munda wotsatira, kukula kwa tsamba kumakonzedwa. Pali zosankha zotere posankha gawo ili:
- Zamakono (zosindikiza za ma sheet ndi kukula kwenikweni) - mwachisawawa;
- Lowetsani pepala patsamba limodzi;
- Lowetsani mizati yonse patsamba limodzi;
- Samalira mizere yonse patsamba lililonse.
- Kuphatikiza apo, ngati mukufuna kukhazikitsa sikeloyo pamanja pofotokoza mtengo wake, ndipo, osagwiritsa ntchito makonda ake pamwambapa, mutha kudutsa "makonda a kakumbukidwe kambiri" komwe mungakhale ".
Monga njira ina, mutha kudina pa tsamba la zilembo zolembedwa "zomwe zili kumapeto kwa mndandandandawo minda.
- Ndi chilichonse mwa zomwe zili pamwambapa, pitani kuzenera, lotchedwa "masamba". Ngati zosintha pamwambapa zinali zotheka kusankha pakati pa zosankha zokhazikitsidwa ndi makonda, ndiye kuti wogwiritsa ntchito pano ali ndi kuthekera kokhazikitsa chiwonetsero cha chikalatacho, monga momwe chimafunira.
Mu tsamba loyamba la zenera ili, lomwe limatchedwa "Tsamba"
- M'munda "m'minda", kukhazikitsidwa kolondola kwa minda kumachitika. Kumbukirani, tinalankhula za mwayiwu pang'ono. Apa mutha kutchula ndendende, wofotokozedwa bwino kwambiri, magawo a m'munda uliwonse. Kuphatikiza apo, mutha kuyikapo nthawi yomweyo kapena yopingasa.
- M'mabawa a m'manja, mutha kupanga zotsikira ndikukhazikitsa malo awo.
- Mu "pepala" tabu, mutha kukhazikitsa mawonekedwe a zingwe zomaliza kumapeto, ndiye kuti, mizere yomwe idzasindikizidwa pa pepala lirilonse pamalo ena. Kuphatikiza apo, mutha kutembenuza nthawi yomweyo masikonowo kwa osindikizira. Ndizothekanso kusindikiza gululi la pepalalo, lomwe silisindikizidwa ndi zosasinthika, zingwe ndi zingwe, ndi zina zina.
- Pambuyo pa zosintha zonse zimamalizidwa m'Zitundu "pazenera" pazenera, musaiwale kudina batani la "Ok" m'munsi mwake kuti apulumutse.
- Bweretsani ku "kusindikiza" gawo la fayilo. Kumbali yakumanja kwa zenera lomwe limatsegula zenera ndiye dera. Imawonetsa gawo la chikalata chomwe chimawonetsedwa pa chosindikizira. Mwachisawawa, ngati simunasinthe zina zowonjezera mu makonda, zomwe zili mufayilo ziyenera kuwonetsedwa pa kusindikiza, zomwe zikutanthauza kuti chikalata chonse chikuwonetsedwa m'deralo lowonetsera. Kuwonetsetsa kuti mutha kudumphadumphadumphadumpha.
- Pambuyo pa zoika zomwe mukuwona kuti muyenera kukhazikitsa, dinani batani la "Print" lomwe lili mu gawo lomweli.
- Pambuyo pake, zomwe zili mufayilo zizisindikizidwa pa chosindikizira.
Pali njira ina yosindikiza. Itha kuchitika popita ku "Tsamba la Tsamba" Tab. Zowongolera zosindikiza zili mu "masamba a masamba". Monga mukuwonera, ndizofanana ndi "fayilo" tabu ndipo imayendetsedwa ndi mfundo zomwezi.
Kupita ku Tsamba "Tsamba la Tsamba" Lachitatu, dinani pa chithunzi munjira ya mivi ya m'munsi mwapamwamba.
Pambuyo pake, zenera lam'munsi la US lidzakhazikitsidwa, momwe mungachitire zochita pa algorithm yomwe ili pamwambapa.
Njira 2: Pulogalamu yatsamba
Pamwambapa, tidayang'ana momwe tingakhazikitsire kusindikiza kwa bukuli chonse, ndipo tsopano tiyeni tiwone momwe mungachitire izi ngati sitikufuna kusindikiza chikalata chonse.
- Choyamba, tiyenera kudziwa kuti masamba ndi ati omwe akuyenera kusindikizidwa. Kuchita ntchitoyi, pitani ku tsamba. Izi zitha kuchitika podina chithunzi cha "Tsamba" lomwe limayikidwa pa bar ili ndi gawo lake lamanja.
Palinso zosiyana linanso yosintha. Kuti muchite izi, muyenera kulowa mu "Onani" tabu. Kenako, dinani batani la "Masamba"
- Pambuyo pake, mawonekedwe osakankhidwa amayambitsidwa. Monga mukuwonera, imalekanitsidwa ndi wina ndi mnzake ndi malo okhala, ndipo kuchuluka kwawo kumawonekera motsutsana ndi chikalatacho. Tsopano muyenera kukumbukira kuchuluka kwa masamba amenewo omwe tikusindikiza.
- Monga kale, timasamukira ku "fayilo" tabu. Kenako pitani ku gawo la "kusindikiza".
- M'magawo pali masamba awiri "masamba" awiri. Mu gawo loyamba, mumatchula tsamba loyamba la mitundu yomwe tikufuna kusindikiza, ndipo yachiwiri - lomaliza.
Ngati mukufuna kusindikiza tsamba limodzi lokha, ndiye kuti mumafunikiranso manambala.
- Pambuyo pake, ngati kuli kotheka, zikhazikike zonse zomwe zakhala zikugwiritsa ntchito njira 1. Kenako timadina batani la "kusindikiza" batani.
- Pambuyo pake, wosindikiza amasindikiza masamba omwe atchulidwa kapena pepala lokhazikika lomwe limatchulidwa mu makonda.
Njira 3: Kusindikiza masamba amodzi
Koma bwanji ngati mukufuna kusindikiza sizamodzi, koma masamba angapo kapena mapepala angapo amodzi? Ngati mu mawu oti ma sheet ndi mizere ikhoza kukhazikitsidwa kudzera pa comma, ndiye kuti palibe njira ngati imeneyi ku ukapolo. Komabe pali njira imeneyi, ndipo ili ndi chida chotchedwa "dera" la "Printi".
- Pitani ku tsamba la Tsamba la Exall mu imodzi mwa njira zomwe zokambirana zidanenedwera. Kenako, tsengani batani lamanzere la mbewa ndikugawa magulu a masamba omwe adzasindikiza. Ngati mukufuna kusankha mitundu yayikulu, kenako dinani nthawi yomweyo ndi gawo lake lapamwamba (cell), kenako pitani ku mitundu yomaliza ndikudina batani la mbewa ndi kiyi yosinthira. Mwanjira imeneyi, ma masamba angapo oyendetsera bwino amatha kufotokozedwa. Ngati ife, kupatula, ndikufuna kusindikiza komanso magawo ena angapo kapena ma sheet, timapanga ma sheet a ma sheet omwe akufunafuna ndi batani la CTRL. Chifukwa chake, zinthu zonse zofunika zidzafotokozedwa.
- Pambuyo pake, timasamukira ku tsamba la tabu ". Mu "masamba a masamba" pa tepi dinani batani la "chosindikizira". Kenako menyu yaying'ono imawonekera. Sankhani mthupi "set".
- Pambuyo pake, zochita zimayambiranso ku "Fayilo".
- Kenako, pitani gawo "" kusindikiza ".
- Mu zoikamo mu gawo loyenerera, sankhani "chosindikizira".
- Ngati ndi kotheka, timapanganso makonda ena omwe amafotokozedwa mwatsatanetsatane mu njira 1. Pambuyo pake, pokonzekera, timayang'ana zomwe ma sheet amawonetsedwa. Payenera kukhala zidutswa zokhazo zomwe tapatsidwa mu gawo loyamba la njirayi.
- Pambuyo pazosintha zonse zimalowa ndikulondola kwa chiwonetsero chawo, mumawoneka pawindo lachiwonetsero, dinani pa batani la "kusindikiza" batani.
- Pambuyo pa izi, mapepala osankhidwa ayenera kusindikizidwa pa chosindikizira cholumikizidwa ndi kompyuta.
Mwa njira, mwa njira yomweyo, pokhazikitsa malo osankhidwa, mutha kusindikiza osati mapepala amodzi okha, komanso kupatula masentimita kapena matebulo mkati mwa pepalalo. Mfundo za gawo limakhala zofanana ndi zomwe zafotokozedwa pamwambapa.
Phunziro: Momwe mungakhazikitsire malo osindikizira mu 2010
Monga mukuwonera, kuti asinthe kusindikiza kwa zinthu zomwe mukufuna kuti mudziwe bwino momwe mungafunire, muyenera kutsatsa pang'ono. Polbie, ngati mukufuna kusindikiza chikalata chonse, koma ngati mukufuna kusindikiza zinthu zina (mizu, ma sheet, etc.), kenako zovuta zimayamba. Komabe, ngati mukudziwa bwino malamulo osindikizira osindikiza mu processor yopanga izi, mutha kuthana nawo ntchitoyo. Chabwino, ndipo za momwe mungathere, makamaka, pogwiritsa ntchito kusindikizidwa kwa malo osindikizira, nkhaniyi imanena.