Imikorere ifata muri excel

Kimwe mubintu bishimishije bya Microsoft Explel Porogaramu ni imikorere ihuriweho. Igikorwa cyayo nyamukuru nuguhuza ibiri muri selile ebyiri cyangwa nyinshi muri imwe. Uyu mukoresha afasha gukemurabikorwa bimwe bidashobora kugaragazwa ukoresheje ibindi bikoresho. Kurugero, biroroshye gutanga inzira yo guhuza selile nta gihombo. Reba ibishoboka byiyi mikorere nibikoresho byo gukoresha.

Gukoresha Gukoresha Gufata

Imikorere ya Pain yerekeza ku itsinda ryanditse rya Excel. Igikorwa cyacyo nyamukuru ni uguhuza muri selile imwe yibiri muri selile nyinshi, hamwe ninyuguti kugiti cye. Guhera muri Excel 2016, aho kuba uyu mukoresha, imikorere yikarita irakoreshwa. Ariko kugirango uzigame inyuma guhuza, umukoresha arasigara, kandi arashobora gukoreshwa ku kabari.

Syntax yuyu mukoresha isa nkiyi:

= Gufata (inyandiko1; inyandiko2; ...)

Nkimpaka zishobora gukora nkinyandiko kandi zerekeza kuri selile zirimo. Umubare w'impaka urashobora gutandukana kuva 1 kugeza 255 urimo.

Uburyo 1: Guhuza amakuru muri selile

Nkuko mubizi, ibisanzwe guhuza selile muri Excel biganisha ku gutakaza amakuru. Gusa amakuru yabitswe mugice cyo hejuru cyo hejuru. Kugirango uhuze ibiri muri selile ebyiri kandi nyinshi zitarinda nta gihombo, urashobora gukoresha imikorere yo gufata.

1. Hitamo selile duteganya gushyira amakuru ahuriweho. Kanda kuri buto ya "Paste. Ifite isura ya pictogrades hanyuma igashyirwa ibumoso bwumugozi wa formula.



2. Umupfumu arakingura. Mu cyiciro "inyandiko" cyangwa "Urutonde rwuzuye rwinyuguti" Turimo gushaka "gufata" gufata. Turagaragaza iri zina hanyuma ukande kuri buto "OK".



3. Idirishya ry'ibiganiro ritangira. Nkimpaka, Reba selile zirimo amakuru cyangwa inyandiko itandukanye irashobora. Niba umurimo urimo guhuza ibiri muri selile, hanyuma muriki kibazo tuzakora gusa.

   Shyira indanga mu idirishya ryambere. Noneho hitamo umurongo kurupapuro aho amakuru asabwa mubumwe arimo. Nyuma yo guhuza byerekanwe mumadirishya, muburyo bumwe, dukora numurima wa kabiri. Kubera iyo mpamvu, tugenera akandi kagari. Dukora imikorere nkiyi mugihe ihuriro ryingirabuzimafatizo zose zigomba guhuzwa ntiziringirwa mubikorwa byitsinda. Nyuma yibyo, kanda kuri buto "OK".



4. Nkuko mubibona, ibikubiye mubice byatoranijwe byagaragaye muri selire imwe yambere. Ariko ubu buryo bufite ikibazo gikomeye. Iyo uyikoresha, ibyo bita "gluing nta gaciro" bibaho. Ni ukuvuga, hagati yamagambo nta mwanya kandi uhagaze muburyo bumwe. Mugihe kimwe, ntibizashoboka kongeramo intoki kugirango wongere umwanya, ariko gusa unyuze kuri formulaire.

Isomo: Umukozi wa Wizard muri Excel

Uburyo 2: Gushyira mubikorwa imikorere nu mwanya

Hariho amahirwe yo gukosora iki ntaho, shyiramo icyuho hagati yimpaka.

1. Turakora imirimo kuri algorithm imwe yasobanuwe haruguru.
2. Kanda inshuro ebyiri buto yimbeba yibumoso kuri selire hamwe na formula iyikora kugirango uhindure.



3. Hagati ya buri mpaka, andika imvugo muburyo bwumwanya ugarukira kumpande ebyiri hamwe na cote. Nyuma yo gukora buri gaciro nkayo, dushyira ingingo hamwe na koma. Kubona muri rusange imvugo yongeweho igomba kuba ibi bikurikira:

   " ";



4. Kugirango usohoke ibisubizo kuri ecran, kanda ahanditse Enter.

Nkuko mubibona, hariho amacakubiri hagati yamagambo mukagari mu kwinjiza icyuho hamwe na cotes muri selire.

Uburyo 3: Ongeraho umwanya ukoresheje idirishya

Birumvikana, niba ntamyanya mico myinshi yahinduwe, noneho hejuru yimiterere yimbuga iratunganye. Ariko bizagora gushyira mubikorwa byihuse niba hari selile nyinshi zigomba guhuzwa. Cyane cyane niba aya selile itari munzira imwe. Urashobora koroshya cyane gahunda yicyogajuru ukoresheje uburyo bwo gushyiramo ukoresheje idirishya ryimpaka.

