Excel Gushakisha ikora

Umwe cyane bashaka-nyuma operators hagati Abakoresha Excel ni Umumaro Bya i Shakisha. Ibikorwa byayo harimo igisobanuro Ikintu mwanya umubare mu bahawe urugamba Ibyatanzwe. Bituma inyungu kuruta igihe rikoreshwa mu nyubakwa na operators n'ibindi. Reka yafashe icyo ni igikorwa wa cyumba search, n'uburyo bishobora gukoreshwa mu bikorwa.

Porogaramu ya umugurisha ya kibaho search

Gushakisha serivisi umugurisha iya cyiciro mirimo "Links na tutabonwa". Ni habaho Ikigize in i urugamba runaka n'ibibazo kibanza cayo Urutonde iyi mu kagari bitandukanye. Mu by'ukuri, nanone igaragaza izina rye. Nanone iyi Ikiranga ni Byakoreshejwe in A urusobe na operators ruhande, rumenyesha bo mwanya umubare a Ikigize kuko gutunganya nyuma ya data iyi.

Mu Igaragaza rya umugurisha y'ishakisha-gitabo nka iyi:

= Gushakisha y'ubutegetsi (search_name; viewing__nassive; [type_station])

Noneho zirikana buri batatu impaka izo ukwayo.

"Agaciro yifuzaga" ni kimwe mu bintu bigize ko bagomba kuboneka. Bishobora kuba Umwandiko, ifishi Bikurikije umubare, ndetse ngo agaciro bwumvikana. A Indango Kuri A kagari, ifite cyose Uduciro haruguru bishobora kandi kuba ari impaka iyi.

"Listful urugamba" ni i Urutonde Bya i Urutonde in agaciro yifuzaga iherereye. Ni umwanya Ikigize iyi urugamba ko bagomba kumenya umugurisha ya kibaho search.

"Ubwoko bwa Mapping" igaragaza bihurirana NYACYO gushaka cyangwa atari ukuri. impaka Ibi bishobora kugira insobanuro batatu: "1", "0" na "-1". Na "0" agaciro, umuhinzi ashaka gusa byapfuye NYACYO. Niba agaciro "1" ni runaka, hanyuma mu adahari bikwiranye butagira, gushakisha bazaragwa Ikigize hafi ko amanuka. Niba agaciro ni "-1", rero mu rubanza bihurirana NYACYO si hakiri, i Umumaro kugaragarizanya Ikigize hafi ko aduga. Ni ngombwa niba nta agaciro nyakuri, ariko kugereranya kugira urugamba ni ategeka ari kwiyongera (bwoko ugereranije "1") cyangwa amanuka (bwoko ugereranije "-1").

Ingingo ya "Mapping Ubwoko" si itegeko. Bishobora kuboneka niba nta mpamvu. Muri urwo rubanza, agaciro kayo Mburabuzi ni "1". Ngiro "Ubwoko tugereranye" impaka, mbere bose, gusa birumvikana igihe indangagaciro k'umubare ni gutunganyirizwa, nta Umwandiko.

Niba gushakisha Igenamiterere runaka badashobora kubona Ikintu yifuzaga, mu kivyerekana umugurisha ku "# H / D" ikosa mu kagari.

Iyo gushakisha, umuhinzi nta itandukaniro Inyuguti rejisitiri. Niba hari kwiyadukiza nyinshi butagira urugamba mu rero gushakisha mbere bo mu kagari.

Uburyo 1: Yerekana umwanya wikintu mumakuru ya bande

Reka turebe urugero rwimanza zoroshye mugihe dukoresheje ubushakashatsi hafi ushobora kumenya aho ikintu cyagenwe mumakuru yandika. Turashaka aho imyanya iri murwego amazina yibicuruzwa, afata ijambo "isukari".

1. Hitamo akagari aho ibisubizo byatunganijwe bizerekanwa. Kanda kuri "Shyiramo imikorere" hafi ya formula.



2. Kuyobora umupfumu wimirimo. Fungura icyiciro "Urutonde rwinyuguti zuzuye" cyangwa "guhuza na barray". Kurutonde rwabakoresha bashaka izina "isosiyete ishakisha". Kubona no kubigaragaza, kanda buto "OK" hepfo yidirishya.



