Nigute ushobora gukora inyuguti zose mumurwa mukuru muri excel

Mu bihe bimwe, inyandiko yose mu nyandiko za Excel irasabwa kwandika mu rubanza rwo hejuru, ni ukuvuga ku nyuguti nkuru. Kenshi na kenshi, kurugero, birakenewe mugihe utanga porogaramu cyangwa gutangaza ibigo bitandukanye bya leta. Kwandika inyandiko mumabaruwa manini kuri clavier hari buto yo gufunga caps. Iyo bikandaga, uburyo butangira, aho inyuguti zose zinjiye zizaba umurwa mukuru cyangwa, nkuko babivuga ukundi, umurwa mukuru.

Ariko icyo gukora niba umukoresha yibagiwe guhinduranya cyangwa kumenya ko inyuguti zikenewe zikorwa mumyandiko nini gusa nyuma yo kuyindika gusa nyuma yo kuyandika gusa? Ntugomba kongera kwandika ibintu byose? Ntibikenewe. Muri Excel, hari amahirwe yo gukemura iki kibazo byihuse kandi byoroshye. Reka tumenye uko twabikora.

Reba kandi: Nigute mu ijambo rikora inyandiko mu nyuguti nkuru

Guhindura inyuguti nto mu nyuguti nkuru

Niba muri gahunda yijambo kugirango uhindure inyuguti kumutwe (kwiyandikisha), birahagije kwerekana inyandiko yifuzwa, bishimangira buto yifuzwa hanyuma ukande ku rufunguzo rwa F3 kabiri, noneho ntizishoboka gukemura ikibazo muri Excel . Kugirango uhindure inyuguti nto kumutwe, ugomba gukoresha umurimo wihariye witwa kwiyandikisha, cyangwa ukoreshe macro.

Uburyo 1: Imikorere iteganijwe

Ubwa mbere, reka turebe akazi k'umukoresha kwanditswe. Uhereye ku mutwe uhita ugaragara ko intego nyamukuru yayo ari uguhindura amabaruwa mumyandiko mumyandikire. Imikorere yagenewe icyiciro cyanditse Excel. Syntax yayo biroroshye kandi isa nkibi:

= Byerekanwe (inyandiko)

Nkuko mubibona, uwakoresha afite impaka imwe gusa - "inyandiko". Iyi mpaka irashobora kuba imvugo yimyandiko cyangwa, kenshi, yerekeza kuri selile irimo inyandiko. Iyi nyandiko niyi formula kandi ihinduka kugirango yandike murwego rwo hejuru.

Noneho reka tubimenye kurugero runaka, uburyo umukoresha arimo gukora neza. Dufite ameza nukuri kubakozi b'ikigo. Izina ryanditswe muburyo busanzwe, ni ukuvuga inyuguti yambere yumutwe, hamwe ninyuguti nto. Igikorwa ninzandiko zose zo gukora igishoro (igishoro).

1. Turagaragaza selile irimo ubusa kurupapuro. Ariko biroroshye niba iherereye mumikino ibangikanye niyindi amazina yanditse. Ibikurikira, kanda kuri buto "yanditseho", ishyirwa ibumoso bwumugozi wa formula.



2. Ikirangantego Wizard Idirishya ritangira. Twimukiye mucyiciro "inyandiko". Turabona kandi tukagaragaza izina ryanditswe, hanyuma ukande buto "OK".



3. Imikorere yimpaka zabakoresha idirishya rirakorwa. Nkuko tubibona, muriyi idirishya umurima umwe gusa uhuye nimpaka zonyine kumikorere - "inyandiko". Tugomba kwinjiza aderesi ya mbere mu nkingi n'amazina y'abakozi muriki gice. Ibi birashobora gukorwa intoki. Kuba wavuye muri clavier ihuza. Hariho kandi amahitamo ya kabiri yoroshye. Dushiraho indanga mu murima "inyandiko", hanyuma ukande ku kagari k'ameza, aho izina rya mbere ry'umukozi riherereye. Nkuko mubibona, aderesi nyuma yibyo yerekanwe mumurima. Noneho tugomba gukora barcode yanyuma muriyi idirishya - kanda buto ya "OK".



4. Nyuma yiki gikorwa, ibikubiye muri selire ya mbere yinkingi namazina yerekanwe muburyo mbere yihariye aho formula irimo neza. Ariko, nkuko tubibona, amagambo yose yerekanwe muri kall agizwe gusa ninyuguti nkuru.