1. Turagaragaza gukanda inshuro ebyiri buto yimbeba yibumoso hari selile irimo ubusa kurupapuro. Ukoresheje clavier, shyiramo umwanya imbere. Nibyifuzwa ko ari kure ya misif nkuru. Ni ngombwa cyane ko selile itigeze itigera iri kuzuzwa namakuru ayo ari yo yose.



2. Dukora ibikorwa bimwe nkuburyo bwa mbere bwo gukoresha imikorere kugirango dukore umurimo, kugeza ku gufungura ingingo za Oper. Ongeraho agaciro ka selile yambere hamwe namakuru mumurima widirishya, nkuko bimaze gusobanurwa mbere. Noneho shyira indanga kumurima wa kabiri, hanyuma uhitemo selile irimo ubusa hamwe numwanya waganiriweho mbere. Umurongo ugaragara mu idirishya ryamadirishya. Kwihutisha inzira, urashobora kuyandukura ukabigaragaza kandi ukanda CTRL + C Ihuriro.



3. Noneho ongeraho ihuriro kubintu bikurikira ushaka kongeramo. Mu murima utaha, ongeraho umurongo kuri selile irimo ubusa. Kubera ko twandukuye aderesi yacyo, urashobora gushiraho indanga mumurima hanyuma ukande Ctrl + V urufunguzo. Guhuza bizashyirwamo. Muri ubu buryo, dusimburana imirima hamwe na aderesi yibintu na selile irimo ubusa. Nyuma yamakuru yose akorwa, kanda kuri buto "OK".

Nkuko mubibona, nyuma yibyo, hashyizweho inyandiko ihuriweho muri selile igenewe, ikubiyemo ibikubiye mubintu byose, ariko hamwe numwanya uri hagati ya buri jambo.

Icyitonderwa! Nkuko tubibona, uburyo bwavuzwe haruguru bwihutisha uburyo bwo guhuza neza amakuru muri selile. Ariko birakenewe gutekereza ko aya mahitamo ari yo ubwayo na "imitego". Ni ngombwa cyane ko mubintu birimo umwanya udafite amakuru cyangwa ntabwo yahinduwe.

Uburyo 4: Ubumwe bwinkingi

Ukoresheje imikorere iboneza, urashobora guhita uhungaba inkingi muri imwe.

1. Hamwe na selile yumurongo wambere winkingi zahujwe, twakuyeho guhitamo ibikorwa byerekanwe muburyo bwa kabiri nuwa gatatu bwo gushyira impaka. Nukuri, niba uhisemo gukoresha inzira hamwe na selile irimo ubusa, noneho umurongo wabyo uzakenera gukora byuzuye. Kubwibi, mbere yuko buri kimenyetso gihuza itambitse kandi ihagaritse iyi selire ishyiraho ikimenyetso cyamadorari ($). Mubisanzwe, nibyiza kubikora mugitangira kimwe muriyi nzego zirimo iyi aderesi irimo, umukoresha arashobora kuyafata nkibikubiyemo bihuje imbere. Mumirima isigaye, turasiga amahuza ugereranije. Nkuko bisanzwe, nyuma yo gukora inzira, kanda kuri buto ya "OK".



2. Dushiraho indanga kuruhande rwiburyo bwiburyo bwibintu bifite formula. Agashusho kagaragara, gifite icyerekezo cyambukiranya, cyitwa Ikimenyetso cyuzuye. Kanda buto yimbeba yibumoso hanyuma uyikure hasi ugereranije ahantu hamwe nibintu byahujwe.



3. Nyuma yo gukora ubu buryo, amakuru mumirongo yerekanwe azahuzwa mu nkingi imwe.

Isomo: Uburyo bwo guhuza inkingi mu buhungiro

Uburyo 5: Ongeraho inyuguti zinyongera

Urashobora kandi guhatira imikorere kugirango wongere inyuguti nimvugo itari mu buryo bwambere. Byongeye kandi, urashobora gushyira mubikorwa abandi bakozi bakoresheje iyi miterere.

1. Kora ibikorwa kugirango wongere indangagaciro mu idirishya ryimikorere muburyo ubwo aribwo bwose bwatanzwe hejuru. Muri imwe mumirima (nibiba ngombwa, hashobora kuba benshi muribo) ongeraho ibikoresho byose umukoresha abona ko ari ngombwa kongera kongeramo. Iyi nyandiko igomba kuba ifunze muri cote. Kanda kuri buto ya "OK".



2. Nkuko tubibona, nyuma yiki gikorwa cyamakuru hamwe, ibikoresho byinyandiko byongeweho.

Gufata Gufata - Inzira yonyine yo guhuza selile nta gihombo muri Excel. Byongeye kandi, hamwe nayo, urashobora guhuza inkingi zose, ongeraho indangagaciro, kora izindi manipulations. Ubumenyi bwakazi Algorithm hamwe niyi mikorere bizoroha gukemura ibibazo byinshi kuri gahunda ya gahunda.