Excel, pogwiritsa ntchito chida monga mafomula, imakuthandizani kuti mugwire ntchito zosiyanasiyana zamasamu pakati pa deta yama cell. Kuchotsanso kumagwiranso ntchito ngati izi. Tiyeni tiwone bwino njira zowerengera izi momwe zingachitikire ku Excel.
Kugwiritsa ntchito
Kuchotsa mu Excel kungagwiritsidwe ntchito manambala onse enieni ndi ma adilesi amaselo omwe maselo adakhalako. Izi zimachitika chifukwa cha njira zapadera. Monga mawerengero ena owerengera pulogalamuyi, musanatsike njira, muyenera kukhazikitsa chizindikiro chomwechi (=). Kenako pang'onopang'ono ndi komwe kumatsika (mwanjira ya nambala kapena adilesi ya foni), chizindikiro chosonyeza (-), woyamba kudzipereka (mwa kuchuluka kwa nambala kapena adilesi), ndipo nthawi zina kudzipatulira kwotsatira.
Tiyeni tiwone zitsanzo mwatsatanetsatane za momwe ntchito yochitirayi imagwirira ntchito ku Excel.
Njira 1: Kutengera Manambala
Chitsanzo chosavuta ndikutengera kwa manambala. Potere, zochitika zonse zimachitika pakati pa ziwerengero, monga zowerengera, osati pakati pa maselo.
- Sankhani khungu lililonse kapena ikani chikhazikitso mu baramu yokhazikika. Timayika chikwangwani zofanana. Timasindikiza magwiridwe anthawi zonse pochotsa, monga timachitira papepala. Mwachitsanzo, lembani zotsatirazi:
=895-45-69 - Kuti muchite kuwerengera, dinani batani Lowani pa kiyibodi.
Zitachitika izi, zotsatira zake zimawonetsedwa mu foni yosankhidwa. Zomwe ife tili, izi ndi 781. Ngati mugwiritsa ntchito deta ina kuwerengera, ndiye, motero, mudzapeza zotsatira zosiyana.
Njira 2: kuchotsa manambala kuchokera ku maselo
Koma, monga mukudziwa, Excel ndiye, choyambirira, pulogalamu yogwirira ntchito ndi matebulo. Chifukwa chake, opaleshoni yokhala ndi maselo ndiyofunikira kwambiri m'menemo. Makamaka, amathanso kugwiritsidwa ntchito pochotsa.
- Sankhani khungu lomwe mufotokozere zomwe mungachite. Timayika chikwangwani "=". Dinani pa foni yomwe ili ndi zomwezo. Monga mukuwonera, izi zitachitika, adilesi yake imalowetsedwa mu bar formula ndikuwonjezeredwa pambuyo pa chizindikirocho zofanana. Timasindikiza nambala kuti ichotsedwe.
- Monga momwe zinalili kale, kuti mupeze zotsatira zowerengera, dinani chinsinsi Lowani.
Njira 3: chotsani khungu mu khungu
Mutha kuchita ntchito zochotsa popanda manambala konse, kugwiritsa ntchito ma adilesi amaselo okha. Mfundo zoyenera kuchita ndi zomwezo.
- Timasankha foni kuti tiwonetse zotsatira za kuwerengera ndikuyika chikwangwani zofanana. Dinani pa cell yomwe yachepa. Timayika chikwangwani "-". Dinani pa foni yomwe ili ndi zochotseredwa. Ngati ntchito ikuyenera kuchitika ndi ma purucu angapo, ndiye kuti timayikanso chikwangwani opanda ndipo chitani zomwezo mwanjira yomweyo.
- Pambuyo poti datha yonse yaikidwa, kuti muwonetse zotsatira, dinani batani Lowani.
Phunziro: Kugwira ntchito ndi mafomu ku Excel
Njira 4: misa ikuchita ntchito yochotsa
Nthawi zambiri, mukamagwira ntchito ndi Excel, zimachitika kuti mufunika kuwerengera masanjidwe amtundu wonse wa maselo. Zachidziwikire, mutha kulemba formula iliyonse pakuchita chilichonse pamanja, koma izi zimatenga nthawi yayitali. Mwamwayi, magwiridwe antchito amatha kugwiritsa ntchito mawerengeredwe otere, chifukwa cha ntchito yanu yoyipa kale.
Mwachitsanzo, timawerengera phindu la bizinesiyo m'malo osiyanasiyana, podziwa ndalama ndi mtengo wonse wopangira. Kuti muchite izi, kuchokera ku ndalama zomwe mumafunikira mutengere mtengo wake.
- Sankhani khungu lanu lapamwamba kuti mupeze phindu. Timayika chikwangwani "=". Dinani pa khungu lomwe lili ndi saizi yomweyo. Timayika chikwangwani "-". Sankhani khungu ndi mtengo.
- Kuti muwonetsetse phindu la mzerewu pazenera, dinani batani Lowani.
- Tsopano tikuyenera kukopera fomula iyi m'munsi kuti tikawerengere pamalopo. Kuti muchite izi, ikani cholozera pamphepete kumanja kwa foni yomwe ili ndi fomula. Chizindikiro Timakanikizira batani lamanzere lamanzere ndipo mmalo opendekeka timakokera thumba mpaka kumapeto kwa tebulo.
- Monga mukuwonera, izi zitachitika, fomuloli idatsatiridwa kumitundu yonse pansipa. Nthawi yomweyo, chifukwa cha malo monga ubale wama adilesi, kukopera uku kunachitika ndi zoseweretsa, zomwe zimapangitsa kuwerengera molondola kutulutsa m'maselo oyandikana nawo.
Phunziro: Momwe mungachite mosamalitsa mu Excel
Njira 5: kuchotsera kwakukulu kwa deta imodzi kuchokera pamtundu
Koma nthawi zina muyenera kuchita zosiyana ndi zomwe, kuti adilesiyo isasinthe mukamakopera, koma imangokhala, kutanthauza selo yina. Kodi mungachite bwanji izi?
- Timalowa mu cell yoyamba kuti tiwonetse zotsatira za kuwerengera kosiyanasiyana. Timayika chikwangwani zofanana. Timadula khungu lomwe amachepetsa. Khazikitsani chikwangwani opanda. Timalankhula pagawo lodzipereka, adilesi yomwe siyisinthidwe.
- Ndipo tsopano tikutengera kusiyana kofunikira kwambiri pakati pa njirayi ndi yapita. Ndi chinthu chotsatira chomwe chimakupatsani mwayi woti musinthe ulumikizowu kuchokera pa wachibale kupita ku mtheradi. Tikuyika chikwangwani cha dollar patsogolo pamagulu owongoka ndi opingasa a cell omwe adilesi yake siyisintha.
- Timadina kiyibodi pa fungulo Lowani, yomwe imakupatsani mwayi wowonetsa kuwerengera pamzerewu pazenera.
- Kuti muwerengere pamizere inanso, monga momwe anachitira m'mbuyomu, imbani cholembera ndikuchikokera pansi.
- Monga mukuwonera, ntchito yochotsedwayo idachitika momwe timafunikira. Ndiye kuti, mukasunthira pansi, ma adilesi a data yochepetsedwa adasinthidwa, koma omwe adasinthidwa sanasinthe.
Chitsanzo pamwambapa ndi mlandu wapadera. Mofananamo, zitha kuchitidwa mwanjira yina mozungulira kuti zopatsidwazo zikhalebe zosagwirizana ndipo zoperekazo ndizosiyana komanso zisinthe.
Phunziro: Zolumikizana kwathunthu ndi abale ku Excel
Monga mukuwonera, palibe chovuta kudziwa bwino njira yochotsera anthu ku Excel. Imachitidwa molingana ndi malamulo omwewo amawerengera ena masamu pakugwiritsa ntchito. Kudziwa mfundo zina zosangalatsa kudzalola kuti wogwiritsa ntchito molondola agwiritse ntchito zambiri pogwiritsa ntchito masamu, zomwe zimapulumutsa nthawi yake.