3. Idirishya ryamadirishya yumukoresha ushakisha urakora. Nkuko mubibona, muriyi idirishya, ukurikije umubare w'impaka hari imirima itatu. Tugomba kuzuza.

   Kubera ko dukeneye kubona umwanya w'ijambo "isukari" mu ru rwego, noneho twirukana iri zina muri "filty".

   Muri "urutonde rwa" urutonde ", ugomba kwerekana guhuza intera ubwayo. Irashobora kuyirukana intoki, ariko biroroshye gushiraho indanga mumurima hanyuma uhitemo iyi array kurupapuro, yiziritse kuri buto yimbeba yibumoso. Nyuma yibyo, aderesi yacyo izagaragara mu idirishya ryimpaka.

   Mu rwego rwa gatatu "ubwoko bwo kugereranya", twashyizeho umubare "0", nkuko dukorana namakuru yinyandiko, bityo dukeneye ibisubizo nyabyo.

   Nyuma yamakuru yose yashyizweho, kanda kuri buto "OK".



4. Porogaramu ikora kubara no kwerekana umubare ukurikirana wa "isukari" mu murongo wagaragaye mu kagari twasobanuye mu ntambwe yambere yiyi nyigisho. Umubare w'imyanya uzaba "4".

Isomo: Master of Imikorere muri Excele

Uburyo 2: Gukora imyitozo yo gusaba gushakisha

Hejuru, twarebye mugihe cyambere cyo gusaba umurongo wa sosiyete ishakisha, ariko niyo byashobokaga.

1. Kugirango byoroshye ku rupapuro, ongeraho izindi nyongera zindi: "Urwego" na "Umubare". Muri "inoti", utwara izina kugirango ubone. Reka reka "inyama." Muri "umubare", twashizeho indanga kandi tujya ku mpaka zabakoresha mu buryo bumwe ko ikiganiro cyari hejuru.



2. Mubikorwa impaka zikora muri "umurima", sobanura aderesi ya selile aho ijambo "inyama" ryanditswe. Mu murima "ureba binyuze muri array" na "kugereranya", erekana amakuru amwe nkuko bisanzwe - aderesi ya intera n'umubare "0 0". Nyuma yibyo, kanda kuri buto "OK".



3. Tumaze gukora ibikorwa byavuzwe haruguru, umurima wa "Umubare" uzerekana umwanya wijambo "inyama" mugihe cyatoranijwe. Muri uru rubanza, bingana na "3".



4. Ubu buryo ni bwiza kuko dushaka kumenya umwanya windi zina, ntabwo bizakenerwa gushaka cyangwa guhindura formula buri gihe. Birahagije kugirango winjire ijambo rishya ryinkuru aho kuba uwabanjirije muri "FirPoint". Gutunganya no gutanga ibisubizo nyuma yibi bizabaho mu buryo bwikora.

Uburyo 3: Gukoresha ushakisha umukoresha kugirango ubone imibare

Noneho reka turebe uko ushobora gukoresha gushakisha akazi hamwe nimvugo yubwige.

Igikorwa nukubona ibicuruzwa bingana no gushyira mubikorwa amafaranga 400 cyangwa hafi yaya mafaranga azamuka.

1. Mbere ya byose, dukeneye gutondekanya ibintu biri mumaguru bimanuka. Tugenera iyi nkingi hanyuma tugakomeza kuri tab "urugo". Kanda kuri "Sort hanyuma uyunguruzo", uherereye kuri kaseti mu gice cyo guhindura. Kurutonde rugaragara, hitamo ikintu "uva kuri ntarengwa kugeza byibuze".



2. Nyuma yo gutondeka, hitamo selile aho ibisubizo bizerekanwa, hanyuma utangire idirishya ryimpaka muburyo tumeze nkamagambo muburyo bwa mbere.

   Mu murima "udafite agaciro", gutwara umubare "400". Muri "urutonde rwa" urutonde ", tugaragaza isano yinkingi" umubare ". Mu murima "Ikarita yo gushushanya", shyira agaciro "-1", nkuko tudashakisha agaciro kangana cyangwa gakomeye kanini kubyo wifuza. Nyuma yo gukora igenamiterere ryose, kanda buto "OK".



3. Ibisubizo byo gutunganya byerekanwe mumashori yateguwe. Uyu niwo mwanya "3". Ihuye n '"ibirayi". Mubyukuri, umubare winjiza uhereye ku gicuruzwa ni wegereye umubare wa 400 uzamuka kandi uhwanye na 450.

Mu buryo nk'ubwo, urashobora gushakisha umwanya wa hafi kuri "400". Gusa kubwibi ukeneye gushungura amakuru azamuka, kandi muburyo bwa "ubwoko bwamakarita" yimpaka zikorwa "1".

Isomo: Gutondekanya no Gushungura amakuru kuri Excel

Uburyo 4: Koresha hamwe nabandi bakoresha

