Pulogalamu ya Excel mothandizidwa ndi chida monga njira ikuthandizani kuchita masabata osiyanasiyana pakati pa deta mu maselo. Zochita zotero zikuphatikizapo kuchotsa. Tiyeni tiwone bwinobwino njira zomwe mungathe kuwerengera izi mu Excel.
Kuchotsa ntchito
Kutulutsidwa kwa Excel kungagwiritsidwe ntchito ku nambala yeniyeni komanso ku maadiresi a maselo omwe deta ilipo. Izi zimachitika chifukwa cha mayankho apadera. Monga momwe ziwerengero zina za masamu mu purogalamuyi, musanatuluke chingwe chotsitsa muyenera kuika chizindikiro chofanana (=). Kenaka, chizindikiro chochepa chimaperekedwa (mwa chiwerengero cha nambala kapena adilesi). (-), yoyamba deductible (mwa mawonekedwe a nambala kapena adiresi), ndipo nthawi zina opezeka deductible.
Tiyeni tiwone zitsanzo zenizeni za momwe masinthidwe awa amachitira mu Excel.
Njira 1: Chotsani Numeri
Chitsanzo chosavuta ndi kuchotsa manambala. Pankhaniyi, zochita zonse zimagwiridwa pakati pa manambala, monga momwe nthawi zonse zimakhalira, osati pakati pa maselo.
- Sankhani selo iliyonse kapena ikani ndondomeko mu bar. Ife timayika chizindikiro zofanana. Timasindikiza ntchito ya masamu ndi kuchotsa, monga momwe timachitira pamapepala. Mwachitsanzo, lembani ndondomeko zotsatirazi:
=895-45-69 - Kuti muyese ndondomekoyi, dinani pa batani. Lowani pabokosi.
Zitatha izi, zotsatira ziwonetsedwa mu selo losankhidwa. Kwa ife, nambala iyi ndi 781. Ngati munagwiritsa ntchito deta ina kuwerengera, ndiye, zotsatira zanu zidzakhala zosiyana.
Njira 2: Chotsani Numeri ku Maselo
Koma, monga mukudziwa, Excel ndi, koposa zonse, pulogalamu yogwirira ntchito ndi matebulo. Choncho, maselo ogwira ntchito ndi ofunika kwambiri. Makamaka, angagwiritsidwe ntchito pochotsa.
- Sankhani selo momwe mpangidwe wotsitsa udzakhalire. Ife timayika chizindikiro "=". Dinani mu selo yomwe ili ndi deta. Monga mukuonera, patatha izi, adiresi yake yaikidwa mu bar bar ndipo ikuwonjezeredwa chizindikiro zofanana. Timasindikiza chiwerengero chomwe chiyenera kuchotsedwa.
- Monga momwe zinalili kale, kuti mutenge zotsatira za mawerengedwe, pindani makiyiwo Lowani.
Njira 3: Chotsani Cell kuchokera ku Cell
Mukhoza kugwira ntchito zochotsa komanso zambiri popanda nambala, kugwiritsa ntchito maadiresi a maselo omwe ali ndi deta. Njirayi ndi yofanana.
- Sankhani selo kuti muwonetse zotsatira za mawerengero ndikuyikapo chizindikirocho zofanana. Timangodutsa pa selo yomwe ili ndi zionetsero. Ife timayika chizindikiro "-". Dinani pa selo muli deductible. Ngati opaleshoniyo ikufunika kuchitidwa ndi ndalama zambiri, ndiye kuti timayikanso chizindikiro "sungani" ndi kuchita zinthu mofanana.
- Deta yonse italowa, kuti muwonetse zotsatira, dinani pa batani Lowani.
Phunziro: Gwiritsani ntchito mayina mu Excel
Njira 4: Kusintha misa kwa ntchito yochotsa
Kawirikawiri, pamene mukugwira ntchito ndi Excel, zimachitika kuti mumayenera kuwerengera kuchotsa kwa maselo onse a maselo kupita ku gawo lina la maselo. Inde, mukhoza kulembera mndandanda wa ntchito iliyonse pamanja, koma izi zidzatenga nthawi yochuluka. Mwamwayi, ntchito ya pulojekitiyi imatha kugwira ntchito yowerengera, chifukwa cha ntchito yodzipereka.
Mwachitsanzo, ife timawerengera phindu la malonda m'madera osiyanasiyana, podziwa chiwerengero chonse cha ndalama ndi mtengo wogulitsa. Kuti muchite izi, muyenera kutenga mtengo wa ndalama.
- Sankhani selo lapamwamba kwambiri phindu lopindula. Ife timayika chizindikiro "=". Dinani pa selo yomwe ili ndi kuchuluka kwa ndalama mu mzere womwewo. Ife timayika chizindikiro "-". Sankhani selo ndi mtengo.
- Kuti muwonetse phindu zotsatira za mzerewu pazenera, dinani pa batani Lowani.
- Tsopano tifunika kufotokozera fomuyi kumunsi wotsika kuti tichite zofunikira pamenepo. Kuti muchite izi, ikani chotsekera pamunsi kumbali yakumanja ya selo yomwe ili ndi ndondomekoyi. Chizindikiro chodzaza chikuwonekera. Dinani batani lamanzere la mchenga ndi dziko lophwanyika, kukokera chithunzithunzi mpaka kumapeto kwa tebulo.
- Monga mukuonera, zitatha izi, ndondomekoyi inakopedwera kumtundu wonsewu. Panthawi imodzimodziyo, chifukwa cha malo ogwiritsira ntchito adiresi, kukopera uku kunachitika ndi kukhumudwa, komwe kunapangitsa kuti muwerenge kuchotsa molondola m'maselo oyandikana nawo.
Phunziro: Momwe mungapangire autocomplete mu Excel
Njira 5: Kuchotsa misa ya deta imodzi yokha kuchokera kumtundu umodzi
Koma nthawi zina nkofunika kuchita zosiyana, zomwe, kuti adiresi samasintha pamene mukujambula, koma nthawi zonse, ponena za selo lapadera. Kodi tingachite bwanji zimenezi?
- Timakhala selo yoyamba kusonyeza zotsatira za mawerengedwe owerengeka. Ife timayika chizindikiro zofanana. Dinani pa selo yomwe ili yovomerezeka. Ikani chizindikiro "sungani". Timakani pa selo la deductible, amene adiresi yake isasinthidwe.
- Ndipo tsopano tikufika ku kusiyana kwakukulu kwa njira iyi kuchokera kumbuyo. Ndizo zotsatirazi zomwe zimakulolani kuti mutembenuze chiyanjano kuchokera kufupi ndi mtheradi. Ikani chizindikiro cha dola kutsogolo kwa makonzedwe a mawonekedwe ndi osakanikirana a selo omwe adesi yake isasinthe.
- Timasankha pa kambokosi Lowanizomwe zimakulolani kuti muwonetse chiwerengero cha mzerewu pazenera.
- Kuti tipewe kuwerengera mndandanda wina, mofanana ndi chitsanzo choyambirira, timayitanitsa gwiritsani ntchito ndikugwedeza.
- Monga momwe mukuonera, ndondomeko yobweretsamo inachitika chimodzimodzi monga momwe tikufunira. Izi zikutanthauza kuti, pamene mukusunthira pansi, maadiresi a deta yosachepera asinthidwa, koma deductible siinasinthe.
Chitsanzo pamwambapa ndipadera. Mofananamo, mukhoza kuchita zosiyana, kotero kuti deductible imakhala nthawi zonse, ndipo deductible ndi wachibale ndi kusinthidwa.
Phunziro: Mtheradi ndi wachibale zimalumikizana ku Excel
Monga mukuonera, pakuzindikira njira yobweretsera ku Excel palibe chovuta. Imachitidwa molingana ndi malamulo ofanana ndi mawerengedwe ena a masamu pamagwiritsidwe ntchitowa. Kudziwa zinthu zochititsa chidwi kumathandiza wophunzirayo kuti athetse bwino deta yaikulu ndi izi, zomwe zidzasunga nthawi yake kwambiri.
