Mwa ntchito zosiyanasiyana mu Excel zopangidwa kuti zizigwira ntchito ndi zolemba, wothandizira amayimira pazinthu zake zachilendo Kulondola. Ntchito yake ndikupeza anthu angapo kuchokera mu selo yodziwika, kuwerengera kumapeto. Tiphunzire mwatsatanetsatane za kuthekera kwa katswiriyu komanso za kusiyanitsa kwake ndi zina zotere.
Wogwiritsa ntchito PRIVSIMV
Ntchito Kulondola imatulutsa kuchokera pazomwe zalembedwa papepala kuchuluka kwa zilembo kumanja komwe wogwiritsa ntchitoyo akuwonetsa. Imawonetsa zotsatira zomaliza mu cell yomwe ili. Ntchitoyi ndi ya gulu la zolembedwa za Excel. Matchulidwe ake ndi awa:
= RIGHT (zolemba; kuchuluka kwa zilembo)
Monga mukuwonera, ntchitoyo imangokhala ndi mfundo ziwiri zokha. Choyamba "Zolemba" imatha kukhala ngati mawu amodzi kapena kulumikizana ndi china chake. Mbali yoyamba, wothandizirayo atulutsa manambala amtunduwu pamawu omwe atchulidwa kuti ndiwo mkangano. Kachiwiri, ntchitoyo "kuzula" zilembo kuchokera pamawu omwe ali mgawelo.
Mtsutso wachiwiri ndi "Chiwerengero cha otchulidwa" - ndi nambala yakuwonetsera ndendende kuchuluka kwa zilembo zamawu, kuwerengera kumanja, kuyenera kuwonetsedwa mu foni chandulo. Mkanganowu ndi wosankha. Mukachichotsa, amaonedwa kuti ndi chofanana, ndiye kuti, chithunzi chokhacho chomaliza cha chinthu chomwe chawonetsedwa chikuwonetsedwa mu foni.
Njira yothandizira
Tsopano tiyeni tiwone momwe ntchitoyo imagwirira ntchito Kulondola pa chitsanzo cha konkriti.
Mwachitsanzo tidzatenga mndandanda wa ogwira nawo bizinesi. Pa mzere woyamba wa tebulo ili pali mayina a antchito limodzi ndi manambala a foni. Tikufuna manambala pogwiritsa ntchito ntchito Kulondola ikani pambali ina, yomwe imatchedwa Nambala yafoni.
- Sankhani selo yoyamba yopanda chilichonse. Nambala yafoni. Dinani pachizindikiro. "Ikani ntchito", yomwe ili kumanzere kwa baramu yamu formula.
- Ntchito Yazenera Ikuchitika Ogwira Ntchito. Pitani ku gulu "Zolemba". Kuchokera mndandanda wazinthu zowonetsedwa PRAVSIMV. Dinani batani. "Zabwino".
- Window Yogwiritsa Ntchito Itsegulidwa Kulondola. Ili ndi magawo awiri omwe amagwirizana ndi malingaliro amtunduwu wotchulidwa. M'munda "Zolemba" muyenera kutchula ulalo wa khungu loyambirira la chipilalacho "Dzinalo", yomwe ili ndi dzina la wantchito ndi nambala yafoni. Adilesiyi akhoza kutchulidwa pamanja, koma tizichita mosiyanasiyana. Khazikitsani chotembezera m'munda "Zolemba", kenako dinani kumanzere mu cell yomwe ma konitor awo ayenera kulowetsedwa. Pambuyo pake, adilesi imawonetsedwa pazenera zotsutsana.
M'munda "Chiwerengero cha otchulidwa" lowetsani nambala kuchokera kubulogu "5". Nambala ya manambala asanu imakhala ndi nambala yafoni ya wogwira ntchito aliyense. Kuphatikiza apo, manambala onse a foni amapezeka kumapeto kwa maselo. Chifukwa chake, kuti tiwawonetse tokha, tiyenera kutengapo zilembo zisanu kumanzere kumanja.
Pambuyo pamasamba omwe atulutsidwa, dinani batani "Zabwino".
- Pambuyo pa izi, nambala yafoni ya wogwira ntchitoyo imaponyedwa mu foni yomwe idagawidwa kale. Inde, kuyambitsa kakhazikitsidwe payokha kwa munthu aliyense pamndandandawu ndi phunziro lalitali kwambiri, koma mutha kulipanga mwachangu, monga kukopera. Kuti muchite izi, ikani cholozera mu ngodya yakumanja ya chipinda chomwe chili kale Kulondola. Poterepa, chidziwitso chimasinthidwa kukhala chikhomo chodzaza ndi mawonekedwe amtanda waung'ono. Gwirani batani lamanzere lakumanzere ndikokera pomwepo mpaka kumapeto kwa tebulo.
- Tsopano mzere wonse Nambala yafoni yodzadza ndi mfundo zofananira kuchokera kumunsi "Dzinalo".
- Koma, ngati tiyesera kuchotsa manambala pafoni "Dzinalo"kenako ayamba kuzimiririka pachimwalacho Nambala yafoni. Izi ndichifukwa chakuti mbali zonse ziwirizi ndizolumikizana ndi chilinganizo. Kuti muchotse ubalewu, sankhani zonse zomwe zalembedwa Nambala yafoni. Kenako dinani chizindikiro Copyili pa nthiti mu tabu "Pofikira" pagulu lazida Clipboard. Mutha kuyang'ananso njira yaying'ono Ctrl + C.
- Komanso, osachotsa kusankha pamwambapa, dinani ndi batani labwino la mbewa. Pazosankha zam'maguluwo Ikani Zosankha sankhani "Makhalidwe".
- Pambuyo pake, deta yonse yomwe ili mgulu Nambala yafoni idzawonetsedwa ngati zilembo zodziyimira pawokha, osati chifukwa cha kuwerengera formula. Tsopano, ngati mungafune, mutha kuzimitsa manambala a foni "Dzinalo". Izi sizikhudza zomwe zili mgululi. Nambala yafoni.
Phunziro: Ntchito Wizard ku Excel
Monga mukuwonera, mwayi womwe ntchitoyo imapereka Kulondolakukhala ndi phindu lenileni. Pogwiritsa ntchito opaleshoni iyi, mutha kuwonetsa manambala omwe mukufuna kuchokera kumaselo omwe ali m'ndendemo, kuwerengera kuchokera kumapeto, ndiye kumanja. Wogwiritsa ntchitoyi amakhala othandiza makamaka ngati mukufuna kutulutsa nambala yomweyo kuchokera kumapeto mumaselo akuluakulu. Kugwiritsa ntchito chida chazomwezi kukupulumutsani nthawi yambiri.