Nibyiza gukoresha iyi mikorere nabandi bakora mubice bya formulaire. Birakunze gukoreshwa muri bundle hamwe nuburyo bwo kwerekana. Iyi mpaka yerekana ibiri kumurongo cyangwa inkingi kuri selile. Byongeye kandi, umubare, nko mubijyanye numukoresha, Inama yubushakashatsi ntabwo ijyanye nurupapuro rwose, ariko murwego rumwe gusa. Syntax yiyi miterere ni izi zikurikira:

= Indangagaciro (array; numero_lunk; umubare_number)

Mugihe kimwe, niba array ari urwego rumwe, noneho urashobora gukoresha kimwe mubiganiro bibiri: "Umubare wumurongo" cyangwa "nimero yinkingi".

Ikiranga imikorere ya ligament Urutonde nubuyobozi bwo gushakisha nuko aba nyuma bashobora gukoreshwa nkimpaka za mbere, ni ukuvuga kwerekana umurongo cyangwa inkingi.

Reka turebe nkuko byakorwa mubikorwa ukoresheje ameza amwe. Duhura ninshingano yo kuzana izina ryibicuruzwa murwego rwinyongera izina ryibicuruzwa, umubare rusange wamafaranga ava kuri konte 350 cyangwa hafi yagaciro ukomanuka. Iyi mpaka igaragara muri "hafi yinjiza" kurupapuro.

1. Gutondekanya ibintu muri "Amafaranga yinjiza" mu nkingi izamuka. Kugirango ukore ibi, hitamo inkingi yifuzwa kandi, mugihe uri muri tab "murugo", kanda kuri "Sort hanyuma muri menu" hanyuma muri menu zigaragara ukanze kuri "Sort kuva byibuze kugirango" ikintu.



2. Hitamo akagari muri "Ibicuruzwa" hanyuma uhamagare imirimo yimikorere muburyo busanzwe binyuze muri buto "Shyiramo imikorere".



3. Mu idirishya ry'imikorere mu cyiciro "Reba na Arrays" ushakisha izina "indangagaciro", turaryoha no gukanda kuri buto ya "OK".



4. Idirishya rikurikira rirafungura, ritanga guhitamo uburyo bwo guhitamo. Ironderero: kubisobanuro cyangwa kubisobanuro. Dukeneye amahitamo yambere. Kubwibyo, dusiga igenamiterere ryose risanzwe muriyi idirishya hanyuma ukande buto ya "OK".



5. Idirishya ry'impaka rifungura imikorere yerekana. Muri "array", sobanura aderesi yurutonde rwabakoresha zizashakisha izina ryibicuruzwa. Kuri twe, iyi niyo nkingi "izina ryibicuruzwa".

   Umwambaro wa "umurongo" umurima uzaboneka umurimo washyizwemo. Bizagomba kunyura mu ntoki ukoresheje syntax ivugwa mu ntangiriro yingingo. Hanze wandike izina ryimikorere - "Inama shakisha" nta magambo. Noneho fungura kumera. Impaka ya mbere yuyu mukoresha ni "agaciro ka wifuza". Iherereye ku rupapuro rwa "amafaranga agereranijwe". Erekana imirongo ya selile irimo umubare wa 350. Dushyizeho ingingo hamwe na koma. Impaka ya kabiri ni "array". Ubuyobozi bwo gushakisha buzareba urwego umubare wamafaranga uherereye kandi ushakishe amafaranga agera kuri 350. Kubwibyo, muriki gihe, tugaragaza isano ya "amafaranga yinjiza". Ongera ushyireho ingingo hamwe na koma. Impaka ya gatatu ni "ubwoko bwo kugereranya". Kubera ko tuzashakisha umubare uhwanye ninda cyangwa hafi ya hafi, twashizeho umubare "1" hano. Gufunga imigozi.

   Imikorere ya gatatu ikora urutonde "nimero yinkingi" isigaye. Nyuma yibyo, kanda kuri buto "OK".



6. Nkuko mubibona, imikorere yimpapuro hamwe nubufasha bwo gushakisha muri selile yagenwe yerekana izina "icyayi". Mubyukuri, amafaranga yatanzwe nicyayi (Rubles 300) yegereye gahunda yo kumanuka kumafaranga 350 yimyambarire ya 350 uhereye kumuranga



7. Niba duhinduye umubare mubibuga "byagereranijwe" kurindi, noneho ibikubiye muri "ibicuruzwa" bizahita byitabwaho.

Isomo: Ironderero ryimikorere muri Excel

Nkuko mubibona, umukoresha wishakisha nigikorwa cyoroshye cyane kumenya umubare wikintu cyagenwe muri data array. Ariko inyungu zazo ziyongera cyane niba ikoreshwa muburyo bunoze.