Pogwira ntchito ndi mtundu womwewo womwe umayikidwa matebulo osiyanasiyana, ma sheet kapena mabuku, kuti muzitha kuzindikira, ndibwino kusonkhanitsa zambiri limodzi. Mu Microsoft Excel, ntchitoyi ikhoza kuthana ndi chida chapadera chomwe chimatchedwa Kuphatikiza. Zimaperekanso kuthekera kokuta deta yosiyana mu tebulo limodzi. Tiyeni tiwone momwe angachitire.
Zofunikira pakuchita pakuphatikiza
Mwachilengedwe, si matebulo onse omwe akhoza kuphatikizidwa kukhala amodzi, koma okhawo omwe amakwaniritsa mikhalidwe ina:
- mizati muma tebulo onse iyenera kukhala ndi dzina lomwelo (chovomerezeka cha mizati m'malo chololedwa);
- pasakhale mizati kapena mizere yokhala ndi zopanda kanthu;
- matebulo azikhala ndi ma tempule omwewo.
Pangani tebulo lolumikizidwa
Tiyeni tiwone momwe tingapangire tebulo lolumikizidwa pogwiritsa ntchito matebulo atatu okhala ndi template yofanana ndi kapangidwe ka deta monga chitsanzo. Iliyonse ili pa pepala lozungulira, ngakhale pogwiritsa ntchito algorithm yomweyo mutha kupanga tebulo lophatikizika kuchokera ku deta yomwe ili m'mabuku osiyanasiyana (mafayilo).
- Tsegulani pepala logawanika.
- Pa pepala lomwe limatseguka, yikani khungu, lomwe lidzakhale selo lakumanzere la thebulo latsopano.
- Kukhala mu tabu "Zambiri" dinani batani Kuphatikizaili pa riboni m'bokosi la chida "Gwirani ntchito ndi deta".
- Zenera la kuphatikiza deta limatsegulidwa.
M'munda "Ntchito" Zimafunikira kuti zidziwike zomwe zimachitika ndi maselo zidzachitika mwadzidzidzi mizere ndi mizati. Izi ndi izi:
- Kuchuluka
- kuchuluka;
- pafupifupi;
- pazambiri;
- ochepa;
- ntchito;
- kuchuluka kwa manambala;
- kupatuka kopanda tanthauzo;
- kupatuka kosagwirizana;
- kubalalitsidwa
- kupezeka kosasangalatsa.
Mwambiri, ntchito imagwiritsidwa ntchito. "Ndalama".
- M'munda Lumikizani sonyezani maselo osiyanasiyana amtundu umodzi mwa matebulo oyambirira omwe amaphatikizidwa. Ngati izi zili mufayilo yomweyo, koma pepala lina, ndiye dinani batani, lomwe lili kumanja kwa gawo lolowera deta.
- Pitani ku pepala lomwe ili tebulo, ndikusankha mtundu womwe mukufuna. Mukalowetsa tsambalo, dinani kachiwiri pa batani lomwe lili kumanja kwa gawo komwe adelo adasungirako ma cell.
- Kubwereranso pazenera la kuphatikiza, kuti muwonjezere maselo omwe tidasankha kale pamndandanda wamndandanda, dinani batani Onjezani.
Monga mukuwonera, izi zitatha anawonjezera pamndandanda.
Momwemonso, timawonjezera magulu ena onse omwe adzatenge nawo gawo pakuphatikiza deta.
Ngati mulingo wofunikawu waikidwa mu buku lina (fayilo), ndiye dinani batani pomwepo "Ndemanga ...", sankhani fayilo pa hard disk kapena media media, ndipo pokhapokha mutagwiritsa ntchito njira yomwe ili pamwambapa, sankhani maselo osiyanasiyana mu fayilo iyi. Mwachilengedwe, fayilo iyenera kukhala lotseguka.
- Momwemonso, mutha kupanga zina pazomangamanga.
Kuti muwonjezere okha mayina ammitu pamutu, onani bokosi pafupi ndi paramayo Zolemba pamtundu wapamwamba. Kuti mufotokoze mwachidule izi, onetsetsani bokosi pafupi ndi gawo Mfundo Zamanzere Zotsalira. Ngati mukufuna kuti zidziwitso zonse zomwe zili pagome lolumikizidwa zisinthidwe mukamakonzanso zosintha mumatauni oyambira, muyenera kudziwa bokosi "Pangani maubwenzi ndi data yapa source". Koma, pankhaniyi, muyenera kukumbukira kuti ngati mukufuna kuwonjezera mizere yatsopano patebulo loyambirira, muyenera kuyimitsa nkhaniyi ndikulembanso mfundo pamanja.
Zosintha zonse zikamalizidwa, dinani batani "Zabwino".
- Ripoti lophatikiza lakonzeka. Monga mukuwonera, deta yake imakhala m'magulu. Kuti muwone zomwe zili mgulu lililonse, dinani chikwangwani chophatikizira kumanzere kwa tebulo.
Tsopano zomwe zili mgululi zilipo kuti zitha kuwonedwa. Mwanjira yomweyo, mutha kutsegula gulu lina lililonse.
Monga mukuwonera, Kuphatikiza deta ya Excel ndi chida chosavuta, chifukwa cha momwe mungatengere zidziwitso zomwe siziri mumataulo osiyanasiyana ndi pamapepala osiyanasiyana, komanso ndikupezeka m'mafayilo ena (mabuku). Izi zimachitika msanga komanso mosavuta.