5. Noneho dukeneye guhindura no ku zindi selile zose zinkingi n'amazina y'abakozi. Mubisanzwe, ntituzakoresha formulaire itandukanye kuri buri mukozi, ahubwo dukoporore ikimenyetso cyuzuyemo ikimenyetso cyifashishije ikimenyetso. Kugirango ukore ibi, shiraho indanga kuruhande rwiburyo bwiburyo bwibibabi, birimo formula. Nyuma yibyo, indanga igomba guhinduka ikimenyetso cyuzuye, isa numusaraba muto. Tubyara Clamp ibumoso buto buto hanyuma dukurura ikimenyetso cyuzuye kumubare wa selile uhwanye numubare wabo mu nkingi namazina yabakozi bo mu ruganda rwimishinga.



6. Nkuko mubibona, nyuma yibikorwa byagenwe, amazina yose yerekanwe muri kopi kandi icyarimwe bigizwe ninyuguti nkuru.



7. Ariko ubu indangagaciro zose mubitabo dukeneye ni kure yimeza. Tugomba kubashyira mumeza. Kugira ngo dukore ibi, tugenera selile zose zuzuyemo formulaire. Nyuma yibyo, kanda ahanditse Kugaragaza buto yimbeba iburyo. Mubice bikubiyemo ibikubiyemo, hitamo "kopi".



8. Nyuma yibyo, tugaragaza inkingi yitwa izina ryabakozi b'ikigo kumeza. Kanda ku nkingi yeguriwe hamwe na buto yimbeba iburyo. Ibikubiyemo byatangijwe. Muri "Shyiramo ibipimo" bikurikirana, hitamo "igishushanyo", cyerekanwe nka kare ikubiyemo imibare.



9. Nyuma yibi bikorwa, nkuko tubibona, verisiyo yahinduwe yo kwandika amazina mu nyuguti nkuru zizinjizwa mumeza yinkomoko. Noneho urashobora gusiba intera yuzuye ibitekerezo, kuko bitagikenewe. Turabigaragaza hanyuma ukande buto yimbeba iburyo. Mubice bikubiyemo, hitamo "Isuku Ibirimo".

Nyuma yibyo, kora kumeza kugirango uhindure inyuguti mumazina yabakozi ku murwa mukuru urashobora gufatwa nkuzuye.

Isomo: Master of Imikorere muri Excele

Uburyo 2: Gusaba Macro

Gukemura umurimo wo guhindura inyuguti nto kumurwa mukuru muri Excel birashobora kandi gukoreshwa na macro. Ariko mbere yuko utashyiramo akazi na macros muri verisiyo yawe ya porogaramu, ugomba gukora iyi miterere.

1. Nyuma yo gukora umurimo wa macros, tugaragaza intera ukeneye guhindura amabaruwa kubitabo byo hejuru. Noneho wandikira urufunguzo rwa clavier Alt + F11.



2. Idirishya rya Microsoft ryerekana. Ibi, mubyukuri, umwanditsi wa macros. Turashaka Ctrl + g guhuza. Nkuko mubibona, indanga yimuka mumurima wo hasi.



3. Twinjiye kode ikurikira muri uyu murima:

   Kuri buri C muguhitamo: c.Aval = ucase (c): Ibikurikira

   Noneho kanda kuri Enter Urufunguzo hanyuma ufunge idirishya ryibanze hamwe nuburyo busanzwe, nibyo, ukanze kuri buto yo gusoza muburyo bwumusaraba mugice cyiburyo.



4. Nkuko tubibona, nyuma yo gukora manipulations yavuzwe haruguru, amakuru mumurongo wabigenewe arahindurwa. Noneho bari bagizwe rwose ninyuguti nkuru.

Isomo: Nigute wakora macro muri excel

Kugirango ugereranye vuba inyuguti zose mumyandiko uhereye kumurongo mu murwa mukuru, aho gutakaza umwanya wo gutangiza igitabo cyacyo kuri clavier, hari inzira ebyiri zo usibye. Iya mbere murizo ikubiyemo gukoresha imikorere yanditswe. Ihitamo rya kabiri ntiriroha kandi byihuse. Ariko ishingiye kuri macros, bityo iki gikoresho kigomba gukorwa murugero rwawe rwa gahunda. Ariko kwinjiza macros niho harebwa ingingo yinyongera yintege nke za sisitemu y'imikorere kubacengezi. Buri mukoresha rero yahisemo, niyihe muburyo bugaragara nibyiza gusaba.