Kugwira ntchito ndi matebulo, ogwiritsa ntchito amalipira kofunikira kulowa deta, nthawi zina kumayiwala mawonekedwe a chikalatacho. Ichi ndi chomveka chowonekera, chifukwa tebulo lokongoletsedwa bwino silofunikira kuzindikira kwabwino kwambiri, komanso kumvetsetsa ndikupeza ma consices ena. Kenako, tidzakambirana zida zina zam'maso za kutsanulira, ndi momwe mungagwiritsire ntchito.
Kudzaza maselo ku Excel: Njira zoyambira
Kudzaza maselo okhala ndi utoto, kutengera zomwe zili mkati, zimathandizira kugwira ntchito ndikuzindikira zofunikira. Njirayi ndiyofunikira makamaka mukamagwira ntchito ndi matebulo akulu omwe ali ndi deta yambiri pakufunika kukonza. Kuchokera pa izi zikutsatira kuti mtundu wa utoto umathandizira kupanga chikalata chomalizidwa pazinthu zofunika.
Kupanga zolemba zazing'ono zazing'ono, mutha kugwiritsa ntchito njira yamabuku odekha. Ngati mukufuna kupanga tebulo lomwe limakhala pepala lonse kapena zochulukirapo, ndizosavuta kugwiritsa ntchito zida zapadera. Ngakhale pali ogwiritsa ntchito olimba mtima omwe akufuna kugwira ntchito yonseyo pamanja, mwayi ndikuti cholakwika chidzaloledwa mu chikalatacho. Makamaka kuti muthandizire ntchitozi mu Excel, maselo amathiridwa ndi utoto. Momwe mungachitire izi, ganiziraninso zina.
Njira nambala 1: Chiwini wamba ndi mtunduKuti tichite ntchito imeneyi, tifunikira chida chosintha mawonekedwe a maselo. Kuti muchite izi, tsatirani malangizo omwe aperekedwa:
- Poyamba, onani maselo omwe mtunduwo udzadzaza ndikuyambitsa mwakakanikiza LKM. Mwina zikhala maselo angapo nthawi imodzi.
- Mu "Nyumba" ya "Panyumba", pezani font block. Zochita zina zitha kuchitidwa ndi imodzi mwa njira zomwe akufuna:
- Kuti mudzaze mtundu wa khungu, gwiritsani ntchito chida "chadzaza", chomwe chimaperekedwa mu chidebe chomwe chimadzaza. Mwa kuwonekera pachizindikiro ndi makona atatu, tsegulani bokosi la zokambirana komwe mumasankha mtundu womwe mukufuna.
- Ngati mwalephera kusankha mtundu wa mthunzi woloza, kenako gwiritsani ntchito "mitundu ina". Pazenera lomwe limatsegula, sankhani imodzi mwa njira zosankha za utoto: Malinga ndi ma cell omwe awonetsedwa kapena mawonekedwe. Njira yachiwiri imapangitsa kuti musankhe mawu omveka kwambiri.
- Batani la "Dzazani" limasunga chisankho chomaliza. Chifukwa chake, ngati mukufuna kugwiritsa ntchito dzanja limodzi m'malo angapo, mutatha kuyambitsa foni yomwe mukufuna, mutha kudina batani popanda kutsegula mawindo owonjezera.
Kupangitsa kuti patebulo yopambana sikuwoneka ngati lotopetsa ndi monophthonic, ndizotheka kusinthanitsa ndi kuwonjezeranso mavidiyo. Ganizirani njira yochitira ntchitoyi:
- Sankhani maselo amodzi kapena angapo momwe muyenera kuyika mawonekedwe a utoto.
- M'nyumba yanyumba, fufuzani "font" block ndikudina mtundu wa "Fomu ya Cell", yomwe ili m'munsi mwapamwamba ndikuyimiriridwa ngati muvi wowoneka bwino womwe ukuwonetsa ngati ngodya.
- Pazenera lomwe limatseguka, pitani ku "Dzazani" tabu, komwe mgululi "utoto" umasankha kamvekedwe kanu kadzaza.
- Kenako, chitani chimodzi mwazinthu izi:
- Pofuna kudzaza mitundu iwiri pogwiritsa ntchito njirayo, pitani ku "chitsanzo" ndikusankha mitundu yofunikira. Pambuyo pake, pitani ku gawo la "PENE" ndikuwona mawonekedwe.
- Kuti mugwiritse ntchito zotsatira zapadera, muyenera kutsatira ulalo "Kukwaniritsa njira" ndikusankha magawo ofunikira. Ngati magawo osankhidwa amakonzedwa, kanikizani batani la "OK".
Njira iyi ingagwiritsidwe ntchito ngati khungu limasankhidwa mtunduwo usanapangidwe ndipo palibe zochita zina zomwe zidachitika. Ndondomeko Yochita: Sankhani maselo omwe amafunika kusintha, ndikudina makiyi a Ctrl.
Ngati kudzazidwa kunapangidwa, ndipo zitatha izi, chochita chimodzi chinachitika, ndiye kuti njira iyi siyigwira ntchito, popeza njira yofunsidwa imatengera kukwaniritsidwa kwa zinthu zaposachedwa, kukhala mtundu wa clipboard.
Njira ya Njira 4 Kupanga MacroNjirayi imafunikira pulogalamu yapadera ya macrorecorer momwe, kukhala ndi luso linalake, mutha kupanga macros kuchita zinthu zosiyanasiyana. Pachithunzichi mutha kuwona nambala yachitsanzo cha Macro.
Kuchotsa kwa khungu
Ngati mukufuna kuchotsa zodzaza m'zilozo zomwe zidachitika kale, ndiye gwiritsani ntchito malangizo omwe ali pansipa:
- Sankhani maselo osefukira ndi mtundu kapena utoto womwe umafunikira kusintha.
- Pa tabu yakunyumba, pitani ku "font" block. Dinani chithunzi cha muvi ndikutsegula bokosi la zokambirana. Pitani pamtengo "osadzaza" ndikuyambitsa mwa kukanikiza Lkm.
Mapeto
Pali njira zingapo zokwaniritsira khungu. Aliyense wa iwo ali ndi zabwino zake komanso zovuta zake. Nthawi zina, ndizovomerezeka kugwiritsa ntchito njira yoyamba, yofulumira yakudzaze, mwa ena ndikofunikira kusamala kwambiri kapangidwe kake, ndiye kuwonjezera pa mawonekedwe ndikothandiza.
UTHENGA WABWINO WABWINO WABWINO WABWINO KWAMBIRI KWAULERE KWAULERE KWA UTHENGA WABWINO.