Pracem imikorere muri excel

Mubikorwa bitandukanye muri Excel, byateguwe gukorana ninyandiko, umukoresha yagenewe umukoresha wa Pracemir. Inshingano zayo ni ugukuramo selile yagenwe yumubare wagenwe, kubara uhereye kumpera. Reka twige byinshi kubijyanye nibishoboka byuyu mukoresha no kuri nonces yo kuyikoresha mubikorwa bifatika ku ngero zihariye.

Umukoresha Pratsim

Imikorere iboneye ikuraho ibintu byagenwe kurupapuro, umubare winyuguti iburyo, umukoresha ubwayo azerekana. Yerekana ibisubizo byanyuma muri ako kagari, aho biri wenyine. Iyi mikorere yerekeza ku cyiciro cyanditse cyabakoresha neza. Syntax yayo niyi ikurikira:

= Pracemir (inyandiko; umubare_izina)

Nkuko tubibona, imikorere ifite impaka ebyiri gusa. Iya mbere muribo "inyandiko" irashobora gufata imiterere yimyanzuro yonyine hanyuma yerekanwe kubibabi biherereyemo. Mu rubanza rwa mbere, umukoresha azakuramo umubare winyuguti uhereye kumagambo yerekanwe muburyo bwo gutongana. Mu rubanza rwa kabiri, imikorere ntishobora "gukubita" inyuguti zikubiye mu kagari kagenwe.

Impaka ya kabiri ni "umubare wibimenyetso" - ni agaciro k'umubare werekana umubare winyuguti mumyandiko, kubara iburyo, ugomba kwerekana muri selire. Iyi ngingo ntabwo ari itegeko. Niba byasibwe, bizera ko bingana na imwe, ni ukuvuga, gusa imiterere imwe iburyo yikintu cyagenwe cyerekanwa mu Kagari.

Urugero

Noneho reka turebe ishyirwa mubikorwa ryiburyo kumurimo wihariye.

Kurugero, fata urutonde rwabakozi b'ikigo. Mu nkingi yambere yiyi mbonerahamwe hari amazina yumuryango hamwe nimibare ya terefone. Dukeneye iyi mibare nkoresheje imikorere ya Russem kugirango dukureho inkingi itandukanye, yitwa "nimero ya terefone".

1. Turagaragaza selile yambere yubusa ya "Numero ya terefone". Kanda kuri "Shyiramo imikorere", bishyirwa ibumoso bwumugozi wa formula.



2. Imikorere yinyanja yidirishya ikora. Jya mucyiciro "Inyandiko". Kuva ku izina ry'urutonde rw'amazina, tugenera izina "Pracem". Tugasi muri buto "OK".



3. Impaka zabakoresha zumukoresha wa Pracem ufungura. Irimo imirima ibiri ihuye nimpaka zimikorere yagenwe. Mu murima "inyandiko", ugomba kwerekana icyerekezo cyambere "izina" ryambere inkingi, ikubiyemo izina ry'umukozi na nimero ya terefone. Aderesi irashobora gusobanurwa intoki, ariko tuzabikora muburyo butandukanye. Shyira indanga mu murima "inyandiko", hanyuma ukande buto yimbeba yibumoso ku mukorikori ukwiye gutangwa. Nyuma yibyo, aderesi yerekanwe mu idirishya ryimpaka.

   Muri "umubare wibimenyetso", twinjije umubare "5" uva kuri clavier. Ni kuva inyuguti eshanu nimero ya buri mukozi igizwe. Byongeye kandi, nimero za terefone zose ziherereye kumpera ya selile. Kubwibyo, kubazana ukwe, dukeneye gukuramo inyuguti eshanu muriyi selile iburyo.

   Nyuma yamakuru yavuzwe haruguru yinjiye, kanda kuri buto "OK".



4. Nyuma yiki gikorwa, nimero ya terefone yumukozi wagenwe yakuweho muri selire yabanjirije. Nibyo, andika formula yihariye ukundi kuri buri muntu kurutonde nisomo rirerire cyane, ariko urashobora gukora byihuse, aribyo kopi. Kugirango dukore ibi, dushyira indanga kuruhande rwiburyo bwiburyo bwa selile, rimaze kubamo formula ya pracem. Muri iki gihe, indanga yahinduwe ikimenyetso cyuzuye nkumusaraba muto. Kanda buto yimbeba hanyuma ukurura indanga kumanuka kugeza kumpera yameza.



5. Noneho inkingi yose "nimero ya terefone" yuzuyemo indangagaciro zijyanye n '"izina".



6. Ariko, niba tugerageje gukuraho inkingi ya terefone "izina", bazatangira kuzimira kuri numero ya terefone. Ibi birasobanurwa nukuri ko izi nkingi zombi zijyanye na formula. Kugirango usibe iyi sano, ugabanye ibiri muri "nimero ya terefone". Noneho ndakanda kuri "kopi", iri kuri rubbon muri tab ya "Guhana Buffer". Urashobora kandi guhamagara CTRL + C Ihuriro.



7. Ibikurikira, utakuyeho guhitamo inkingi yavuzwe haruguru, ndakanda kuri yo iburyo bwimbeba. Mubisobanuro bya menu mumatsinda y'ibipimo, hitamo umwanya "agaciro".



8. Nyuma yibyo, amakuru yose mumibare ya terefone azerekanwa nkinyuguti zigenga, kandi ntabwo ari ibisubizo byo kubara formula. Noneho, niba ubishaka, urashobora gusiba nimero ya terefone kurubuga rwinkingi. Ibi ntibizagira ingaruka ku mvugo ya "nimero ya terefone".

Isomo: Umukozi wa Wizard muri Excel

Nkuko mubibona, ibishoboka ko ibiranga Pracemir bitanga inyungu zifatika. Hamwe nuyu mukoresha, urashobora kwerekana umubare wifuzwa winyuguti ziva muri selile zagenwe ahantu hagaragara, kubara uhereye kumpera, ni ukuvuga iburyo. Uyu mukoresha azaba ingirakamaro cyane niba ari ngombwa gukuramo umubare umwe winyuguti uhereye kumpera ahantu hanini. Gukoresha formulare mubihe nkibi bizakiza cyane cyane umukoresha.