Pogwira ntchito ndi matebulo omwe ali ndi mizere yambiri kapena mizere, funso lokonzekera deta likufulumira. Mu Excel izi zingapezeke mwa kugwiritsa ntchito gulu la zofananazo. Chida ichi chimakulolani kuti musamangoganizira zokhazokha, koma panthawi yokha muzibisa zinthu zosafunikira, zomwe zimakulolani kuyika mbali zina za tebulo. Tiyeni tione m'mene tingagwirire ku Excel.
Kukhazikitsa magulu
Musanapite ku gulu la mizere kapena zigawo, muyenera kukonza chida ichi kuti zotsatira zake zithe pafupi ndi zomwe akuyembekezera.
- Pitani ku tabu "Deta".
- Mu ngodya ya kumanzere ya bokosi la zida "Chikhalidwe" Pa tepi ndi kamphindi kakang'ono koti. Dinani pa izo.
- Fayilo lokhazikitsa magulu likuyamba. Monga mukuonera, mwazikhazikitsidwa kuti ma totals ndi mayina muzitsulo ali kumanja kwa iwo, ndi mizere pansipa. Izi sizikugwirizana ndi ogwiritsa ntchito ambiri, chifukwa ndizosavuta kuti dzina liyike pamwamba. Kuti muchite izi, sungani chinthu chomwe chikugwirizana. Kawirikawiri, aliyense wogwiritsa ntchito amatha kusinthira magawowa. Kuphatikizanso, mutha kutembenuzira mafashoni okhaokha pofufuza bokosi pafupi ndi dzina ili. Pambuyo pokonzekera, panikizani pa batani. "Chabwino".
Izi zimatsiriza kukhazikitsidwa kwa magawo a gulu mu Excel.
Gulu pamzere
Pezani magulu a deta ndi mizere.
- Onjezerani mzere pamwamba kapena pansi pa gulu la zipilala, malingana ndi momwe tikukonzekera kusonyeza dzina ndi zotsatira. Mu selo yatsopano, timayambitsa dzina lachigwirizano, loyenerera pazochitika.
- Sankhani mizere yomwe iyenera kugawidwa, kupatula pa mndandanda wa chidule. Pitani ku tabu "Deta".
- Pa tepiyi mu chida cha zipangizo "Chikhalidwe" dinani pa batani "Gulu".
- Fasilo yaying'ono imatsegukira kumene muyenera kupereka yankho limene tikufuna kulisankha - mizere kapena zipilala. Ikani kasinthasintha "Zolimba" ndipo dinani pa batani "Chabwino".
Kulengedwa kwa gululi kwatha. Kuti muchepetse, ingolani pa chizindikiro "chotsitsa".
Kuti mupitirize kukweza gululi, muyenera kutsegula chizindikiro chachikulu.
Kuphatikiza gulu
Mofananamo, gulu limagwiritsidwa ndi zipilala.
- Kumanja kapena kumanzere kwa deta yowonjezera timayika ndondomeko yatsopano ndikuwonetsera mmenemo dzina lofanana nalo.
- Sankhani maselo muzomwe tikupita ku gulu, kupatula pazomwe zili ndi dzina. Dinani pa batani "Gulu".
- Muzenera lotseguka nthawi ino timayika mawonekedwe "Mizati". Timakanikiza batani "Chabwino".
Gulu liri okonzeka. Mofananamo, mofanana ndi kugawidwa kwa zipilala, zikhoza kugwedezeka ndikuwonjezeredwa powonjezera pa "kuchotsera" ndi "kuphatikiza" zizindikiro, motero.
Kupanga magulu otukwana
Mu Excel, simungapange magulu oyamba okha, komanso amtendere. Kuti muchite izi, muyenera kusankha maselo ena mu gulu lokulitsa la gulu la makolo, limene mukupita kumagulu okhaokha. Kenaka tsatirani njira zomwe tafotokoza pamwambapa, malingana ndi momwe mukugwirira ntchito ndi mizere kapena mizere.
Pambuyo pake gulu lachisa lidzakhala lokonzeka. Mungathe kupanga chiwerengero chosasemphana cha ndalama zoterezi. Kuyenda pakati pawo n'kosavuta kuyenda mwa kusuntha manambala kumanzere kapena pamwamba pa pepala, malingana ndi kuti mizere kapena zipilala zikugawidwa.
Kugwirana
Ngati mukufuna kusintha kapena kungochotsa gulu, ndiye kuti mukufunika kulipanga.
- Sankhani maselo a zipilala kapena mizere kuti zisagwirizane. Timakanikiza batani "Guluzani"yomwe ili pamtambowo muzitseko "Chikhalidwe".
- Muwindo lomwe likuwonekera, sankhani zomwe tikufunikira kuti tisiye: mizere kapena zipilala. Pambuyo pake, dinani pa batani "Chabwino".
Tsopano magulu osankhidwa adzachotsedwa, ndipo chithunzichi chidzatenga mawonekedwe ake oyambirira.
Monga mukuonera, kupanga gulu la zipilala kapena mizere ndi losavuta. Pa nthawi yomweyi, atatha kuchita izi, wogwiritsa ntchito akhoza kuthandiza kwambiri ntchito yake ndi tebulo, makamaka ngati ndi lalikulu kwambiri. Pachifukwa ichi, kupanga magulu odyetsedwa kungathandizenso. Kugwirana ndi kosavuta monga kugawa deta.
