Ntchito zowonongeka ndizozigwira ntchito mu Excel ndi mapulogalamu ena omwe amapangitsa maselo omwe ntchitozo zikhazikitsenso nthawi zonse pamene tsamba lidakonzanso. Ntchito zosasinthasintha zimawongolera ngakhale ngati, kapena deta yomwe amadalira, sizikuwoneka kuti zasintha.
Komanso, njira iliyonse yomwe imadalira mwachindunji kapena mwachindunji pa selo yomwe ili ndi ntchito yosasinthasintha idzakhalanso kubwereza nthawi iliyonse pamene kubwezeretsa kumachitika. Pazifukwa izi, kugwiritsa ntchito ntchito zambiri zowonongeka pa tsamba lalikulu la ntchito kapena buku lothandizira lingathandize kwambiri kuti nthawi yowonjezeredwa ikhale yowonjezera.
Ntchito Yoyamba Ndiponso Yosasintha
Zina mwa ntchito zomwe zimagwiritsidwa ntchito kwambiri ndi izi:
- ntchito YOWOWIKA
- ntchito ya MASIKU ano
- ntchito ya RAND
pamene ntchito zochepa zomwe sizikugwiritsidwa ntchito nthawi zambiri zimaphatikizapo:
- ntchito ya OFFSET
- INDIRECT ntchito
Chitsanzo Chokhazikika
Monga tawonera mu chithunzi pamwambapa,
- selo D1 liri ndi = RAND () ntchito, yomwe imapanga nambala yatsopano mwachitsulo chilichonse cha tsamba
- selo D2 liri ndi chiganizo = D1 + 5, chomwe chimapangitsa kuti chimadalira molingana ndi mtengo mu selo D1
- selo D3 liri ndi chiganizo = D2 - 10, chomwe chimapangitsa kuti chimadalira mwachindunji kufunika mu selo D2 ndipo, motero, kudalira mwachindunji kufunika kwa selo D1
Choncho, nthawi iliyonse yobwereza makina amavomereza amawonekera, zida zomwe zili m'maselo D2 ndi D3 zidzasintha pamodzi ndi mtengo mu selo D1 chifukwa zonse D2 ndi D3 zimadalira mwachindunji kapena molakwika pa nambala yosasintha yomwe imapangidwa ndi DAND yopanda ntchito mu D1.
Zochita Zomwe Zimayambitsa Zowonongeka
Zomwe anthu amachita zomwe zimayambitsa ndondomeko ya zolemba kapena zolemba zolemba mabuku ndizo:
- kulowetsa deta yatsopano pamene mwasintha njira yokonzanso yomwe ili yosasinthika ku mabuku onse ogwira ntchito ku Excel
- kuwonjezera kapena kuchotsa mizere kapena zikhomo pa tsamba la zolemba
- kubisala kapena kutsegula mizere (koma osati zipilala) mkati mwa tsamba
- kukonzanso tsamba
- kukonzanso maofesi m'mabuku
- kuwonjezera, kusintha, kapena kuchotsa dzina lotchulidwa
- pamene mukugwiritsa ntchito njira yobwereza, pangani makiyi a F9 pa makiyi omwe amachititsa kuti, m'mabuku onse ogwira ntchito, kubwezeretsanso maselo okhala ndi mayendedwe kapena ovomerezeka omwe asintha kuchokera kuwerengedwa kotsiriza.
- pamene mukugwiritsiridwa ntchito mobwerezabwereza, mukukakamiza SHIFT + F9 pa kiyibodi yomwe imalimbikitsa, mu tsamba logwira ntchito yokha, kukhazikitsidwa kwa maselo okhala ndi mayendedwe kapena odalira maonekedwe omwe asintha kuchokera kuwerengedwa kotsiriza.
- pamene mukugwiritsa ntchito njira yobwereza, ndikukakamiza CTRL + ALT + F9 pa kiyibodi yomwe imalimbikitsa kubwezeretsanso mafomu onse m'mabuku onse ogwirira ntchito mosasamala kanthu kuti asintha kapena ayi kuyambira chiwerengero chomaliza
Kupanga Maonekedwe ndi Kukonzanso
Zopangidwe zovomerezeka ziyenera kuyesedwa ndi mawerengedwe alionse kuti aone ngati zikhalidwe zomwe zinapangitsa kuti machitidwe opangidwira apangidwe agwiritsidwe ntchito akadalipo. Zotsatira zake, njira iliyonse yomwe imagwiritsidwa ntchito pamakhalidwe ovomerezeka bwino amakhala ovuta.