Pogwira ntchito ndi matebulo, nthawi zambiri zimakhala zochitika, pokhapokha ma totaliti, amafunikanso kusokoneza anthu ena. Mwachitsanzo, patebulo la kugulitsa katundu kwa mwezi, momwe mzere uliwonse umasonyezera kuchuluka kwa ndalama kuchokera kugulitsidwa kwa mtundu wina wa mankhwala patsiku, mukhoza kuwonjezerapo nsalu za tsiku ndi tsiku kuchokera ku kugulitsa kwa mankhwala onse, ndipo pamapeto pa tebulo amatsimikizira kufunika kwa ndalama zonse pamwezi. Tiyeni tipeze momwe tingapangire zigawo zapadera ku Microsoft Excel.
Momwe mungagwiritsire ntchito ntchitoyi
Koma, mwatsoka, si magome onse ndi ma datasti ali oyenera kugwiritsa ntchito ntchito yachinsinsi. Malamulo akuluwa ndi awa:
- tebulo liyenera kukhala ndi mawonekedwe a selo nthawi zonse;
- Mutu wa tebulo uyenera kukhala ndi mzere umodzi ndikuyika pa mzere woyamba wa pepala;
- Tebulo lisakhale ndi mizera yopanda kanthu.
Pangani zochepa zapadera
Kuti mupange zigawo zochepa, pitani ku tabu la "Deta" mu Excel. Sankhani selo iliyonse pagome. Pambuyo pake, dinani pa batani "Subtotal", yomwe ili pa riboni mu zida za "Structure".
Kenaka, zenera zikutsegula momwe mukufuna kukhazikitsa kuchotserako kwazing'ono. Mu chitsanzo ichi, tifunika kuona ndalama zonse zogulitsa katundu tsiku lililonse. Mtengo wamtengo uli m'ndandanda ya dzina lomwelo. Kotero, kumunda "Ndi kusintha kulikonse" sankhani ndime "Tsiku".
Kumunda "Opaleshoni" sankhani mtengo "Mtengo", popeza tikufunikira kufanana ndendende ndi ndalama patsiku. Kuwonjezera pa kuchuluka kwa ndalama, ntchito zina zambiri zimapezeka, zomwe ndizo:
- kuchuluka;
- mulingo;
- chochepa;
- ntchitoyo.
Popeza ndalama zamtengo wapatali zimasonyezedwa mu gawoli "Mtengo wa ndalama, ruble.", Kenaka mu "Add totals ndi" munda, timasankha kuchokera pa ndandanda yazomwe zili mu tebulo ili.
Kuonjezerapo, muyenera kuyika nkhupakupa, ngati sichikhazikitsidwe, pafupi ndi "Bweretsani chizindikiro chamtundu". Izi zidzaloledwa, pakubwezeretsanso tebulo, ngati simukuchita ndondomeko yowerengera kachilombo kawiri kawiri kawiri, kuti musabwerezenso chiwerengero cha ziwerengero zomwezo nthawi zambiri.
Ngati mungagwiritse ntchito bokosi lakuti "Mapeto a tsamba pakati pa magulu", ndiye pamene akusindikiza, chigawo chilichonse cha tebulo chomwe chili ndi zigawo zapakati chidzasindikizidwa pa tsamba limodzi.
Ngati mutayang'ana bokosi pafupi ndi mtengo wa "Totals pansi pa deta", zigawozo zidzakhala pansi pa mizere, zomwe zonsezi ziwerengedwa. Ngati simukutsegula bokosi ili, zotsatirazo zidzawoneka pamwamba pa mizere. Koma ali kale mtumiki mwiniyo amene amadziŵa kuti ali omasuka bwanji. Kwa anthu ambiri, ndizosavuta kuyika totali pansi pa mizere.
Pambuyo pazomwe makonzedwe apamtunda amatsirizika, dinani pa batani "OK".
Monga mukuonera, zigawo zazing'ono zimapezeka patebulo lathu. Kuwonjezera pamenepo, magulu onse a mizere, ogwirizana ndi zotsatira imodzi, angathe kuchepetsedwa mwa kungolemba chizindikiro chochepa, kumanzere kwa gome, kutsogolo kwa gulu linalake.
Choncho, n'zotheka kugwa mizere yonse patebulo, ndikusiya ma totali onse ndi aakulu omwe akuwonekera.
Tiyeneranso kukumbukira kuti posintha deta m'mizere ya tebulo, chiwerengerochi chidzabwezeretsedwanso.
Mchitidwe "WOTSATIRA MITU YA NKHANI"
Kuwonjezera pamenepo, n'zotheka kuwonetsa zochepa zomwe sizidutsa pakani pa tepi, koma pogwiritsira ntchito mwayi wodzitcha ntchito yapadera kudzera mu batani la Kuyika. Kuti muchite izi, choyamba kanikeni pa selo komwe ziwonetserozo ziwonetsedwe, dinani ndondomeko yomwe yafotokozedwa, yomwe ili kumanzere kwa bar.
Ntchito wiziti imatsegulidwa. Pakati pa mndandanda wa ntchito ndikuyang'ana chinthucho "CHIKHALIDWE CHIYAMBIRI." Sankhani, ndipo dinani "Bwino".
Mawindo akutsegula momwe muyenera kulowera ntchito zotsutsana. Mu mzere "Nambala ya ntchito" muyenera kulemba chiwerengero cha chimodzi mwa mitundu khumi ndi iwiri yosinthidwa, monga:
- chiwerengero cha masamu;
- chiwerengero cha maselo;
- chiwerengero cha maselo odzaza;
- mtengo wapatali pazomwe asankhidwa deta;
- mtengo wochepa;
- chiwerengero cha deta mu maselo;
- Kusiyana kwa chitsanzo;
- Kusiyana kwa chiwerengero cha anthu onse;
- kuchuluka;
- kusiyana pakati pa chitsanzo;
- kufalikira kwa anthu ambiri.
Kotero, ife timalowa mmunda chiwerengero cha zomwe tikufuna kuzigwiritsa ntchito panthawi inayake.
M'ndandanda "Link 1" muyenera kufotokoza chiyanjano ku maselo osiyanasiyana omwe mukufuna kukhazikitsa zoyenera. Mpaka zaka zinayi zosiyana zimaloledwa. Powonjezera makonzedwe ku maselo angapo, mawindo amawonekera mwamsanga kuti muthe kuwonjezera zotsatirazo.
Popeza sizingatheke kuti mutsegule pamtundu uliwonse, mungathe kungoyang'ana pa batani yomwe ili kumanja kwa mawonekedwe olowera.
Pankhaniyi, ntchito yotsutsana zenera idzachepetsedwa. Tsopano mungathe kusankha mwachindunji deta yomwe mukufunayo ndi ndondomeko. Pambuyo pake mutalowa mu mawonekedwe, dinani pakani yomwe ili kumanja kwake.
Ntchito yotsutsana zenera ikutsegulanso. Ngati mukufuna kuwonjezera chimodzi kapena zambiri zowonjezera deta, kenaka yikani ndondomeko yomweyi yomwe inanenedwa pamwambapa. Pankhani ina, dinani pa batani "OK".
Pambuyo pake, zigawo zadongosolo zosankhidwazi zidzapangidwe mu selo limene chiganizocho chipezeka.
Chidule cha ntchitoyi ndi chonchi: "KUCHITA ZINTHU ZINA (ntchito_number; adra_address adresse). Mulimonsemo, njirayi idzawoneka ngati iyi:" INTERMEDIATE.RATING (9; C2: C6) " ndi mwaulere, popanda kutchula Mbuye wa Ntchito.Kodi, muyenera kukumbukira, ikani chizindikiro "=" kutsogolo kwa ndondomeko mu selo.
Monga momwe mukuonera, pali njira zikuluzikulu ziwiri zopangira zochepa: pogwiritsa ntchito batani pa tepiyo, komanso kudzera mwachinthu chapadera. Kuwonjezera apo, wogwiritsa ntchitoyo ayenera kudziwa kuti mtengo wake udzawonetsedwa chifukwa chiyani: chiwerengero, chochepa, chiwerengero, mtengo wapatali, ndi zina zotero.
