Mwinanso, ogwiritsa ntchito onse omwe amagwira ntchito ndi pulogalamu ya Microsoft Excel amadziwa ntchito zofunikira za pulogalamuyi monga kusefa deta. Koma sikuti aliyense amadziwa kuti palinso zida zapamwamba za chida ichi. Tiyeni tiwone zomwe fyuluta yapamwamba ya Microsoft Excel ingachite, ndi momwe mungagwiritsire ntchito.
Kupanga tebulo lokhala ndi nthawi yosankha
Pofuna kukhazikitsa zosefera zapamwamba, choyambirira, muyenera kupanga tebulo yowonjezera ndi momwe mungasankhire. Mutu wa gome ili ndi ofanana ndendende ndi tebulo lalikulu, lomwe ife, kwenikweni, tidzasefa.
Mwachitsanzo, tidayika tebulo yowonjezera pamwamba pa wamkulu, ndikupaka maselo ake mu lalanje. Ngakhale, mutha kuyika tebulo ili pamalo aliwonse aufulu, ndipo ngakhale papepala lina.
Tsopano, tikuyika mu tebulo lowonjezeralo deta yomwe idzafunikira kusefedwa kuchokera pagome lalikulu. M'malo mwathu, kuchokera pamndandanda wa malipiro omwe amaperekedwa kwa ogwira nawo ntchito, tinaganiza zosankha data paomwe amagwira ntchito achimuna a 07.25.2016.
Thamangitsani Zosefera Zotsogola
Pokhapokha tebulo lowonjezera litatha kupangidwa mungathe kupitiriza kukhazikitsa fyuluta yapamwamba. Kuti muchite izi, pitani pa tabu ya "Data", ndipo pakumanja pa "Sort and Filter", dinani batani "Advanced".
Windo lazosefa zotsogola limatseguka.
Monga mukuwonera, pali njira ziwiri zogwiritsira ntchito chida ichi: "Sinthani mndandandawo m'malo mwake", ndi "Kopani zotsatirazi kumalo ena." Poyambirira, kusefa kudzachitidwa mwachindunji pagawo la magwero, ndipo chachiwiri, padera pamitundu yosiyanasiyana yamaselo yomwe mumatchula.
Pazigawo "Source range", tchulani maselo osiyanasiyana omwe ali pagululo. Izi zitha kuchitika pamanja poyendetsa ma linki ku kiyibodi, kapena kuwunikira maselo omwe akufuna ndi mbewa. M'munda wa "Maonekedwe osiyanasiyana", muyenera kutchulanso mtundu wa mitu ya tebulo lowonjezera, ndi mzere womwe uli ndi momwe zinthu ziliri. Nthawi yomweyo, muyenera kulabadira kuti mizere yopanda kanthu isagwere mumtunduwu, apo ayi palibe chomwe chidzagwira ntchito. Zosintha zonse zikamalizidwa, dinani batani "Chabwino".
Monga mukuwonera, mfundo zokha zomwe tidaganiza kuzisefa zidatsalira pa tebulo loyambirira.
Ngati mwasankha njirayo ndi zotsatira zomwe zikuwoneka kumalo ena, ndiye mu gawo la "Ikani zotsalazo", muyenera kufotokozera maselo omwe maselo omwe adaseweredwa amawonetsedwa. Mutha kutchula khungu limodzi. Poterepa, lidzakhala khungu lamanzere patebulo latsopanoli. Masankhidwe atapangidwa, dinani batani "Chabwino".
Monga mukuwonera, izi zitatha, tebulo loyambirira lidasinthidwa, ndipo zosefedwazo zimawonetsedwa pagome lina.
Kuti mubwezeretse fyuluta mukamagwiritsa ntchito mndandanda wa malo, muyenera dinani batani "Delete" pazitseko zomwe zili mu "Sort and Filter" block.
Chifukwa chake, titha kunena kuti zosefera zapamwamba zimapereka zosankha zambiri kuposa kusefa kwazomwe zikuchitika. Nthawi yomweyo, ziyenera kudziwika kuti kugwira ntchito ndi chida ichi ndikosavuta kwenikweni kuposa kusefera wamba.
